[AccessD] Lock an attached SQL Server table

Charlotte Foust cfoust at infostatsystems.com
Wed Aug 20 18:38:57 CDT 2003


We need to find a way to place a persistent lock on a SQL Server 2000
table from Access 97 using ODBC linked tables.  Does anyone know how it
can be done?  We aren't using a transaction, and all attempts have
failed so far.  I didn't post this is the SQL forum because we're all
Access people, not really SQL Server, so the answers we got there might
not be of any real use.  :o{

Charlotte Foust


More information about the AccessD mailing list