Get External Data : ODBC Lock Type

A

allan.martin

Hello

I support a Microsoft SQL Server 2000 database, which has numerous
users accessing the backend data using MS Query in Excel. The problem
is that from time to time this causes a lock on the database which
blocks all the other users.

I'm working on a solution which prevents the users from accessing the
system using Query, however I would like to know if it is possible to
change the lock type which MS Query puts on the tables being queryed.
I'd like the lock to be read-only non committed.

Any advice or ideas?

Many many thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding data to MS Access from csv file 0
Lock format but allow data entry 1
Internal Data Integrity (Type 4) Details Needed 1
Access database forms 0
'Data Type Mismatch In Criteria Expression' error when using 'Count' in query Design; Help! 0
LISTNUM + Mail Merge + INCLUDETEXT : Referencing Paragraph # Can't get to work 0
data validation - cell lock 0
External SQL data 0

Top