I have an Access 97 DB which has been running for over a year without these problems.
Recently a user told me when a certain field is updated another field is no longer automatically updated. Normally, upon update of the first field, the auto update does a seek on a table and picks up data from another table and places that data in the form being updated. I am not sure if it now never works or sometimes doesn't.
Another new problem is within a query used as the source for a report. The same user runs a monthly report using a form for the "From" and "To" dates of records which have a date in a certain field within the requested time period. The query selects records Between "From" And "To" and has been working fine. Now the query is selecting a subset of the records. There 15 records in the DB that qualify for the search she is doing but the query finds 6. I can't see any difference in the found/not found records that would cause this.
The only difference I can think of in the DB recently is that I split it and made an mde file. All the users are networked in the same office except the one who found the problem and she is accessing via a VPN. I tried my development version of the DB and the same subset is found using a copy of the production data. All I can think of is that splitting the DB may be causing some weird problem when records are added or updated which affects the query.
Any suggestions on either of these?
Recently a user told me when a certain field is updated another field is no longer automatically updated. Normally, upon update of the first field, the auto update does a seek on a table and picks up data from another table and places that data in the form being updated. I am not sure if it now never works or sometimes doesn't.
Another new problem is within a query used as the source for a report. The same user runs a monthly report using a form for the "From" and "To" dates of records which have a date in a certain field within the requested time period. The query selects records Between "From" And "To" and has been working fine. Now the query is selecting a subset of the records. There 15 records in the DB that qualify for the search she is doing but the query finds 6. I can't see any difference in the found/not found records that would cause this.
The only difference I can think of in the DB recently is that I split it and made an mde file. All the users are networked in the same office except the one who found the problem and she is accessing via a VPN. I tried my development version of the DB and the same subset is found using a copy of the production data. All I can think of is that splitting the DB may be causing some weird problem when records are added or updated which affects the query.
Any suggestions on either of these?
