Log In

Database Relationship Errors

When trying to establish relationships in Access, sometimes you might get errors saying that the ‘database is locked’. There are two reasons for this:

  1. The parent table needs to have ‘AutoNumber’ type for the primary key for ‘FieldWhatever’. Then the child table for ‘FieldWhatever’ has to have ‘Number’ as its type.
  2. The other reason is that you must close all open tables in order to establish a relationship. It’s always a good idea to right click on an active tab and close all in order to clear whatever you’re viewing before looking at relationships.

You can’t have one-to-many relationships with more than one parent to more than one child. So go to Relationship Tools [tab] > Design > All Relationships and then make sure to delete whatever relationships that you don’t need that could be tying up the new relationship you’re trying to establish.

Relationship Errors

 

 

Once you’ve fixed your relationships, then you can use cascading tables (providing that you checked ‘enforce integrity’ when you were making the one-to-many relationships) to plug in which students are attending which classes.

 

Cascading tables

Print Friendly

Leave a Reply

Your email address will not be published. Required fields are marked *


Fatal error: Call to a member function attributes() on a non-object in /home4/realubit/public_html/gloss/wp-content/themes/News2/gavern/widgets.weather.php on line 299