Does Access have a size limit?

[Jakboi]

Hello,

I am working on something and have to link I think a few thousand tables from a "store bought" database here at work. Is there a limit in regards to access? I know they are just linking but I didnt know if Access gets nutty after a while...

Anyone encounter functionality breakdown due to size or complexity?

Thanks.

 

[Len Boorman]

If you intend to link to a few thousand tables I think your problems are bigger than a size issue.

Think for Access it is 2Gb file with no table in excess of 1Gb

L

 

[Jakboi]

Well this is my issue. See we have a database and I may "over estimated" the number...I just called operations and they said 718 tables with 200 blank tables left.

I am trying to create a form with infopath that receives data from this database. However infopath cannot connect to the database via ODBC and thats currently how that database is setup. It has to be Access or Microsoft SQL. I think its the way they have it setup or so.

So I was going to import all the tables or link them in Access so I can connect to the data with my Infopath form.

Not sure if that makes sense....

 

[allan57]

try the link below for database specifications

http://www.databasedev.co.uk/access_specifications.html