increase db size

[Aditya Malhotra]

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

[nico5038]

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)