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

SYMPTOMS

When you try to open a Microsoft Access database by using a URL address (such as http://ServerName/DatabaseName or ftp://ServerName/DatabaseName), 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 2000 and Access 2002 are not designed to open a database by using a URL address. A fully qualified domain name (FQDN) address or an IP address that includes periods ( . ) in its name is identified as in the Internet zone and will be interpreted by Access as a URL address.

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

MORE INFORMATION

Steps to reproduce the problem

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

Notice that Access closes unexpectedly with the first message that is mentioned in the "Symptoms" section.

REFERENCES

For more information about another cause for the error messages that are mentioned in the "Symptoms" section, click the following article number to view the article in the Microsoft Knowledge Base:

303650 Intranet site is identified as an Internet site when you use an FQDN or an IP address