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

Article translations Article translations
Article ID: 810582 - View products that this article applies to.
Expand all | Collapse all

On This Page

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 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.

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

  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 "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

Properties

Article ID: 810582 - Last Review: November 27, 2007 - Revision: 12.1
APPLIES TO
  • Microsoft Access 2002 Standard Edition
Keywords: 
kbpermissions kbopenfile kbdatabase kberrmsg kbprb KB810582

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com