Re: Separate PK in Jxn Tbl?

David Cressey wrote:
> "David W. Fenton" <XXXusenet_at_dfenton.com.invalid> wrote in message
> news:Xns9A329D4116528f99a49ed1d0c49c5bbb2_at_64.209.0.89...
> > CDMAPoster_at_fortunejames.com wrote in
> > news:db4e7666-f9ef-4c72-a483-f951b80c6183_at_k39g2000hsf.googlegroups.co
> > m:
> >
> > > If the users only access the tables through forms, conforming to
> > > best practices in Access, how are they going to get garbage into
> > > the tables?
> >
> > What if there's more than one application built on top of the
> > database?
> >
>
> I believe this is a moot point when it comes to MS Access. The app
> and the database are all stored together in Access. There is, by
> definition, only one Access.
>
> Access regulars, feel free to correct this if it's wrong.

It's wrong :-)

It is the norm for a single-user non-serious app built largely by using the wizards.

It is the opposite of the norm for a multi-user app built by someone who knows what they are doing.

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