MS Access Multiuser - VB6 code to Lock access table

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

VB6 code to Lock access table

equalive

2006-02-03, 3:24 am

Hi guys,

I'm having problem locking a table in Ms Access using VB6 code.
Actually I have 3 tables.
Assume table names is A, B, C.

Following is the process.

1. Open table A and update table A. (Must Lock the table A)
2. Open table B and update table B.
3. Open table C and update table C.
4. Open table A and update table A again.(After update...Release the
lock)

Once I open table A for update, I dont want another user to access
table A until i finish step 2, 3, 4. Once step 4 is complete, then I
want to release the lock for table A.

How to do it guys. Hopefully i have given enough and simple explanation

for you to help me.

Thanks Guys.

Sponsored Links