|
Well, I've figured out how to add the information to an Access database, but what would the best format for the database be?
At first I was thinking of having two tables. One computer table would have a field (column) for each computer and the records (rows) below would contain a program name entry. Another table for programs would have a field for each program and the records below would contain computer names. I was going to do it like this, but I can't find how to add fields (colomns) in ADO. If I can't add filelds I can't add more programs to the programs table and I can't add computers to the computer table. I would rather have created the DB this way since it would be much easier to do queries (at least as far as I can tell).
What I have ended up doing is creating one table with two fields, computer and program. If a computer has 10 programs installed then there will be 10 entries of the computer name in the computer field and one instance of the program in the adjoining program field. For my meager access skills this poses a problem. First, if I create a list box of the computers how will I edit out the multiple entries for the computer name. Second, same as the first but programs. Is it possible to create a form in access to have a listbox containing one instance of each computer and have a corresponding listbox containing all programs assoicated with that computer? I could probably do this in kixforms but that would create a mess with having to query the DB or read the entire DB into an array or arrays. Damn, I thought the hard part was over once I got the info into the DB. Any ideas?
If anyone is interested I'll post my code for parsing the software inventory files and then adding the data to the DB.
[ 30. August 2002, 11:51: Message edited by: Vig ]
| 
