[AccessD] Non-updateable Queries

MartyConnelly martyconnelly at shaw.ca
Thu Oct 27 16:26:39 CDT 2005


Maybe have a look at this data model for ideas and it's associated 
business rules.
http://www.databaseanswers.org/data_models/inventory_of_servers_in_wyoming/index.htm

There are a couple hundred here too.
http://www.databaseanswers.org/data_models/index.htm

Admin Sparky wrote:

><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
>  
>

-- 
Marty Connelly
Victoria, B.C.
Canada






More information about the AccessD mailing list