Error 2950 In Access 2007 Runtime From Trusted Location
I have both databases in trusted locations that I have added through the registry. I have enabled network locations. I do not get a prompt indicating that they are not trusted, which shows me that they really are in trusted locations.
I have the full version of 2007 on my laptop and get no errors, however, on the client machine I get a 2950 error in the Autoexec macro.
I tried moving the function call in the macro into a form that would launch on startup instead of the macro and still get the runtime error, however, when I get the error in this fashion I do not get the error dialog like with the macro, I just get a runtime msgbox.
Thank you for taking the time to report an issue.
What's wrong... Please write below.
I recently started receiving a 2950 error when running the query from the macro, but when I run it manually itcompletes successfully.
It loads data to a back end database. The program is getting this message.
Macro Name: ImportCounts
Action Name: RunCode
Error Number: 2950
I have checked the Trusted locations and added the program location in the program. I was told this is a local setting and can not be set on the server because we are using AC2007 runtime. Anyway changing the settings did not effect the message. Is that true? How do I get the program to run
In this article
* When should I use a trusted location?
* Which trusted locations are safer?
* Create a trusted location
* Remove a trusted location
* Change a trusted location
The error on the macros says that steps won't work if the database is not trusted.
On the sub:
Public Sub Form_Load()
When the form loads, it sets focus to combobox1. EASY RIGHT?!?!?!?!?!?
It works perfectly fine using Access 2007 on Windows XP.
When I open it on Access 2010 on Windows 7, I get Run-Time Error '2950'! Tried 4 different computers all with the same error!
TOC: * Components that Office Access 2007 disables
* How to enable a disabled database
I went to another form to see if that one worked w/ SetValue (because the database is trusted in my system), and it did. So my problem is that I'm receiving error 2950 (trust issues) inone form, but not receiving the same error, from the same function, on another form.
and on my network I am using access 2010 runtime on other computer to access it. on that computer in registry settings I have trusted locations as //server/database I.e. in database folder I have the fe and be.
I can open the fe but with potential security warning I.e. of trusted locations I think . and when I click open on it it doesn't open my forms those are linked with tables from navigation form and displays the error that is something concerned with location g:\database which is on my server computer.
While playing with the code I noticed if I take out the "AND" in the bold line above. The error is removed within Access 2010; however, it creates the same error in Access 2007, 2003. We still have a couple users that utilize Access 2007 and need it to function properly in both instances.
This is a program that I have inherited and my programming skills are minimal at best.
I have worked on this for several hours already, or 2007; however, not in both.
Specific error is that the switchboard form on the db does not load using Access 2010 after the update. Everything else seems to work. Also impossible to manually open or design form after the update, since Access says it now cannot recognize data in that form ?! 2007 Access works perfectly, no problems.
I've already turned off everything obvious in the Trust Center, as well as designated my source location as a trusted location.