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