Validation rule across table link

[Guest]

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.

 

[Jeff Boyce]

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?

 

[John Vinson]

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]

 

[Guest]

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