Record Locking

[ddtpmyra]

Using SQL db I can do a query that will do no record locking on my script without interruption with other queries.

example of SQL commands
select * from employee with (nolock)

My question is how can this be done on Access environment having link tables to SQL dbase. The reason of bringing out this question is to eliminate interuptions of record locking while other's performing their query simulteneously.

[PianoMan64]

that particular option isn't available if you're using ODBC to connect to SQL Database.

If you go into the forms properties and find the record-locking type and set that to no record locking, that should do what you're looking for.

The other option you have is to connect SQL Server with an external query and pass it that option if it is support by that SQL Server?

If you need details, let me know. I'm very familiar with writing Oracle Queries if that's what you're using.

Hope that helps,

Joe P.

[ddtpmyra]

Hi Joe,

Yes I do have ODBC connection to SQL Dbase. The thing is once the text box or command button was click it should execute the query and export it to excel. Where I can't do the form property set-up to 'record = no lock' as you describe above.

And to make it safe please tell me how to set up an external query, it would be a great help!

thanks in advance,
Myra