I get an error message that says "The Mail Merge Wizard cannot continue because the database is in exclusive mode. Close and reopen the database to run this wizard."
I'm assuming you're not using Exclusive mode? This happens if you edit the database or put it into a state where it's locked for any other users. That will also prevent other applications (like Word) from using it. Close the database completely and restart it. Do you still get the same error? I know this is an Expert class, but have you put any VBA in your database that might lock it? For example if you use "CurrentDB.OpenRecordset" that will lock your database.
Austin RitnerOP
@Reply 6 years ago
I fixed it. Options were set to default mode of Exclusive not Shared. Just didn't know where to find it at first.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Expert 20.
