View Single Post
  #129  
Old January 28th, 2008, 02:34 PM posted to comp.databases.ms-access,comp.databases.theory,microsoft.public.access,microsoft.public.access.tablesdbdesign,microsoft.public.sqlserver
Brendan Reynolds
external usenet poster
 
Posts: 1,241
Default Separate PK in Jxn Tbl?

"David Cressey" wrote in message
news:fhlnj.2005$k1.588@trndny02...

"David W. Fenton" wrote in message
.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