Re: Separate PK in Jxn Tbl?
Date: Mon, 28 Jan 2008 14:34:36 -0000
Message-ID: <B1DDA6FA-91EA-4762-AFE9-478F87CFDFFF_at_microsoft.com>
"David Cressey" <cressey73_at_verizon.net> wrote in message
news:fhlnj.2005$k1.588_at_trndny02...
>
> "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.
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 ReynoldsReceived on Mon Jan 28 2008 - 15:34:36 CET