Query is not working in executable file

[MicheleBrou]

hello,



I really hope you can help me with this. I have a database that I have split. When testing after the split all of my passwords and date range queries work in the FE. The problem starts when I save the FE as an executable file for multiple users. Once the executable file is tested I lose all but 1 switchboard password protection and my date range query for a report gets an error message: The object doesn't contain the Automation object 'IsLoaded.' As for the passwords, I have the buttons on the switchboard password protected for each employee to be able to access only their form to update. In the FE this works, but when I test the executable file it does not provide the password prompt and goes directly to the form, I know that it can work because my Administrative button also has a password enabled via the switchboard and it works correctly. How can I fix this, I don't want to place my FE on the network for everyone to use as the potential to corrupt the data increases.

Thank you in advance,
MicheleB

[ranman256]

I issue FE to all users on the network with no corruption.
and when you say executable, do you mean .accde?
can you try .accdb,and hide all the objects? (What I do)

[MicheleBrou]

yes, executable would be the .accde. I can use the .accdb, and it does work with all my queries in tack as well as the passwords that are attached to the switchboard. The problem with this idea is that I have some VERY curious co-workers who will start to mess around in the design of the forms, and I don't want that and neither does my supervisor.