The problem is with the database: the data from the record in the Access 2003 database has disappeared. This database has 1 backend and 3 interfaces, several users and is hosted on Citrix. In this database, we have records of all customers served since the 1000s.
Background information: the form for entering customer data is configured with various subordinate forms, including both the subordinate "program program" and the subform "services". A client can be registered in several programs. After registering in the program, services can be entered for this program area using the service subform. There are several fields in the service subsystem, one of which is a drop-down field that allows you to choose from the programs into which the client has been registered (the list is updated for this client whenever it is registered in a new program).
Details of the problem: for one specific record and one specific program area, the program disappeared from the subordinate program, and all related services disappeared from the “service” subform within 3 months of the record data. However, other programs and services for this entry have not disappeared.
Questions: Is data extinction a common Access 2003 problem? Are there any tests that can be run to check if the data has disappeared and catch that data? If so, then who are they? If there is specific code, what is it? What can be done to prevent data extinction (other than using a different database)?
source
share