Is there anyway to compact a database without making a copy of it? What I really want to do is to compact the database before I create a large table in the database which will be close to the 1 gb size which is the max for '97.
JoeMiller, I always get a space error if I reach 1 gb. What verson are you talking about? I'm using Access '97.
It's help files state:
"The Microsoft Jet database engine supports files up to a maximum of 1 gigabyte in size, but many users have limited space available on their hard disks."
If you are wanting to compact the DB without creating a copy of it, there is a utility from microsoft that will allow this.. its great.. I have used it for a long time now..
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.