|
I am in the process of converting an application from BDE to
ADOExpress using an Access 97 back-end - Delphi 6.
I am constrained to using Access 97 back-end via
ADOExpress.
Everything works fine on a single machine; but when I try ro
run the application with 2 concurrent users I can't find any way to retrieve the
latest version of a record from the physical underlying database - in other
words if I update a record on one machine then the updates are not visible when
I retrieve the same record on the second machine.
I have tried various CursorTypes but these are restricted to
Client Server apps. Refresh comes back with an error about having "insufficient
key column information for updating or refreshing". Resync achieves nothing.
Closing and reopening the database achieves the desired result but takes about
10 seconds for 15,000 records which is unacceptable.
Any ideas appreciated.
Steve Galyer |
