revver
Active Member
- Joined
- Dec 20, 2007
- Messages
- 257
I have Access 2003 running on a terminal server and the .mdb file living on a file server. This setup has been operational several months (since before Christmas) without problems. There are up to 20 users.
The principal activity of the app is to add records to a table consisting primarily of a couple of memo fields and a couple of date fields. It records a contact visit with a client and any follow up info. The memo fields are called Note and Action and the date fields are DateTimeNoted and DateOfContact. The primary key is AutoNumber.
Last Thursday a user (1) complained that two notes she had entered and printed had disappeared. I checked the prints and sure enough there were no matching records in the table around the DateTimeNoted and no missing record numbers. As a result, I modified the report to show the record number.
Friday I had a similar call from another unrelated user (2) to say a note she had printed had disappeared. The record number on her printout was 6927 but, in the table, that record related to another client contact by a different unrelated user (3). I concluded that user 3 had overwritten the original record 6927 saved and printed by user 2.
It's Monday and I have had several users complain of missing records so far. Now every note is being printed as soon as it has been saved. I hope this will give me something to analyse because I am at a loss to know what is happening and why. All users report nothing unusual or different when they entered their notes.
Can anyone shed any light on what might be happening and why. What about a strategy to debug the problem? As I say, its been fine until now. Surely Access can handle 7,000 records in a single table. The client table has < 1,000 records, about half of which are active.
The principal activity of the app is to add records to a table consisting primarily of a couple of memo fields and a couple of date fields. It records a contact visit with a client and any follow up info. The memo fields are called Note and Action and the date fields are DateTimeNoted and DateOfContact. The primary key is AutoNumber.
Last Thursday a user (1) complained that two notes she had entered and printed had disappeared. I checked the prints and sure enough there were no matching records in the table around the DateTimeNoted and no missing record numbers. As a result, I modified the report to show the record number.
Friday I had a similar call from another unrelated user (2) to say a note she had printed had disappeared. The record number on her printout was 6927 but, in the table, that record related to another client contact by a different unrelated user (3). I concluded that user 3 had overwritten the original record 6927 saved and printed by user 2.
It's Monday and I have had several users complain of missing records so far. Now every note is being printed as soon as it has been saved. I hope this will give me something to analyse because I am at a loss to know what is happening and why. All users report nothing unusual or different when they entered their notes.
Can anyone shed any light on what might be happening and why. What about a strategy to debug the problem? As I say, its been fine until now. Surely Access can handle 7,000 records in a single table. The client table has < 1,000 records, about half of which are active.