Compact and Repair Problems

[jk12]

Hi all. I am having some problems with some users, not allowing the database enough time to compact and repair before they switch off their PC or laptop. Although they have been told many times about the function needing time many are just impatient. This has resulted in various db1, db2 etc being created within the folder which are then being opened and used by other members of staff being less then smart.

My question is, is there a way to have some sort of splash screen or something similar run during the compact and repair process that tells the user what is happening. Any other alternatives or methods would be fine this was just my first thought.

Thanks

James

 

[GohDiamond]

If you are sharing an Access database on a network you should probably try splitting the database. You'd have a common backend which doesn't need to be compacted on close. Then a replicated front end can be placed on each user's desktop. These don't really need to be set to compact on close unless the user is creating forms, queries and reports on his/her own.

If a laptop user is accessing the database while not connected to the network then they'll of course have to sync their changes to the main database. The problem shouldn't occur on their own computer if you set compact on close.

I hope this help a little
Goh

 

[jk12]

Yeah it helps. Makes sense to do it that way. Cheers.