Connecting Tech Pros Worldwide Forums | Help | Site Map

Reaching 2gb limit in Access

Newbie
 
Join Date: Oct 2007
Posts: 20
#1: Dec 15 '08
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

missinglinq's Avatar
Moderator
 
Join Date: Nov 2006
Location: Richmond, Virginia USA
Posts: 3,000
#2: Dec 15 '08

re: Reaching 2gb limit in Access


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)>
Reply


Similar Microsoft Access / VBA bytes