Goodday,

The application i wrote in MSACCESS VBA was using
table locking on access tables and works fine.

This is the code i use:

dim rs as recordset
set rs=codedb.openrecordset("tblTest",dbopendynaset)

But now i have to connect to an SQL-Server 2000 via an ODBC connection.
Now i have a problem with the table locking.

I suceeded to create a linked table to the sql-server and reading and editing the data. But still I don't know how to lock a whole table.

Can someone tell me how i can lock the whole table at the
moment that i use the openrecordset method so that other
openrecordsets will be generating a trappable error?

Kind regards,

Paul