Prev: CAN I RUN SEVERAL QUERYS FROM ONE CONTROL BUTTUON
Next: DSum doesn't work on other PCs
From: trekkor77 on 9 Apr 2010 16:32
Does Access have a like function?
From: Sylvain Lafontaine on 9 Apr 2010 19:17
Maybe.

If you are working against a SQL-Server then you could use a passthrough
query with a NoLock hint.

While doing a little search on the Internet, I've also found the following
two solutions:

1- for a regular Jet database, you could add the Distinct keyword to your
query. It will make it Read-Only but at the same time, will permit Jet to
put much less locks on it. (Reference:
http://bytes.com/topic/access/answers/196349-access-sql-query-incompatability-nolock )
..

2- you can also use the Option on the JET "READ WRITE SHARE DENY NONE" if
this is MDB linked to another MDB. See
http://www.experts-exchange.com/Programming/Languages/Pascal/Delphi/Q_24072691.html

Finally, if you would explain what your problem is, maybe someone will come
with a solution.

--
Sylvain Lafontaine, ing.
MVP - Windows Live Platform
Blog/web site: http://coding-paparazzi.sylvainlafontaine.com
Independent consultant and remote programming for Access and SQL-Server
(French)


"trekkor77" <trekkor77(a)discussions.microsoft.com> wrote in message
news:6028118D-FD8A-4866-9BD5-CB54029B5532(a)microsoft.com...
> Does Access have a like function?


 | 
Pages: 1
Prev: CAN I RUN SEVERAL QUERYS FROM ONE CONTROL BUTTUON
Next: DSum doesn't work on other PCs