Re: Separate PK in Jxn Tbl?

From: Brendan Reynolds <>
Date: Mon, 28 Jan 2008 14:34:36 -0000
Message-ID: <>

"David Cressey" <> wrote in message news:fhlnj.2005$k1.588_at_trndny02...
> "David W. Fenton" <> wrote in message
> news:Xns9A329D4116528f99a49ed1d0c49c5bbb2_at_64.209.0.89...
>> wrote in
>> 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.

The app and the data *can* be stored in one MDB, but do not *have* to be stored in one MDB (linked tables). It is entirely possible - and in my experience not unusual - to have more than one application reading and or updating data in an MDB (or ACCDB).

Brendan Reynolds 
Received on Mon Jan 28 2008 - 15:34:36 CET

Original text of this message