Microsoft KB Archive/810582

= You receive an error message when you try to open an Access 2002 database from a Web Server =

Article ID: 810582

Article Last Modified on 11/27/2007

-

APPLIES TO


 * Microsoft Access 2002 Standard Edition

-



SYMPTOMS
When you try to open a Microsoft Access database by using a URL address (such as http:// / or ftp:// / ), you may receive one of the following messages:  

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 machine or an accessible network location.

 

Microsoft Access is unable to open the data access page.

There was not enough memory.

Please close other applications and try the operation again.

 

There was a problem sending the command to the program.





CAUSE
Access 2002 is not designed to open a database by using a URL address. If you try to open an Access database (.mdb) file on an intranet Web site by using the IP address, the FQDN, or the NetBIOS name, Access 2002 recognizes that the file is outside your intranet or is on an untrusted site. Therefore, Access 2002 displays one of the error messages that the &quot;Symptoms&quot; section describes.



RESOLUTION
To view data, to add data, or to edit data in a database file, you can use either data access pages or Active Server Pages (*.asp). For more information about data access pages, click Microsoft Access Help on the Help menu, type About the types of Web pages Access creates in the Office Assistant or the Answer Wizard, and then click Search to view the topic.

For more information about using Active Server Pages, click the following article numbers to view the articles in the Microsoft Knowledge Base:

308100 How to retrieve and display records from an Access database by using ASP.NET, ADO.NET, and Visual C# .NET

308278 How to retrieve and display records from an Access database by using ASP.NET, ADO.NET, and Visual Basic .NET

240090 How to update information in a Microsoft Access database using ASP in FrontPage 2000



Steps to reproduce the problem

 * 1) Start Microsoft Internet Explorer.
 * 2) Type http://YourServer/YourDatabase.mdb in the Address box, and then click Go.
 * 3) Click Open file from the current location.
 * 4) Click OK.

Notice that Access closes unexpectedly with the first message that is mentioned in the &quot;Symptoms&quot; section.

Additional query words: web server web site sharepoint team services sts internet

