Compact DB on close

[Kev]

In an Access 2003 database I have the Tools > Options > General:
Compact Database (checked) enable.
When I use the database in my local compauter it compacts when it
closes just fine. BUT when I move the files to the network, and run
the database from a network location, when it closes it compacts
creating a new .mdb (db1.mdb) file with the compacted database,
leaving the old .mdb file w/o compacting. If I open the database again
(from the network location) it will create another and another and
another .mdb file (db2.mdb, db3.mdb, db4.mdb, etc.) always leaving the
old .mdb growing and growing in size.

Can somebody please tell me. whats happening here?

Thanks in advance

Kevin

 

[erick-flores]

Thanks for all the replies. I will try to create a FE/BE app.