MS Access Multiuser - RE: VB 5 Program trying to utilize Record Locking (.LDB) with MS Acces

Author

RE: VB 5 Program trying to utilize Record Locking (.LDB) with MS Acces

richard

2006-01-04, 8:25 pm

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

"JohnP" wrote:

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

Sponsored Links