Compact and Repair is Changing my Name

[Trigon]

Hi all

After following the advice from a previous thread (I cant link as i haven't posted enough).

I now have 2 backends, 1 imports data then uses queries to add new items to the other main backend. It then removes the data and compact and repairs ready for the next run.

This works fine but every few days it decides it wants to rename itself from 'Access Controls - Import.accdb' to 'database.mbd'

Any idea whats going on here?

Cheers

Chris

 

[pr2-eugin]

This works fine but every few days it decides it wants to rename itself from 'Access Controls - Import.accdb' to 'database.mbd'

A Compact & Repair process works like this. It creates a copy of the File first (Database.mdb), compacts that file, if it is successful deletes the old file and renames the Database.mdb to your original file name.

So I think somewhere in this script you have something is not working as desired. That is my conclusion, not sure if it actually helped.

 

[Trigon]

I was thinking of just calling it database.mdb as its hidden away from everyone anyway. But I assume it will then start calling it database(01).mdb instead and run into the same problem.

 

[pr2-eugin]

You might want to check why this is happening. By which I mean, see if someone is interrupting the DB when this script is running. Sudden load causing to going into End Task?

 

[Trigon]

Would it help if I called it from the other backend after that one has done its thing and fully closed?