Duplicating Code

[hpl2001]

I have a weird problem. I've created a 2003 database, and have split it into a front end and a back end. The back end is on a network share, and the front end is distributed to users to run from their desktops. What's happening is each time someone uses the database, a copy of the front end is being created on the share. They are being named database1, database2 ...etc. Note that each of these is a copy of the front end only - not the back end data. Can anyone tell me why this might be happening?

TIA.

Holly

 

[dhookom]

Is the copy being created when they open the front-end or when they close? Is the front-end set to compact on close?

Duane
Hook'D on Access
MS Access MVP

 

[hpl2001]

Yes, it does appear to be compacting on close. I'll try turning that off.