[AccessD] Lock an attached SQL Server table

Bob Hall rjhjr at cox.net
Wed Aug 20 23:33:24 CDT 2003


On Wed, Aug 20, 2003 at 04:38:57PM -0700, Charlotte Foust wrote:
> 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{

Jet can't control locking on another DBMS, so I think you're going to 
need an SQL Server stored procedure you can call from Access. Check 
with the SQL Server list on how to set that up.

Bob Hall


More information about the AccessD mailing list