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.

I fixed it. Options were set to default mode of Exclusive not Shared. Just didn't know where to find it at first.

My bad. I shouldn't have assumed you knew where that was. I see it was early when I answered that. Coffee had not kicked in yet. :)