If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Validation rule across table link
Access 2003. Database was split using splitter to Objects (Forms and Queries)
and DataTables. Links all appropriately and automatically established by Access. They are fully functional. After split established an e-mail validation rule using the Design View of the Table on the DataTables side. The validation rule works correctly as expected under DataSheet view of the Table on the DataTables side. From the Objects collection side, the validation rule for this linked table appears not to be recognized. Attempts to enter the same validation rule for the linked table on the Objects side unsuccessful, as entry seems possible, but not being saved when changes are updated. I've got to be missing something very fundamental here. Can anyone help? As always ... thanks for the solution I know is forthcoming. |
#2
|
|||
|
|||
I don't follow what you mean by "established an e-mail validation rule". If
you make a change to the underlying table definitions in the back-end, there's a chance that your linked front-end is still using it's "old" definition. Have you used the Linked Table Manager in your front-end to select and re-link all your tables? -- Good luck Jeff Boyce Access MVP "The Grape Hunter" wrote in message ... Access 2003. Database was split using splitter to Objects (Forms and Queries) and DataTables. Links all appropriately and automatically established by Access. They are fully functional. After split established an e-mail validation rule using the Design View of the Table on the DataTables side. The validation rule works correctly as expected under DataSheet view of the Table on the DataTables side. From the Objects collection side, the validation rule for this linked table appears not to be recognized. Attempts to enter the same validation rule for the linked table on the Objects side unsuccessful, as entry seems possible, but not being saved when changes are updated. I've got to be missing something very fundamental here. Can anyone help? As always ... thanks for the solution I know is forthcoming. |
#3
|
|||
|
|||
On Sat, 26 Feb 2005 14:59:02 -0800, "The Grape Hunter"
wrote: Access 2003. Database was split using splitter to Objects (Forms and Queries) and DataTables. Links all appropriately and automatically established by Access. They are fully functional. After split established an e-mail validation rule using the Design View of the Table on the DataTables side. The validation rule works correctly as expected under DataSheet view of the Table on the DataTables side. From the Objects collection side, the validation rule for this linked table appears not to be recognized. Attempts to enter the same validation rule for the linked table on the Objects side unsuccessful, as entry seems possible, but not being saved when changes are updated. I've got to be missing something very fundamental here. Can anyone help? As always ... thanks for the solution I know is forthcoming. The table in the frontend is ONLY a link to the actual table, which exists in the backend database. As such, you cannot define table properties such as validation rules, relationships, indexes, etc. in the frontend; you must either open the backend database directly and create or change the rule there, or enforce the validation in VBA code on the Form being used to update the table. John W. Vinson[MVP] |
#4
|
|||
|
|||
Thanks to you both ..Jeff and John,
While I was hoping for something a little more fundamental and straight forward, I accept the value of your suggestions. I have received and read your valued input and responses to this site, and recognize you both as very knowledgeable contributors. Thank you for your guidance. I will have to invest a little more of my own energies to some education and solving my problem here. with my thanks .....Keith "John Vinson" wrote: On Sat, 26 Feb 2005 14:59:02 -0800, "The Grape Hunter" wrote: Access 2003. Database was split using splitter to Objects (Forms and Queries) and DataTables. Links all appropriately and automatically established by Access. They are fully functional. After split established an e-mail validation rule using the Design View of the Table on the DataTables side. The validation rule works correctly as expected under DataSheet view of the Table on the DataTables side. From the Objects collection side, the validation rule for this linked table appears not to be recognized. Attempts to enter the same validation rule for the linked table on the Objects side unsuccessful, as entry seems possible, but not being saved when changes are updated. I've got to be missing something very fundamental here. Can anyone help? As always ... thanks for the solution I know is forthcoming. The table in the frontend is ONLY a link to the actual table, which exists in the backend database. As such, you cannot define table properties such as validation rules, relationships, indexes, etc. in the frontend; you must either open the backend database directly and create or change the rule there, or enforce the validation in VBA code on the Form being used to update the table. John W. Vinson[MVP] |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Here's a shocker | Mike Labosh | General Discussion | 2 | October 26th, 2004 05:04 PM |
Table Wizard Does Not Set Relationship if Foreign Key and Primary Key Name Do Not Match Exactly in Case. | HDW | Database Design | 3 | October 16th, 2004 03:42 AM |
Fw: Validation rule problem | Geo | Using Forms | 0 | September 14th, 2004 08:38 AM |
Location of Validation Text | lkb | Database Design | 8 | June 30th, 2004 10:45 PM |
COMPARE THE TWO TABLES | Stefanie | General Discussion | 0 | June 4th, 2004 04:36 PM |