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

Reaching 2gb limit in Access

P: 23
I am automating a process using Access 2003 (SP2) by importing csv files as tables. The amount of data was causing the database to reach the 2gb limit. Now I am deleting the tables after I am finished using them but, the database is still reaching the 2 gb limit. If I compact and repair the database it's size is 445mb. Is there a way to "refresh" the database to realize that the 2 gbs of data are no longer there without compacting and repairing? Any insight would be much appreciate.

CC
Dec 15 '08 #1
Share this Question
Share on Google+
1 Reply


missinglinq
Expert 2.5K+
P: 3,532
You could import all objects into a new, blank database, but I wouldn't think that would be any less trouble than a C&R. If you continue to Compact you should be aware that you should always make a backup copy before doing the C&R. The procedure is thought by many to carry the real threat of data corruption.

Linq ;0)>
Dec 15 '08 #2

Post your reply

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