Opening Access databases via Front Page web

[cb]

We have an instructor who uses FrontPage to teach his online business class.
Since upgrading to FP2003, the students can no longer open the Access
database on the server (Acess 2000 and 2002 tested). The error recieved is:

"File is located outside your intranet or an untrusted site. Microsoft
Access will not open the file b/c of potential security problems."

We added the URL to the trusted section of IE (running the latest version I
believe), but it still does not work. Is there something in Access I should
be looking at?
We are able to copy the database locally and then replace the DB, once
complete, but the instructor says the class workflow will not handle this
solution - they must be able to open the DB in place on the server.

Questions - Where does FP put files when they are opened from the server
(internet cache)? Does it copy them locally? Does it automatically update
the server file if I update on my local machine?

Any help would be greatly appreciated!

~CB

 

[Jim Buyens]

Please refer to MSKB article 810582:
Error Opening Access Database from a Web Server

http://support.microsoft.com/default.aspx?scid=kb;en-
us;810582

Basically, you need to either:

1. Store the Access database on a file server, and then
tell all the students to access the file server
location, or:

2. Leave the database on the Web server, and write some
ASP or ASP.NET pages that perform the inquiries and
updates you need.

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------