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 |
#11
|
|||
|
|||
New to the whole DB world
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 |
#12
|
|||
|
|||
New to the whole DB world
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 |
#13
|
|||
|
|||
New to the whole DB world
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 |
#14
|
|||
|
|||
New to the whole DB world
All of the given answer are good.
If you want help going the "make an Access DB" route, then start doing what the first 3 respondents have said and, if you need/ could use help, repost, telling us your answers are to the question posed in those responses. |
#15
|
|||
|
|||
New to the whole DB world
All of the given answer are good.
If you want help going the "make an Access DB" route, then start doing what the first 3 respondents have said and, if you need/ could use help, repost, telling us your answers are to the question posed in those responses. |
#16
|
|||
|
|||
New to the whole DB world
All of the given answer are good.
If you want help going the "make an Access DB" route, then start doing what the first 3 respondents have said and, if you need/ could use help, repost, telling us your answers are to the question posed in those responses. |
#17
|
|||
|
|||
New to the whole DB world
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 . |
#18
|
|||
|
|||
New to the whole DB world
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 . |
#19
|
|||
|
|||
New to the whole DB world
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 . |
#20
|
|||
|
|||
New to the whole DB world
Oho! Willing to spend people's time/salary, but not willing to purchase
software or hire expertise...? Best of luck! Regards Jeff Boyce Microsoft Access MVP -- Disclaimer: This author may have received products and services mentioned in this post. Mention and/or description of a product or service herein does not constitute endorsement thereof. Any code or pseudocode included in this post is offered "as is", with no guarantee as to suitability. You can thank the FTC of the USA for making this disclaimer possible/necessary. "freddy" wrote in message ... 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 . |
Thread Tools | |
Display Modes | |
|
|