Front end making copies of itself

[hpl2001]

I have a database running in a multi user environment. It is split with a front and a back end. It appears that when users are accessing the database, a copy of the front end is being created. These copies have the names Database1.mdb, Database2.mdb etc. My front end is a .mde file. Does anyone know why this might be happening? The program was created in access 2003, and is currently being run in 2010.

TIA.

Holly

 

[1DMF]

The way I do this is install Access 2010 runtime on user's machines, then change the access file format to 2007+, create an ACCDE file (the new name for MDE) and then change the 'E' on the end to an 'R'.

So the user runs a file "my_access_db.accdr", and it is fired up in the access runtime as a front end application not an editable source access db.

"In complete darkness we are all the same, it is only our knowledge and wisdom that separates us, don't let your eyes deceive you."

"If a shortcut was meant to be easy, it wouldn't be a shortcut, it would be the way!"
Free Electronic Dance Music

 

[razchip]

This may also be caused by having the compact set to run each time and the compacting is not being completed.

Thanks for the help.
Greg

 

[genomon]

What razchip said. One of the things that may cause the compact to fail is the app being held open by another user when a different instance tries to close and compact. A solution might be to disable "compact on close" and just schedule it to be done on a set basis when no users are active.

Beir bua agus beannacht!