[2005] Exclusive Connection

[mahbub73]

Hello,
I use VB2005 and MS Access.
I want to connect to an Access database exclusively for a few minutes. So that other user can't add, edit data to that database. How can I make that connection?

Pls Help me.

In Previous VB version I used Connection.Mode=adShareExclusive

[mahbub73]

Pls reply. I badly need it in a Point of Sale software to prevent concurrency.

I have to lock (exclusive access) the database upto printing a report, then unlock it for user.

[mahbub73]

Is it (Exclusive Connection to a database) impossible in vb2005?

I don't know why nobody answers.

This forum has made me hopeless.

[mahbub73]

Exclusive Connection (? Locking) to a Table will also do my job. Pls help me.

[circuits2]

What do you need the exclusive connection for?

[mahbub73]

Thanks for your kind reply.

I want to get two consecutive serial no >> max(ID) and max(ID)+1 << and save them in database. If other users (there are 14 users in our office who are saving data continuously) save a value in ID field in that fraction of second, I might end up with error.

There may be some different logic available. But we are using it for a long time in VB6. We now think to move on to different logic.
But before that I just want to know whether VB2005 has that option (lock a table) or not.