New to the whole DB world
in [Tables]
|
From: jacksonmacd on 3 Dec 2009 21:36 Spiceworks is free. On Wed, 2 Dec 2009 08:21:01 -0800, freddy <freddy(a)discussions.microsoft.com> wrote: >The problem is that the company does not want to spend money. > >"jacksonmacd" wrote: > >> I know this is an Access newsgroup, and you are looking for an Access >> answer, but have you considered that you might be reinventing the >> wheel? Perhaps an off-the-shelf solution like Spiceworks >> (spiceworks.com) might save you a lot of work. >> >> But then again, you might be looking to improve your Access skills. >> >> PS. I have no affiliation with Spiceworks or any other similar >> software. >> >> >> On Tue, 1 Dec 2009 07:48:01 -0800, freddy >> <freddy(a)discussions.microsoft.com> wrote: >> >> >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 >> >> -- >> jackmacMACd0onald(a)telus.net >> remove uppercase and number for true email >> . >> -- jackmacMACd0onald(a)telus.net remove uppercase and number for true email |