An error 2950 normally means that your database is in an untrusted location on your hard drive. (not always … but normally).


You can normally fix this with a registry edit e.g.

[HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Access\Security\Trusted Locations\Location0]
AllowSubFolders (REG_DWORD) = 1
Path (REG_EXPAND_SZ) “C:\Your Path\Your Program\”

(Location0 can be any key name you like).

What do you do if this does not work and the dreaded 2950 error continues?

a) Look for an error in your macro/vbs code in your access file. There is loads of information online on how to sort this out.

b) Look for other resources you need. (What ???)

I know it sounds fairly obscure however, here’s an example from my own troubles with “2950”

I copied the database into C:\Windows as that is trusted.

I double clicked the file and it went looking for Excel.exe and could not find it and then gave the 2950 error. I never saw the Excel.exe error when the Access file was in it’s original location.

I downloaded the Ms Excel Viewer and renamed the viewer executable to Excel.exe and then ran my Access file. Not only does my database now open, but all the macros run. I put the file back into the original trusted location and still no error 2950.

All this time my Access database was looking for Excel. Now it works.

Never underestimate what your Access file is looking for. 2950 does not always mean your program is in an untrusted location !


Tags: ,