Re: Separate PK in Jxn Tbl?
From: Ed Murphy <emurphy42_at_socal.rr.com>
Date: Sun, 27 Jan 2008 23:27:38 -0800
Message-ID: <479d8483$0$6141$4c368faf_at_roadrunner.com>
>
> 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.
Date: Sun, 27 Jan 2008 23:27:38 -0800
Message-ID: <479d8483$0$6141$4c368faf_at_roadrunner.com>
rkc wrote:
> Marshall wrote:
>> On Jan 26, 11:13 pm, "Brian Selzer" <br..._at_selzer-software.com> 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.
The few Access projects that I've taken over have precisely followed the "just bind a form" approach. Which is presumably why the original developers were sacked and I was brought in... :) Received on Mon Jan 28 2008 - 08:27:38 CET