Tags:
MS, MS Access, MS Access 2007, Delphi Application
I have a delphi application that uses an Access database (MS Access 2007). I know "boo hisss" but after all that, I need to know under what circumstances would there be a record locking issue? If, through the application, two or more different users attempted to access / update the same record what would be some of the possible disaterous results? Is there any way to (aside from upgrading to a database that isn't free) prevent record locking issues? Would using client data sets help to solve any potential record locking issues?