VB 5 Program trying to utilize Record Locking (.LDB) with MS Access

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JohnP - 04 Jan 2006 02:33 GMT

I have a program that was developed originally for single-user use and we
are now trying to modify it to allow multi-user. We need to be able to
perform record locking, and everything that we have read would indicate that
the .LDB file will take care of that automatically (with the proper
parameters set for the .MDB). However, when we open the MS Access file from
within the Visual Basic 5 program (using ADO), there is no .LDB File
created.

I don't know what we are doing wrong, but would greatly appreciate any
assistance people could give me.

Reply to this Message

richard - 04 Jan 2006 21:59 GMT

JohnP

There is an article in Microsoft about this. I don't remember where I found
it. Basically what is said, and should an example for, was you open the
database using ADO and the switch for record locking, and then the tables you
open would be opened with record locking.

I hope this helps you some.

richard g

> I have a program that was developed originally for single-user use and we
> are now trying to modify it to allow multi-user. We need to be able to
[quoted text clipped - 6 lines]
> I don't know what we are doing wrong, but would greatly appreciate any
> assistance people could give me.

Reply to this Message

Ron Hinds - 17 Feb 2006 20:33 GMT

I think the .LDB file is created when you are using DAO (i.e., the JET
database engine).

Reply to this Message