Forum Discussion
KakovostMDM
Sep 28, 2022Copper Contributor
VBA doesn't work on network/fileshare drive
I have a database with some forms to represent relevant data. Most of the buttons are automatically generated and work perfectly, but some required me to use VBA to get functionality I needed. Wh...
George_Hepworth
Sep 28, 2022Silver Contributor
Have you designated that Location as a Trusted Location for Access accdbs?
- KakovostMDMSep 29, 2022Copper ContributorAdding a fileshare location as a trusted location, I get the following error message:
"The path you have entered cannot be used as a Trusted Location for security reasons. Choose another location or a specific folder."
...and just to clarify, I did choose a specific folder and not the entire fileshare drive.- George_HepworthSep 29, 2022Silver Contributor
That would appear to be the most likely answer then. I don't know your network, so can't advise on the proper approach for your situation. However, there are two general approaches. One is to use a folder which you can designate as a Trusted Location. The other might be to tell Access to allow Trusted Locations on the network. However, the depends on your IT policy and practices.