Have three computers, one server, two client, using MS Access database, in the form of Shared files stored in server side, the client terminal network map to Access database server, among them, both client and server through the MFC + Access Access ODBC,

Now found that if the client side and server side, after many times "broken network reconnection" client side read Access data, data synchronization happens, such as breaking the net, there are 100 records of Access database table, broken network, and to Access new article 20, the network after reconnection, the client side only read 100! But if to copy/paste file Access database files, the Client end can read 120 records,

Excuse me, is this a Windows file sharing or Access the bug?

CodePudding user response:

Should be the problem of cache

CodePudding user response:

Try to modify the registry three keys, but the data did not update

HKEY_LOCAL_MACHINE \ System \ CurrentControlSet \ Services \ Lanmanworkstation \ Parameters

DirectoryCacheLifetime
FileNotFoundCacheLifetime
FileInfoCacheLifetime

[DWORD]