Hello,

I've been looking in the net but I can't find the syntax of locking a table in Access. My purpose is to lock the table so no one else during the transaction can have access to it. I have tried this query

LOCK TABLE [document_numbers] IN EXCLUSIVE MODE

and this

SELECT *
FROM [document_numbers]
WITH (TABLOCK)

and ROWLOCK also but nothing works. The syntax I found is only about MS SQL, Oracle and some more but there is nothing about MS Access. Please if some one knows to post a replay, I will be really grateful.

Greets

P.S. This have to be able to be programmed in C#.

probably best to ask this in the C# forum

private static string constr = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\mydatabase.mdb;Mode=Share Exclusive;User Id=admin;Password=";

In the connection string you want to use the "Mode=Share Exclusive;" parameter. This should allow you to do what you want.

I got this from the google webs. Here's the url.

Access Connection String Samples - ConnectionStrings.com

Hope this helps

Jim