[AccessD] Non-updateable Queries

Admin Sparky dba.email at gmail.com
Thu Oct 27 16:12:03 CDT 2005


<For best viewing, a mono-spaced font is recommended.>
 Group,
 Please comment on the table structure noted below. I chose this particular
scheme because locations are the least likely to change and are forming the
cornerstone of an Access-AutoCAD application. My problem concerning data
updates is that equipment is most easily identifiable with a person, not a
location. But, a non-updateable recordset occurs when these tables are
combined in a query. So...what is an acceptable method of approaching this
situation?
  |--tblLocPers---tblPersonnel
 |
 |--tblLocPC-----tblPCs
tblLocations--|
 |--tblLocMon----tblMonitors
 |
 |--tblLocPrntr--tblPrinters
  Mark



More information about the AccessD mailing list