I have a database that was being used by two users on the same full DB, but when 3 came, I split it. They are each on their own FEs, linked tables to the main copy BE, and are being kept from
a sometimes not able to move to the previous record
b. sometimes not able to save the record even though one is woking on records 1-50 and the other (only 2 today) is working on 140 down toward 100. Ths is sporatic.
Yesterday one changed records 1-40, but 22 - 27 did not save! Today she got an error message saying the record was locked, but There was not any error message on the 6 that did not save yesterday.
First, what would keep her from being able to move to the previous or next record? The code that was highlighted was form_Current for the form they were on--just changing records, which only has some code about a particular field, if it is a particular value, then to color it a particular way. The error message was "Disk or network error." - only yesterday for that "not moving to a record" problem.
That "Disk or network error" is also happening very intermittantly, like only once a month. It did happen with both of these ladies, who are working on the network drive (both front ends (all 3) and the BE are on that network drive. Nothing is kept on the actual local machines. Is that an Access problem or a hard drive problem?
Second, if they each have their own queries in their own, named front ends, athough the queries are asking for a date of service, whichfor today, the set of 140 records would be the same for all 3, but they then work on different sections of that date's 140 records (1-50, 51 -- 99, 100 - 140), should there be any problems?
Start Free Trial
