I have a macro that 1)starts with a make-table query, 2)opens a report based on the new table, then 3)runs an If statement stating IF [Reports]![Reject Report]!="NO" THEN EmailDatabaseObject called "Reject Report". . . My problem is that after the macro completes it locks the table that was made earlier and I cannot run the macro again unless I close the entire database and reload it. (I get a error message saying that the table is locked by another user. Please wait until the other user closes out of the program and try again; or something like that.) There is no one using the database during these tests so I have no idea why the table is staying locked. Do you have any ideas on how to modify the macro to allow it to run consistantly?
February 2, 2011 7:14 PM
February 4, 2011 2:21 PM