Linking Tables through ODBC in MS Access

cartlidge · Joined: 10 Apr 2006 Posts: 1

I have sort of a situation with tables ODBC-linked to a DB in Access 2003. The thing is, one of them cuts of at about ¾ of the way down, not showing the lower quarter of the fields. The other tables look perfectly OK, and it's just this one that doesn't display correctly. What could cause this, and how to I avoid it? I don't suppose there's some internally set field limit, is there? Any thoughts?

allers · Joined: 10 Apr 2006 Posts: 1

The only limit I know of would be the standard one – Access is set to a maximum of 255 columns. If your table has 320 or so fields, it would probably be cut off at about three quarters. If that's not it, you might want to reexamine the naming convention near the problematic fields – Access could have issues with a certain field name and decide to cut the table there.

H-Desk.com - PC Security matters - Protect your PC privacy

Linking Tables through ODBC in MS Access

LIFEFORM SOCIAL COMMUNITY NETWORK