Sounds like you have the mdb file in a non-trusted zone (via outside the internet explorer zone) where you do not have permissions to open it. You can add (in IE) the location of the file (via local intranet trusted security zones or trusted sites - ie. add the folder location or site as a trusted zone - ex: F:\folder or http://somesite) or copy the file to a place where it is on a network system accessible by your security settings.
Usually you put the mdb on a network system whereby everyone can access it but depending on your setup, this can be different. ie. If it's on your local drive, copy it to a network drive accessable by all or modify your (or your users) local intranet security zones or trusted sites.
Note that IE controls security zones. Some systems need to have this location added to IE as a trusted zone as an mdb file located outside this zone can cause problems when it's downloaded or accessed.
Ex: Internet Explorer -> Tools -> Internet Options -> Security tab -> local intranet -> sites button -> then Advanced, then add the http:// location (ie. http://zone name or the drive letter: and then -> Add and enter the zone or drive letter (for internal sites). Then when it's downloaded or accessed, it will recognize it as trusted.
or Internet Explorer -> Tools -> Security -> internet options -> sites button and then add the internet site, download it, and it will trust it.
I will often download a file from the internet. If that location is not in my trusted zone, it doesn't recognize the file as a trusted file and hence get the same error.
Last edited by pkstormy; 11-26-09 at 02:06.
Expert Database Programming
MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)