If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
New to the whole DB world
I am a desktop support person and I have a vbscript to inventory all the
computers on the network. I use the script to gather information like username, memory, hard drive space, and I am thinking about getting installed software. I have the script writing to an excel file, which is ok for now. I would like to use Access 2003 but my problem is the design. Do I create one table and have a field for username, computer name, memory, and so on or do I create more than one table like for username and one for computername. Plus how do I handle the installed software? My idea was to have three tables: one for username which will have full name, one for computername which will have all the computer stuff like memory, hd, etc and one for software which will have software name, version, installed date, etc. Please someone help me out. Thanks Freddt |
Thread Tools | |
Display Modes | |
|
|