Recently some of our users have been having trouble using our VB program that gets data from a MS Access database. When checking those users PC's, we find that by going to MS Access on those machines, and the TOOLS > Macros > Security , the security level is medium, while on users who can get to the database, the security level is low. We then reset those PC's from medium to low, and they too can get at the database.
Any ideas how the security level initially gets set on the PC's in question?
Also, is there any VB code I can write when attempting to open the database that either resets it to low, or gets around the problem programatically without having to rest each PC?
Sdr46
