var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Table locking ODBC connection to SQLServer
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
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?