Re: Separate PK in Jxn Tbl?

From: Ed Murphy <>
Date: Sun, 27 Jan 2008 23:27:38 -0800
Message-ID: <479d8483$0$6141$>

rkc wrote:

> 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.

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

Original text of this message