Re: Separate PK in Jxn Tbl?

From: rkc <>
Date: Sun, 27 Jan 2008 16:05:17 -0500
Message-ID: <479cf216$0$1092$>

Marshall wrote:
> On Jan 26, 11:13 pm, "Brian Selzer" <> wrote:

>> There can be several forms that access the same table, so you would have to
>> duplicate the code behind each form that accesses a table, or you can get
>> garbage into the database.

> Right. And then you need to change a constraint, and you modify the
> code and you remember to update three out of the four forms that
> implement the check, and you get garbage in the database. Or
> any of a number of other things that can go wrong.

Yes. Because Access developers have no need to separate data access from user interface from business rules. Just bind a form to a recordsource, sprinkle some VBA code in a few events and run with it. Received on Sun Jan 27 2008 - 22:05:17 CET

Original text of this message