Hi,

I have an Access database that connects as a read-only user to a MS SQL 2000 database. This has caused some issues because Access appears to be locking a table.

I've read two solutions:
1. DISTINCT. For some reason, Access will lock a table if queries do not use the DISTINCT keyword.
2. WITH (NOLOCK). But, apparently I can't call this from Access, so I'd need to create a Stored Procedure to call. I'm a bit fuzzy on whether or not I'd have to recreate all of the Access queries as Stored Procedures though, or if it's possible to call the one to set the locking status, and then continue running queries from Access.

So if anyone has any suggestions or comments, please share them.