ACC97: Error: "Can't open the table" in Data Source of ASP FileLast reviewed: August 11, 1997Article ID: Q172547 |
The information in this article applies to:
SYMPTOMSModerate: Requires basic macro, coding, and interoperability skills. When you try to open a Microsoft Access table in Design view, you may receive the following message:
You can't open the table <tablename> for modification. A query or form bound to the table is open, you may not have permission to open this table in Design view, or another user has the table open. Do you want to open this table as read-only? If you have opened a query or form bound to this table, close it, and then try again to open the table in Design view.You may also receive errors if you try to move or copy a database in Windows Explorer; for example you may receive the message:
Cannot move <database>: There has been a sharing violation. The source or destination file may be in use. -or- Cannot rename <database name>: Access is denied. Make sure the disk is not full or write-protected and that the file is not currently in use. CAUSEThe database is an ODBC data source that is used by an ASP file. For example, this behavior would occur if the table itself, or a query or form based on that table, had been exported to ASP format. Although the ASP file, itself, may not currently be open in a user's browser, the Session object for a particular user session persists for the period of time specified by its Timeout property. The ASP file contains code that creates a connection object and stores that connection in the session variable. Therefore, the connection to the Microsoft Access database that serves as the ODBC data source persists until the session times out. The default value of the Timeout property is 20 minutes.
RESOLUTIONYou can use one of the following methods to resolve this issue.
Method 1Instead of editing the database that is the ODBC data source, edit a copy of that database. When all sessions have expired, export the redesigned table to the ODBC data source, or copy the database itself to the file that serves as the data source. This is the recommended method to resolve this issue.
Method 2Export the database object to ASP format again, and use the "Publish to the Web" Wizard to specify to Timeout property. To do so, follow these steps:
Method 3NOTE: This section contains information about editing ASP files, and assumes that you are familiar with editing ASP files. Microsoft Access Technical Support engineers do not support customization of any HTML, HTX, IDC, or ASP files. Edit your ASP file and specify the value of Session.Timeout. To do so, follow these steps:
STATUSThis behavior is by design.
MORE INFORMATION
Steps to Reproduce BehaviorThe following example assumes that you have created an ODBC data source based on the sample database Northwind.mdb.
REFERENCESFor more information about creating an ODBC data source, search the Help Index for "ODBC, setting up data sources." For more information about the Session object in ASP, open the Active Server Pages Roadmap and under Contents, click Object Reference.
|
Additional query words: 7.00
© 1998 Microsoft Corporation. All rights reserved. Terms of Use. |