98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Access Training and help » Lost relationships
Lost relationships
Resolved · Low Priority · Version 2016
Wed 24 Jan 2018, 14:43Delegate Charlotte said...
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
Wed 24 Jan 2018, 22:02Trainer Jens said...
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
Wed 31 Jan 2018: Automatically marked as resolved.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:Create calculated fields that work out your ageYou can uset eh year function to work out the year from NOW function and then subtract it with your date of birth type field |
