Home > Archive > MS Access Multiuser > February 2006 > VB 5 Program trying to utilize Record Locking (.LDB) with MS Access









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

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

2006-01-04, 3:24 am

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.


Ron Hinds

2006-02-17, 8:25 pm

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

"JohnP" <johnp@gothicfusion.com> wrote in message
news:2uGuf.563$Js7.136@fe06.highwinds-media.phx...
> 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





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com