Results 1 to 2 of 2

Thread: Access.lockfile trouble

  1. #1

    Thread Starter
    New Member
    Join Date
    Apr 2002
    Location
    NE England
    Posts
    6
    Hi, I have been writing an app that connects to an Access 2000 DB using a data control. It used to work fine but now I am getting the message
    C:\......DBSelect.mdb is not a valid path.
    I have checked the path and it is correct. I have noticed that whenever I try to connect, another file appears in the same directory, with the same filename and an ldb extention. Also I have tried to use a SQL INSERT Statement to the same DB and get a runtime error 3129 which I think means that I am trying to write to a read only property. Again this Lockfile appears.
    I am just learning so if this is not very clear I appologise.
    I would like to know how to fix this and also how I have caused this so that I can prevent it next time.
    Thanks Lee.

  2. #2
    PowerPoster Beacon's Avatar
    Join Date
    Jan 2001
    Location
    Pub Floor
    Posts
    3,188
    See my ado turorial use it instead of the data control to rule out the data control as the problem.

    The lock file is created every time the DB is opened in any mode accept Exclusive i think..

    later
    b

Posting Permissions

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



Click Here to Expand Forum to Full Width