Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Question
Thursday, January 19, 2017 9:55 PM
A user is getting this message opening a database. Other users do not get it opening the same database.
It's happening in Autoexec macro.
The database does not have an 'add trusted locations button' in Trust Center settings option.
Access 2010. I did not write this database and know nothing about it.
How to proceed?
All replies (14)
Thursday, January 19, 2017 10:11 PM
Do you have an IT department who may be controlling whether trust settings can be set by the users or not?
Thursday, January 19, 2017 10:13 PM
Sounds like Macros are entirely disabled? Access Options/Trust Center/Trust Center Settings button to the Trust Center. Pick Macro Settings. I have the "Disable all macros with notification". That means that when I open a file with code in it, I have to click the 'Enable' button. Once you blow by that (say, in debug mode), that isn't offered until you close / reopen the file.
-MainSleuth You've Got It, Use It! Engineering, Science, Statistics Solutions http://ToolSleuth.com
Thursday, January 19, 2017 10:20 PM
Do you have to click that 'Enable' button every time you open the database or only the first time?
This is an MDB database that is not split. Each user opens it from its one location.
Thursday, January 19, 2017 10:27 PM
Unless by (IT) policy, for the user it's First time only - until the filename/location is changed. I sprung for a digital signature in case IT/user has picked the next one down. They can also then add that signature to the Trusted Publishers.
-MainSleuth You've Got It, Use It! Engineering, Science, Statistics Solutions http://ToolSleuth.com
Thursday, January 19, 2017 10:28 PM
Ok, I added a trusted location of the folder where the database resides (I was looking in the wrong place before).
Now the database has become 'Read-Only'.
Any idea what might have caused that?
Thursday, January 19, 2017 10:34 PM
Does it say "Read-Only" in the yellow information bar?
Thursday, January 19, 2017 10:50 PM
I believe the 'read only' was caused by the application icon being in a location I did not have permissions to. I deleted the icon path and now that issue has gone way. I also deleted the trusted location I added as that did not help. Now I am back to square one. These 2 new users cannot access the database. Everyone else can. Are these trusted location problems specific to an individual user or to the database as a whole? Because everyone else can access the database fine.
Thursday, January 19, 2017 10:58 PM
Hi,
Trusted Locations are user specific but let's back up a bit. Is your database application "split" into separate front and back end files. If so, does each user have their own copy of the frontend on their local computer?
Thursday, January 19, 2017 10:58 PM
Could be user permissions on either the folder or the file itself. Right-click the folder pick the security tab. Could be they are read only.
The reason to give folder level permissions is that In addition to the mdb, the ldb requires read/write/modify. If the .ldb doesn't exist (because nobody else is using it), then it is created for the session.
-MainSleuth You've Got It, Use It! Engineering, Science, Statistics Solutions http://ToolSleuth.com
Thursday, January 19, 2017 11:05 PM
No, not split and I do not have any control over that, so it will remain unsplit.
Users click on a shortcut that opens the database from another location (a shared server), but each user opens the same MDB.
These 2 new users are supposed to have been given the same permissions to the folders as existing users but I have no way of verifying that. There is no indication that they cannot access any folder.
Thursday, January 19, 2017 11:09 PM
As I said the 'read-only' issue went away once I deleted the application icon and removed the trusted location I had added.
Now they are back to getting the original message this thread was opened with 'Set Warnings cannot run in Disabled mode'. It's in the Autoexec macro.
Thursday, January 19, 2017 11:14 PM
As I said the 'read-only' issue went away once I deleted the application icon and removed the trusted location I had added.
Now they are back to getting the original message this thread was opened with 'Set Warnings cannot run in Disabled mode'. It's in the Autoexec macro.
Hi,
As I said above, trust locations are set up on the user's computer. Can these 2 users add their own trusted location on their machine?
Friday, January 20, 2017 2:30 AM
They don't have the database on their machine, it's on a shared server.
Do they just open a black Access db, set the settings, then close it. Or can they just click the Enable Content button on the error screen?
Wednesday, January 25, 2017 8:09 AM
you had mentioned that ,"Or can they just click the Enable Content button on the error screen?"
does that error display the "Enable" button?
if yes, then enable it and try to use.
if possible can you post a picture of that. so if you are missing something then we can try to refer that image.
Regards
Deepak
MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact [email protected].