I have been creating MS Access Databases for different areas of work and they work perfectly... until I put the database on a network drive which users all have full access to. Then, when they open the database they receive an error that macros are blocked so my VBA does not run.
I have created about 4 different databases and the same thing happens on all of them. I have the network location listed as a trusted location, I have tried copying the database to the local desktop to test it, I have set all network and subfolders as safe, I have even marked all macros as safe in the options but it just will not work.
I am sure it is something I am doing but I just cannot figure out what. Any ideas would be GREATLY appreciated as I have databases I want to roll out for testing to users but they cannot open them.