Help unable to open access 2002 over the web

[gromit114]

We have just upgraded from Access 97 to 2002. we used to open different databases from our intranet to install on a users computer. However when we open the new format over the web we get the following message:

Microsoft Access cannot open this file.
This file is located outside your intranet or on an untrusted site. Microsoft Access will not open the file due to potential security problems.
To open the file, copy it to your computer or an accessible network location.

I have trawled through microsoft and technet tried the workaround and still no joy. Can somone please throw any light on this.

 

[jrbarnett]

Which web browser(s) are you using to access this?

 

[gromit114]

IE 5.5

 

[jrbarnett]

Go to control panel -> internet options -> Security tab. Click the Properties button on the Local Intranet tab and ensure the settings are correct; if necessary add the URL of your intranet server to the approved list.

John

 

[gromit114]

I have done that when i access the site it shows it is trusted but still fails

 

[jrbarnett]

Go back into the control panel internet options, highlight local intranet and choose custom level.
Ensure "File download" is set to enabled as well.

I would also consider upgrading your browser to IE6 if you have upgraded to Access 2002 (and probably Office XP as well).

John