Symptoms
When you try to open a Microsoft Access table in Design view, you mayreceive 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 permissionto 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, andthen try again to open the table in Design view.You may also receive errors if you try to move or copy a database inWindows 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 isnot currently in use.
Resolution
The database is an ODBC data source that is used by an ASP file. Forexample, this behavior would occur if the table itself, or a query or formbased on that table, had been exported to ASP format. Although the ASPfile, 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.