Compact and Repair problem

[ADG]

I have update a database from Access 97 to Access 2003. When I compact and
repair the database db1 creates and is left in the directory, but Access does
not do the rename and delete. So I am left with the original db uncompacted
and db1. I have seen this behaviour on another one of my db's created as a
2003 db.

Anyone else had this problem and found a fix?

Regards

Tony G

 

[Arvin Meyer [MVP]]

There may be some uncompilable code in the database, or it may be slightly
corrupted. I'd open the db1 file and see if it has everything in it. I'd
then check to make sure that all the references are intact and that the code
compiles. Once everything is corrected, I'd rename the old file. Then name
the new one to the old name and try a Compact and Repair.

 

[Jerry Whittle]

First check your permissions for the folder holding the database mdb or accdb
files. You need read, write, create, and delete. Basically full permission or
modify.

If that doesn't work, there may be a problem with the database file that
won't let it compact and repair properly. You could download the Microsoft
JetComp utility as it does a better job plus forces you to create a backup -
always a good idea.

Also make sure that the code is compiled. With the database in question, do
a Ctrl + g. When the VB window opens up, go to Debug then Compile. It should
be the first option. If it's grayed out, it's already fully compiled.

 

[ADG]

Thanks for the reply. I have full permissions for the folder. I made a small
code change and recompiled the code OK. I have taken one of the databases
created and renamed it, when I compact this new database it behaves the same
way. The new db had all the objects in the old DB. I will try to find the
utility you suggest on MSN and give it a go. The application concerned needs
a regular compacting as it loads and deletes our G/L transactions for
analysis which will be 250k reords per period!

Regards

Tony G

 

[Arvin Meyer [MVP]]

Does it behave this way on multiple computers? If so, you need to reinstall
on the computer that is creating the problem. Make sure that you uninstall,
reboot, then reinstall. If not, it may be a permissions issue not allowing
either a file to be created or deleted. Make sure that the folders in the
entire path have these permissions.