Multiple Access Files Created

[walstib]

I have created a basic MS Access database application for a remote customer.
The database functions correctly and I have thoruoghly tested it on my
system. However, my customer informs me that everytime he opens the database
another file is being created (not the locking file) in the file system
titled 'database1'. As the file is opened multiple times, files are
sequentially created 'database2', 'database3', etc.
I cannot recreate this anomoly and quite frankly am baffled. Does anyone
know what may be causing this problem. I am having difficulty
troubleshooting the issue as we live in different time zones. Any help would
be much appreciated.

 

[Duane Hookom]

Do you have the database set to compact on close?

 

[walstib]

Yes, the database is set to compact on close. I can turn it off. However,
as a matter of practice in Access 2003, I have always turned it on. It seems
like a good idea.

 

[Duane Hookom]

Just turn it off to see what happens.

 

[walstib]

Thanks for the advise and prompt response. I will give it a shot.