Records being overwritten.

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.
 

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"

Forum statistics

Threads
1,226,223
Messages
6,189,710
Members
453,566
Latest member
ariestattle

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top