Hi,

I just upsized my Access application and connect to SQL server 2000 via ODBC tables links. By doing so the standard optimistic locking of SQL server 2000 comes into force and the option "lock edited record" on the Access Client gets ignored. I cannot work with optimistic locking because if e.g. an order gets entered in a table and e.g. a stock allocation job runs in the background that updates the order header all the entered data will be lost (or must be copied to the clipboard and edited ...). Does anybody know how to overcome this problem - should be quite common ...

Any comments are appreciated!

Thanks.
SON

Hi there

Look up set transactional isolation lvl in the SQL server helpfile (BOL) this should give you what you need

Hi SQL-Hell,

Thanks for the brilliant tip!
I did not install the Analysis Server because I thought I will not need it in the first place. The SQL Server Books Online come with this package (just for info of other newbies like me!).

Hi there

BOL is seperate from analysis services :confused: