-
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.
-
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 :)
