Re: linking databases

Kevin wrote:
Hi,

I'd like to know if, after you've linked two tables from two different
Access databases, you can update records in both tables by simply
upadating the records in one of them. So if I change "dtmYear" from
say 1997 to 1998 in one table, then "dtmYear"in the second table
would also be changed from 1997 to 1998. Is there way a to do this?

No. A relationship with enforced RI would be required to do that and you cannot
build such a relationship across tables in more than one file.

It could be done in code if all updates were made via forms though.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com


.

Loading