I have an MS Access Application running in MS Access 2003 which connects to a 2000 format database file. I have the locking set to Edited Record level and ticked the open databases with record level locking.
However, I am still getting page level locks on tables.
I have done some research and found that this is caused by opening the database application via double clicking a shortcut or the mde file:
This article describes the problem and a work around/patch for Access 2000.
I am using Access 2003 SP3 and if I use the work around (ie open Access first and then use file open and not double click to open) then I successfully get record level locking.
Does anyone now how to achieve record level locking AND opening an application mde file by double clicking as I really do not want users to have to open access and then open the mde file - not very user friendly!