Select the product you need help with

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

Article ID: 810582 - View products that this article applies to.

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.

Back to the top | Give Feedback

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 "Symptoms" section describes.

Back to the top | Give Feedback

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

(http://support.microsoft.com/kb/308100/ )

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

308278

(http://support.microsoft.com/kb/308278/ )

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

240090

(http://support.microsoft.com/kb/240090/ )

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

Back to the top | Give Feedback

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.

Back to the top | Give Feedback

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

(http://support.microsoft.com/kb/303650/ )

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

Back to the top | Give Feedback