Search results

Really useful information, thank you very much

The tables supplying the correct value did not have a primary key. When I identified one, the query works. Who would thunk it.:rolleyes: Thank you.:) Do you know of any source for information on using Access as a front end, or for upgrading ACCESS to SQL Server?

The record only locks in SQL Server if you have opened it to UPDATE or DELETE it, a simple read will not lock it. Go to the SQL forum and ask. I suspect you need to build a stored proc which will lock the record if you access it to read only

The Access database shows linked table to SQL Server (tblWork) and maintains local copies (tblWork_Local) Before I upgraded to this configuration from a simple Access database, this update query worked UPDATE tblWork INNER JOIN tblWrkWkAllDates ON tblWork.BDT = tblWrkWkAllDates.WDate...