Nolock

Is there a way to specify no lock when constructing a sql statement to execute on an Access DB? I have some statements causing major locking probs in a linked table.



States is a linked table from another Access DB. When this query executes it causes MANY problems by creating lots of locking records in the db that contains States. Is there an equivalent to NOLOCK that I can use to eliminate this?

At least until Access2k there is no other possibility than using connection parameters.
In your case this should be s.th. like adReadOnly, adForwardOnly
But a simple select statement should not lock tables, even in Access. But as soon as someone opens the query and leaves it with the pen in the record selector (i.e. change with no save) then, of course, all necessary stuff is locked. This is (or would then be) a user training problem!