Re: Separate PK in Jxn Tbl?
From: Bob Badour <bbadour_at_pei.sympatico.ca>
Date: Mon, 28 Jan 2008 20:13:44 -0400
Message-ID: <479e6fb8$0$4064$9a566e8b_at_news.aliant.net>
>>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.
Date: Mon, 28 Jan 2008 20:13:44 -0400
Message-ID: <479e6fb8$0$4064$9a566e8b_at_news.aliant.net>
Rick Brandt wrote:
> 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.
Apparently you have never had to attach an access app to a new instance of the database it uses. I found that process incredibly awkward, slow and kludgy. Received on Tue Jan 29 2008 - 01:13:44 CET