Charlotte has attended:
Access Introduction course
Lost relationships
Hi STL,
I have been working on a database and started entering data. the database came up with an error stating the database was in an instable state and a Compact and Repair was run. Following this the forms and queries stopped working and on closer inspection I noticed four relationships had been removed.
Is this related to the Compact & Repair function or are there other reasons relationships may disappear? Also is there a way of avoiding this in future?
Thank you for you assistance.
Kind regards,
Charlotte
RE: Lost relationships
Hi Charlotte,
Thank you for the forum question.
I have never heard that Compact and Repair can delete relationships and I have not been able to find any examples by Google the issue.
Somehow you must have a problem in your database. Try to create the relationships again and "Enforce Referential Integrity". See if this return an error. If the related fields are working with different data types you will get an error or if your foreign key do not have a primary key you will also get an error.
If you do not get an error by "Enforce Referential Integrity" Analyse the performance of all objects from the Database Tools tab. Have a close look at the report and see if Access points out some issues.
There can be a lot of reasons for problems in MS Access. If you Google MS Access corrupted issues you will find many links which can be useful to repair your database.
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
