I wrote my inventory to collect hardware details like SN, CPU, video, make, model, HD, etc to one table... for 'static' one-time collected data. and a seperate one with SN, name, ram, modem, current user, etc. to a 'dynamic' table that is updated at every login.
see my kix page to a view of the relationship table and a copy of the empty MDB
BTW, if one of you access sql geniuses could write me op the 'table building' sql for access statements, I would be grateful. I'd like to be able to dynamically build the tables at need.. move it away for archival and the next user to login would be able to automatically create the mdb and create the tables...
[ 17. January 2003, 00:30: Message edited by: Radimus ]
