Compacting Errors

[D-Fresh]

In my Access 97 database, I have the db compact using sendkeys after a function is run. My problem is if there is another user in the database, I get an error message about how someone else is in the db. Is there a way to trap this error message? I would like to compact if you can, if not, then just resume without any errors. Any help would be greatly appreciated. Thanks.

Doug

 

[Capilano]

Hi... Have you found a solution to your problem yet? If not, please contact me because I have code that will show you is still accessing the database when you are trying to compact.

Pat

 

[chrismcbride]

Private Sub CompactDB()
On Error GoTo EH

...code...

SeeYa:
Exit Sub

EH:
resume Seeya


HTH
Chris