I have a macro that does a RunCommand where Command is CompactDatabase. I get the error message:
The Microsoft Jet database engine cannot open the file 'C:\Users\Judith\CARE2.8\db1.mdb'. It is already opened exclusively by another user, or you need permission to view its data.
The file db1.mdb doesn't exist. The file I'm trying to compact is CareProgram.mdb. Where is the db1.mdb coming from?