CFF KB - Carrz-Fox-Fire Promotions Knowledge Base

 CFF KB is all about 1 thing: The Sharing of Knowledge and the Power we gain from it.
  • Breadrumbs:

  • JET Database Engine error '80004005' The table 'messages' is already opened exclusively by another user, or it is already open through the user interface and cannot be manipulated programmatically

    • CFF Knowledge Base - Share With Facebook CFF Knowledge Base - Share on Twitter CFF Knowledge Base - Share on Reddit CFF Knowledge Base - Share on Digg It CFF Knowledge Base - Share on Stumble Upon It CFF Knowledge Base - Share on Delicious
    Share With Friends (Updated 6-8-2010)
  • Article ID:
    131
  • Date Created
    Wednesday, April 6, 2011
  • Last Updated
    Wednesday, June 22, 2011
  • This Article Has been Viewed
    2658 times
  • Short Desc
    When working with ASP and Access Database you may sometimes have Access Design View within database opened while working in the ASP page. This will cause the following error. Another error is exclusively locked by user.
  • Details
    While creating or editing your tables within Access Design View, you will be unable to view the page that using the Access Database.
    This is due to an issue within Access that blocks all connections to the database while in edit mode. If you do attempt to access the database during the Design View editing or Creation of a new Table within the Access Database, you will receive the following error.

     
    Microsoft JET Database Engine error '80004005'
    The table 'messages' is already opened exclusively by another user, or it is already open through the user interface and cannot be manipulated programmatically.
    /update_ajax.asp, line 8


    Another Error which means the same thing is:
     
    Microsoft JET Database Engine error '80004005'
    Table 'Users' is exclusively locked by user 'Admin' on machine 'SERVER_NAME'.
    /encrypt.asp, line 8
  • Recreate Issue
    To recreate this issue.

    [Open] Access Databse.
    [Right Click] on a [Table] and choose [Design View]
    Load your [ASP Page] and you will encounter the [Error]:
     
    Microsoft JET Database Engine error '80004005'
  • Resolve Issue
    To resolve this issue.

    After you have completed the editing of your Access Database Table.
    close out of the Access Design View.
    Reload your ASP page and you should not receive the 80004005 error.

Recent Articles

All Topics

  • Coming Soon - Knowledge Exchange

Trending Articles