Macro to Open Form Triggers Exclusive Access Message

[snakatsu]

I have a database that have multiple menus (forms). When I made a macro to open a menu and another data entry form, I get the "I don't have exclusive access..." message that pops up. This comes up multiple times.




I don't see any reason why it would give this message, since the macro is setting the form to be opened in normal view (and not design):


Other menus and forms I have opening are done in the exact same way because I don't have a clue on how to program using VBA and this is just a simple tracking database for my group, so I'm trying to see if there's any help on this matter here.

Thanks

[ranman256]

This can happen IF someone else is in the db at the same time.
and
it can happen if YOU yourself are in it alone,(rare) but I get this occasionally and still dont know why.
REMEDY:
open the db as EXCLUSIVE so no one can interfere with your changes.

BUT, in a shared network db, it should be split and NO ONE should be using the same db. (same front end, everyone shares the tables)
You should have the master db on your PC only, then update all users with the updated copy.

[ItsMe]

Sometimes code and or a macro's request needs to be executed during Design Time. If your request is to make design time changes, you need to have exclusive access to the file. As mentioned, it is best to split the DB and have each user open their own front end file. Also, I avoid making design changes to files. I prefer to have them operate exclusively in a Run Time environment.

[snakatsu]

Tried splitting the database, and still comes up with the same message when the one form is opened. The message will pop up about 4 times before the form opens, but the form opens normally, otherwise. Because this can become an annoyance to my users, I am contemplating rebuilding the database so this doesn't happen which will take me a very long time. I didn't mention in my original post that I'm a very novice user, and only used what my co-worker helped us with before she left and the basics she was able to teach me to build this database.

[ItsMe]

You tried splitting the database? You were not successful?

One thing you might want to do is look for an laccdb or an ldb file in the same folder as your Access file. If nobody at any of the workstations have the file open, there should not be an laccdb or an ldb file. Go ahead and delete or move it into another folder if nobody has the file open.

[Micron]

The suggestions regarding splitting the db and the ldb or laccdb are good. You can open the file with Notepad and the details might clue you in as to who has it open. You can also try to delete it regardless if anyone else has the db open and if they do, it will not allow you. Another issue that can cause this file to hang for a while is someone thinks an operation is stuck, so they force a db close and the network will not remove this file for what might be quite a while. Your problem might not be related to sharing, though.

You call your 'menus' forms and say you're opening a menu, then a form, but you only posted what seems to apply to one of these but not both. I can't tell which the macro is for - form or menu. So perhaps the other call to open an object is the problem. Assuming I'm correct about the order of things, when do you get the message - when opening the object related to the macro details you posted, or when the other object opens?

Add-ins can cause this problem. They can place a 'hold' on an object, and when you try to open it, there is a conflict.
Record level locking can also cause this problem.
If none of the clues you've received solve the issue, next time it happens, deal with the message(s) then close the object and try again. If the issue persists, that is an indication that it is somewhat consistent, so I would immediately try opening the objects manually in the same order. If this works, I think the issue is not related to multiple users and would focus on record locks, the opening parameters of each form in the sequence, and add-ins.