lost relationships

AI Training: For Busy Decision Makers & Professionals Book now

Forum home » Delegate support and help forum » Microsoft Access Training and help » Lost relationships

Lost relationships

resolvedResolved · Low Priority · Version 2016

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

Wed 31 Jan 2018: Automatically marked as resolved.

 

Training courses

 

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
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Access tip:

Create calculated fields that work out your age

You can uset eh year function to work out the year from NOW function and then subtract it with your date of birth type field

Age=Year(Now( ))-Year([DoB])

View all Access hints and tips


Server loaded in 0.13 secs.