Hello!
I am having some problems with a simple 2 related tables:
1. Order (parent)
2. Order-Details (child)
In Order table I have an OrderNo Autonumber field that is also the primary key.
The tables are in "1 to many" relation with "Enforce Referential Integrity" checked.
I have one form in Master/Details scenario and one form that is using a query that use data from both tables and which is used for modify one specific field in the "child table" (Order-Details).
Even in this simple configuration, with only 2-3 concurent users the database will broke strangely:
- PK missing in the parent table
- Relation dissapeared
- on compact and repair the MSysCompactError table reads 3 errors:
ERR:-1017 - Could not find field 'Description'. (in parent table)
ERR:-1053 - Could not find field 'Description'. (in parent table)
ERR:-1522 - No unique index found for the referenced field of the primary table. (in child table)
- on the child table will remain orphaned records
- on the parent table will remain an blank autonumber field with a lot of "####" on some other fields.
I have checked the PC's hardware, networking... but I cannot understand what in ACCESS could break the tables in this way.
Any sugestion on how to catch the problem?
Kind regards,
Lucian
I am having some problems with a simple 2 related tables:
1. Order (parent)
2. Order-Details (child)
In Order table I have an OrderNo Autonumber field that is also the primary key.
The tables are in "1 to many" relation with "Enforce Referential Integrity" checked.
I have one form in Master/Details scenario and one form that is using a query that use data from both tables and which is used for modify one specific field in the "child table" (Order-Details).
Even in this simple configuration, with only 2-3 concurent users the database will broke strangely:
- PK missing in the parent table
- Relation dissapeared
- on compact and repair the MSysCompactError table reads 3 errors:
ERR:-1017 - Could not find field 'Description'. (in parent table)
ERR:-1053 - Could not find field 'Description'. (in parent table)
ERR:-1522 - No unique index found for the referenced field of the primary table. (in child table)
- on the child table will remain orphaned records
- on the parent table will remain an blank autonumber field with a lot of "####" on some other fields.
I have checked the PC's hardware, networking... but I cannot understand what in ACCESS could break the tables in this way.
Any sugestion on how to catch the problem?
Kind regards,
Lucian