By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,426 Members | 2,928 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,426 IT Pros & Developers. It's quick & easy.

increase db size

P: 1
my access db size is 2 gb, now my data is increasing i.e. more than 2 gb, here when i run some query it gives error.

how can i increase size of db from 2 gb to more .

please help
Oct 12 '07 #1
Share this Question
Share on Google+
1 Reply


nico5038
Expert 2.5K+
P: 3,072
Sorry, but the max size is 2 GB.
You have two ways to solve this:
1) Switch to using another database as backend, like the Free MySQL, Oracle or MS SQL
2) Divide your table(s) over multiple backend databases.
There's no limit when linking tables. For each table you can use a 2 Gb database.

Finally I would issue a regular "compact & repair", as Access sometimes spills a lot of space when many updates are performed on the tables and other objects.

Nic;o)
Oct 12 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.