December 4th, 2009, 02:36 AM
posted to microsoft.public.access.tablesdbdesign
|
|
|
New to the whole DB world
Spiceworks is free.
On Wed, 2 Dec 2009 08:21:01 -0800, freddy
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
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
--
remove uppercase and number for true email
.
--
remove uppercase and number for true email
|