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
Doug