A family of Microsoft relational database management systems designed for ease of use.
Ok. This problem is strictly within access. When you walk away from the database for a while it occurs more frequently upon search of record or update of a record. I will have several internet and lan functions running and all work fine without a hitch or record of the network being interrupted. It existed in XP, win 7 and win 8. Somewhere I read that one guy accidentally discovered that if the file explorer was open to the database location keeping the win system "present" to that connection, his problem disappeared. I have tried this and it greatly alleviates the issue but does not prevent it from occurring. I have tried keeping it open on the server and seems to help in a similar way but unsure.
- I am solidly convinced it is MS Access having and causing it's own error or how the system services perform on it's behalf.
- I am convinced that Microsoft is unconvinced it is the fault of Access.
- Until that changes, since all aspects of the problem reside within Microsoft products only a work around will solve this so I ask this community to work on item 2 and 3!! and report to Microsoft and the community the results of testing.
I have upgraded all LAN hardware items in the path and the problem remains unchanged.
I have more problems on a 32 bit machine than on 64 bit machines (speed).
I am convinced some kind of refresh issue is part of the problem. I have tried some minor changes in the database settings related to refreshing without any noticeable impact.
I suspect memory paging may be related, as when not active in the database it happens and when you first come back and try anything that links back to the server is the ONLY time it happens which would be coincident to paging back into ram.