FP98: Table is Locked Error Previewing Page With Database Region

Retired KB Content Disclaimer

View products that this article applies to.

This article was previously published under Q180842

Expand all | Collapse all

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.

Back to the top

CAUSE

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

Back to the top

RESOLUTION

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

On the View menu, click Datasheet View.
If you are asked to save the table, click Yes.
Switch to the browser and refresh the ASP page.

Back to the top

MORE INFORMATION

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

174008 (http://support.microsoft.com/kb/174008/EN-US/ ) FP98: What are Active Server Pages?

174015 (http://support.microsoft.com/kb/174015/EN-US/ ) FP98: How to Create Active Server Pages in FrontPage 98

175771 (http://support.microsoft.com/kb/175771/EN-US/ ) FP98: How to Display Contents of a Database Using ASP

175770 (http://support.microsoft.com/kb/175770/EN-US/ ) FP98: How to Post Information to a Database Using ASP

Back to the top

APPLIES TO

Microsoft FrontPage 98 Standard Edition

Back to the top

kbprb KB180842

Back to the top

Retired KB Content Disclaimer

This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.

Back to the top