Re: Separate PK in Jxn Tbl?

Bob Badour wrote:
> 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.
>
> While awkward, slow and kludgy, it is possible to attach an Access app
> to an external database.

There are a great many of us who almost exclusively build Access apps that use server back ends. Mine use SQL Server and UDB400 on the IBM ISeries. I only use MDBs to store data in single-user desktop apps.

There is nothing awkward, slow, or kludgy about it.

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