Access 2013 size limits

[rileydog]

I am supporting a VB.net 2010 desktop application that updates Access 2013 database files. I am wondering what the size limit is for the Access 2013 database and individual tables are?

Also if an Access database is too large, what do you do to solve the problem? Do you 'linked servers' Access databases together? Can you tell me what you do to solve the problem with detail directions and/or point me to an applicable url?

 

[Micron]

AFAIK, the upper limit is 2GB.

Also if an Access database is too large, what do you do to solve the problem?

One option is to switch to SqlServer as a back end because it has a much higher size limit. The downside is that the sql syntax is not exactly the same as Access. Another is to ensure you have split the db and put all forms, reports, queries, modules and macros in the front end. Other options include archiving data you don't need often, or splitting tables into separate db's and link them to your FE. There's a lot of info out there with options that should help you take the direction you need if you're willing to do a bit of 'click' work.