[MS_AccessPros] RE: Does Access 2010's limits increase with SQL Server on BackEnd

 

Tim

No, the limits stay because you are using JET/ACE to fetch the data. Maybe if you were to use pass-through queries you could get more fields, but I can't say.

But you can break SQL tables up into views if their columns exceed the 255 limit. And I would question the need to have more than even 50 fields in a table.

__._,_.___

Reply via web post

Reply to sender

Reply to group

Start a New Topic

Messages in this topic (3)

Recent Activity:

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___