Microsoft KB Archive/180842

= FP98: Table is Locked Error Previewing Page With Database Region =

Article ID: 180842

Article Last Modified on 12/1/2000

-

APPLIES TO


 * Microsoft FrontPage 98 Standard Edition

-



This article was previously published under Q180842



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:

174008 FP98: What are Active Server Pages?

174015 FP98: How to Create Active Server Pages in FrontPage 98

175771 FP98: How to Display Contents of a Database Using ASP

175770 FP98: How to Post Information to a Database Using ASP

Additional query words: front page

Keywords: kbprb KB180842

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.