Database duplicating in root folder

[millrat]

Hi there.

My app has about 40 users. Everytime I open the root folder where it resides I see multiple copies of the database... eg db1.mdb db2.mdb etc.(up to 50 now)
The app is split with FE mde file. All security is in place on both FE & BE. All users are full data with only 2 admin users.
What can be causing this and how do I find out who is reaponsible? Any tips?

Cheers,
millrat

 

[JerryKlmns]

Mayby there is a Compact on Close for a user that does not belong to the Admins. The process fails since there 's no administrative rights and temp database (db1.mdb) fails to complete compact operation. Next time temp database is named db2.mdb and so on.

So check Compact on Close for your users

 

[millrat]

JerryKlmns,

That's it... Spot on. The FE did have the compact on close checked... No more temp files
Thanks,
millrat