Results 1 to 9 of 9

Thread: Microsoft Access (Table locking error) ** Resolved **

Threaded View

  1. Dec 28th, 2003, 04:18 PM #1
    MarkusJ_NZ
    MarkusJ_NZ is offline

    Thread Starter
    Hyperactive Member MarkusJ_NZ's Avatar
    Join Date
    Jun 2001
    Posts
    375

    Microsoft Access (Table locking error) ** Resolved **

    Hi, against my better judgement I have had to use Microsoft Access 2000 to store information for an app that I am writing.

    When I go to do an update I receive the following error

    "Could not save; currently locked by another user"

    I close all connections/ destroy all objects to do with the database as soon as I finish with them so there * is no way * anyone is still connected to the database. Also, I am the only one using the database.

    If I wait a few minutes the *.ldb file automatically disappears and then I can update the database without the error appearing.

    Any help appreciated

    Cheers
    Mark

    PS. Connection string below is what I am using to connect to the database

    VB Code:
    1. Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\_Databases\myCrapAccessDatabase.mdb;Persist Security Info=False

    ================

    Hi, I have just flagged Access as being the crap database that it is and have gone back to using SQL server. Things are all working fine now. Thanks for everyones help

    Cheers
    Markus
    Last edited by MarkusJ_NZ; Jan 1st, 2004 at 01:26 AM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width