Sep 27 2022 09:13 PM
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.
When I start my database/form from a local drive everything works, but when I copy my database to fileshare, only access-generated buttons work while those buttons containing VBA code do nothing - not even an error. Even if I put in a simple MsgBox("Hello") code I get nothing.
Am I missing some paramteres in MS Access options?
Sep 28 2022 12:40 PM
Sep 28 2022 09:45 PM
Sep 29 2022 07:11 AM
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.