If you open Access '97 with or without a database click th e "tools" menu then "Database utilities" the "compact"
In Access 2000 "Compact and repair"
Everyone has to be out of the database and if there is any VBA code that is not debuged it will not let you compact it.
If you have any problems with the database they will show up in this process.
If you do get an error write down the exact words and make a new Post here.
DougP, MCP
dposton@universal1.com
Ask me how Bar-codes can help you be more productive.
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.