Automatic deletion of backup 'database' file

[stemach1]

Hello,
I'm running Access 2007 on XP and I'm running my database over 4 machines, when I run it on 2 certain machines then exit the database a duplicate file is created (in the same directory) called 'database.mdb' (my db is called 'sims.accdb'). If I don't delete this file then the next time I exit another file called 'database1.mdb' is created and so on.

When I run it on the other 2 machines no duplicate file is created but if your quick you can see it kinda 'delete' itself.

It's the first time I've ever noticed this, I've never had the backup file before, any ideas whats going on?

Regards

Steve.

 

[dkinley]

Is the database checked to compact database on close?

-dK

 

[stemach1]

Yes, they all are.

Regards

Steve

 

[Thomko]

There has been bug in Access 2007 that caused problems on compacting DBs on network shares. Two machines might have that hotfix installed and the other two not. That would explain the different behaviour.
Here the link to the hotfix (has also some description of the error): http://support.microsoft.com/kb/949404

HTH
Thomas

 

[stemach1]

Thanks Thomko, that worked great on one machine but on the other 'installation failed' about 25 percent of the way through quoting this error :-
KB949404
Do you have any further ideas?

Thanks.

Steve.

There has been bug in Access 2007 that caused problems on compacting DBs on network shares. Two machines might have that hotfix installed and the other two not. That would explain the different behaviour.
Here the link to the hotfix (has also some description of the error): http://support.microsoft.com/kb/949404

HTH
Thomas

 

[Thomko]

Steve,

the error message is missing (or has there been none?). There might be dependencies to other fixes that are also missing. Try to update the whole access installation with the latest patches via the Windows Update web page.

Thomas

 

[stemach1]

Thanks Thomko,
As there is one machine that won't update I've decided to leave the compact on close and I'll run the compact once a week manually. Does this sound OK?

Cheers

Steve.

Steve,

the error message is missing (or has there been none?). There might be dependencies to other fixes that are also missing. Try to update the whole access installation with the latest patches via the Windows Update web page.

Thomas

 

[Thomko]

Should work. You could even automate the compacting with a Windows Scheduled Task that triggers an Access DB that does the job (maybe including a 'real' backup). There should be plenty of code snippets around the Intenet how to compact a (different) Access DB via VBA.

Thomas