FP98: Table is Locked Error Previewing Page With Database Region

Last reviewed: March 18, 1998
Article ID: Q180842
The information in this article applies to:
  • Microsoft FrontPage 98 for Windows

SYMPTOMS

When you open an Active Server Page (ASP) that contains a database region in a Web browser, you may receive the following error message:

   Database Error: [Microsoft][ODBC Microsoft Access 97 Driver] Table
   'TableName'is exclusively locked by user 'Admin' on machine 'MyMachine.'

The wording of the message may vary depending on how you have set up your data source.

CAUSE

This behavior occurs when the table you are querying is open in Design view in Microsoft Access.

RESOLUTION

To resolve this behavior, switch to Microsoft Access and follow these steps:

  1. On the View menu, click Datasheet View.

  2. If you are asked to save the table, click Yes.

  3. Switch to the browser and refresh the ASP page.

MORE INFORMATION

For more information about Active Server Pages, please see the following articles in the Microsoft Knowledge Base:

   ARTICLE-ID : Q174008
   TITLE      : FP98: What are Active Server Pages?

   ARTICLE-ID : Q174015
   TITLE      : FP98: How to Create Active Server Pages in FrontPage 98

   ARTICLE-ID : Q175771
   TITLE      : FP98: How to Display Contents of a Database Using ASP

   ARTICLE-ID : Q175770
   TITLE      : FP98: How to Post Information to a Database Using ASP


Additional query words: front page
Keywords : fpodbc kbdta
Technology : internet
Version : WINDOWS:98
Platform : WINDOWS
Hardware : x86
Issue type : kbprb


THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: March 18, 1998
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.