not automatically.How would this be maintained?
Why Access? Have you investigated any network scanning tool(s) that could do some of this automatically?
they just want to have a profile card for each employee.
not automatically.How would this be maintained?
Why Access? Have you investigated any network scanning tool(s) that could do some of this automatically?
I don't want to have a form for entering the personnel.Yes that's correct.
So you have a table listing all Personnel and table listing all Types of Equipment.
Now you need a table to link Personnel to Equipment Details.
Something along the lines of:-
tblEquipmentDetails
-EquipmentDetailID PK - Autonumber Long Integer
-PersonnelID FK - Number - Long Interger (Linked to PersonnelID PK)
-EquipmentTypeID - Number - Long Integer (Linked to EquipmentTypeID PK)
-EquipmentSerialNo
-EquipmentMake
-EquipmentModel
This is just a rough guide
So How would you manage the process when an employee has to replace a specific piece of equipment?I don't want to have a form for entering the personnel.
I want to have a button name is " new profile card"
if I click on that T a form would be opened.
in this form I would enter
name of employee
the network IP
Admin Username
Admin Password
Local Username
Local Password
without having a combo box that select from that. I will filled these control by typing.
but for the equipment I want to enter the ID that I defined before.
also I want to be able , whenever I enter the ID , the access automatically understand the type of equipment.
here the equipment matters.So How would you manage the process when an employee has to replace a specific piece of equipment?
thanks for your attention and suggestions.The U.S. Navy kept something similar but they didn't bother with some things that were beneath notice. For instance, we had a laptop with a Navy "property number" tag. There was a tagged docking station and a tagged monitor. But they didn't bother to track mouse and keyboard because neither of them had any "smarts" - just a USB mouse & keyboard. The mouse and keyboard were "automatic" with the laptop and were treated like staplers and tape dispensers - just another item to keep in the supplies locker.
They had a person table and a tagged item table. If an item was in the warehouse, it had a location code that said Warehouse but it had the owner code of the Navy. If it was checked out to a person, it had a location code that said the office area (open-plan office, so basically room number) and an owner code of the person responsible for it.
Under NO repeat NO circumstances would we have ever kept a password. We used the method that involved a one-way hash of the input password and we merely hashed the offered password to compare hashes. We also did not keep Admin usernames because for Windows that is a fixed string anyway. For security purposes, you never ever IN A GAZILLION YEARS keep a password.
thank youI was closer to done than I thought. Here is the sample. It is not well tested and it is slightly different from what you were thinking. It is also far from done. you need to add a lot of stuff to it to make it actually usable. But, it is a start.
There are dedicated tools that can achieve what your IT department are trying to do! I query their competency if they are trying to achieve this using MS access even though it can be done..In our office, there are about 30 desktops connected to our local network and employees work with them.
the IT department wants to keep and save properties of each computer.
they want to know Who works with what computer with what properties quickly.