[AccessD] Lock an attached SQL Server table

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