GameCharmer
New member
- Local time
- Today, 09:56
- Joined
- May 9, 2008
- Messages
- 4
I decided that I would like to be able to lay my networking structure out in a nice Access Database so I can manage all of the connections easier than an Excel Sheet. I made the following tables
Rooms
(Room_ID, Room_Name, Room_Phone_ID, Room_Data_ID)
PhoneConnections
(Phone_ID, Phone_Panel_Name, Phone_Connection_Number, Phone_Extension)
NetConnections
(Net_ID, Net_Number, Net_POD, etc)
POD
(POD_ID, POD_Name, Pod_Max_Connections, POD_Master)
The Rooms table stores the ID for the net connection that is running to that room as well as the phone connections, so that table is taken care of. PhoneConnections is just info about the phone system. NetConnections has several more fields describing the connection type and the line material, dates, and other stuff but it not only links to a room, but to a POD. The POD table is what I need help with.
Basically, we decided to get an array of 8-port gigabit switches to remap our entire network with instead of the two large expensive switches that sit in one room. We just call the switches Pods, because the owners can understand it better.
I've seen the Switchboard in Access do this same thing, but I don't understand it. I want items in the POD table to be able to reference other items in the POD table. My ultimate goal is to start at the main switch that is connected to the router / servers, and see it's "children" switches. From there, I can click on a switch and see the sub switches. Then, Click on a switch to see a computer.
This could be done in the Switchboard system, considering that the max one switch can have is 7 connections (1 always goes back to the parent totaling 8) and the switchboard can only handle 8. I just don't know how to manipulate the code to get other info to display.
Any help would be greatly appreciated.
MAIN
|-"AMain"
| |-A1
| | |-Comp 1
| | |-Comp 2, etc
| |-A2
| | |-Comp 1
| | |-Comp 2
| | |A2-B
| | | |-Comp 1
| | | |-Comp 2
|
|-"BMain"
|-etc
EDIT---
Upon playing with 2007 more, I discovered that you can have more than 8 possible switchboard items.
I have the majority of the database done and I just need to populate data. I can post a link to an online copy if anyone would like to see what I'm working on.
Rooms
(Room_ID, Room_Name, Room_Phone_ID, Room_Data_ID)
PhoneConnections
(Phone_ID, Phone_Panel_Name, Phone_Connection_Number, Phone_Extension)
NetConnections
(Net_ID, Net_Number, Net_POD, etc)
POD
(POD_ID, POD_Name, Pod_Max_Connections, POD_Master)
The Rooms table stores the ID for the net connection that is running to that room as well as the phone connections, so that table is taken care of. PhoneConnections is just info about the phone system. NetConnections has several more fields describing the connection type and the line material, dates, and other stuff but it not only links to a room, but to a POD. The POD table is what I need help with.
Basically, we decided to get an array of 8-port gigabit switches to remap our entire network with instead of the two large expensive switches that sit in one room. We just call the switches Pods, because the owners can understand it better.
I've seen the Switchboard in Access do this same thing, but I don't understand it. I want items in the POD table to be able to reference other items in the POD table. My ultimate goal is to start at the main switch that is connected to the router / servers, and see it's "children" switches. From there, I can click on a switch and see the sub switches. Then, Click on a switch to see a computer.
This could be done in the Switchboard system, considering that the max one switch can have is 7 connections (1 always goes back to the parent totaling 8) and the switchboard can only handle 8. I just don't know how to manipulate the code to get other info to display.
Any help would be greatly appreciated.
MAIN
|-"AMain"
| |-A1
| | |-Comp 1
| | |-Comp 2, etc
| |-A2
| | |-Comp 1
| | |-Comp 2
| | |A2-B
| | | |-Comp 1
| | | |-Comp 2
|
|-"BMain"
|-etc
EDIT---
Upon playing with 2007 more, I discovered that you can have more than 8 possible switchboard items.
I have the majority of the database done and I just need to populate data. I can post a link to an online copy if anyone would like to see what I'm working on.
Last edited: