Access Table Field Size Limit 1

[snoopy80]

Hi Everyone
I have an Access DB that link table to an SQL Table that has about 75 fields. When I create queries, I noticed not every field are shown in Access. Is there a field size limit in Access? if there is, how can I make it to see the rest of the field?
Thanks for help.

 

[smedvid]

255 is field length. Fields larger than 255 must be stored in a memo field. htwh,

Steve Medvid
IT Consultant & Web Master

http://www.saveourfarm.com

Chester County, PA Residents
Please Show Your Support...

 

[genomon]

There is also a complete list of Access database specs here:

http://www.databasezone.com/techdocs/acclimit.html

Ever notice how fast Windows runs? Me neither.

 

[snoopy80]

Thanks for your replies.
I actually mean to ask how many field I can have in a table.
According to Genomon's, it says 255 fields in a table, but I have 80 in SQL table and when I link it from Access, the last field I see is about 70th. Can you help me to make those field visible so I can include them in a query?
Thanks for your help.

 

[dhookom]

Try relink the table. All should be visible in the design view of the linked table.

Duane
Hook'D on Access
MS Access MVP

 

[snoopy80]

Thanks Dhookom. I relinked the table and now I can see the rest of the fileds. Thanks.
Also thanks to Genomon and Smedvid for your replies.
Thanks.