Does Access have equiv of Transact-SQL's Nolock hint?

[Darrell Grissen]

Hi,

I am working on a project and plan to use Access to
connect to SQL server. The developers are worried about
time-outs... so my question is - Does Access have an
equivalent of Transact-SQL's Nolock hint? If so, what is
the syntax and/or where can I find more information about
it?

Thanks,

Darrell

 

[Albert D. Kallal]

Hi,

I am working on a project and plan to use Access to
connect to SQL server. The developers are worried about
time-outs... so my question is - Does Access have an
equivalent of Transact-SQL's Nolock hint? If so, what is
the syntax and/or where can I find more information about
it?

I would assume that the sql server manuals have information about this.

I mean, you can use VB, c++ or ms-access to connect to sql server. VB, or
c++ or ms-access are just tools to build forms and the interface (they are
not databases). So, if you connect to Oracle, or in your case sql server,
then I would assume your question about a particular server features are
just that...features of the server.

It is not clear if you are going to use a native sql server project in
ms-access (a adp project), but even then, the nolock settings will be that
of sql server...and not ms-access.