ACCESS Validation Rule not displayed

Question

When I created the Access Wine Database I created the Book field with the following properties:

Book …… (I2)*                              {Number, Integer, Fixed, 0 Decimal Places}

  {Validation Rule: >0 And < 30} {Validation Text: Book must be between 0 and 30}

When I created the above Validation Rule, I assumed that I would never have more than 29 Books (Livres de Cave).  I am now on Book 30.

When I tried to enter 30 for the Book, I was correctly prevented from doing so by the above Validation Rule.

When I went into Design View mode, I was surprised to find that no Validation Rule was shown, even though it was correctly functioning, as explained above.

Both the Validation Rule and Validation Text fields are shown blank.

I would have thought that If I could display the Validation Rule, I would simply need to replace 30 by 90 (say) and the problem would be solved.

How do I get Access to display the Validation Rule that I originally created and that it is clearly using?

Answer 1

That is a "relationship" you're seeing in that relationships window and has nothing to do with Linked Tables. Linked Tables are external table (stored in a separate database) which you'd "linked" into your database. If you don't show the link (the blue arrow), then you don't have linked tables, and you should be able to find the validation rule in either the table or form.

Here's more information on validation rules:

https://support.office.com/en-us/article/restrict-data-input-by-using-validation-rules-b91c6b15-bcd3-42c1-90bf-e3a0272e988d

Answer 2

Dear Mr McDaniel,

From your reply, a solution would appear possible. The field Book is a field in the table Storage which is listed as frmWineEntry in the list of Forms. The Wine Database is shown as being in Access 2000 file format.  When I held the mouse over frmWineEntry it simply displayed frmWineEntry. How do I now proceed?

Thank you for your help.

Dr John Higinbotham

Answer 3

You'd have to find the backend tables and open that file directly. You can determine where they're located by hovering your mouse over the table in the Navigation Pane. You should see the full path to the backend file.

Answer 4

Dear Mr McDaniel,

Thank you for your reply.  I created this database about 15 years ago using Access 2002 with 4 linked tables. It is now running it on Access 2016.  To create the database, I followed the procedure in Using Access 2002, Roger Jennings (QUE).  I used the wizard that, from memory, creates tables that were then linked.  It would appear that I need to access the actual souce backend database.  How do I do this?

Kindly reply.

Dr John Higinbotham

Answer 5

Where did you create the rule? If it's at the table level you'd have to do so in the table designer. If you did it on the form, you'd have to do it in the form.

Also, if you have linked tables, you would have to do so in the actual source backend database, not on the linked frontend tables.