Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004

    Unanswered: Which option looks best

    I need to make a DB that stores what connected to every port on each switch/hub we have here (good times...)

    Which would be the better way to go with access.
    1) Store everything in one table by device (PC, Switch, Port, MAC, etc)
    2) Create a table for each switch/hub and give them the number of fields that the switch/hub has.

    The creation of #1 is making my skin crawl, 2 seems easier to create/manage but 150 tables would be crazy right

  2. #2
    Join Date
    Feb 2004
    Chicago, IL
    The 'proper' way would probably be a combination of both. You would have a Switch/Hub table that had information about each switch. Ex. SwitchID, Location, Ports, Model, Make etc. And then you would have a Ports table that had a link back to the Switch/Hub ID. In this table you would have SwitchID, Port#, DeviceID. And then you would have a Device table with DeviceID, DeviceTypeID, DeviceName, Etc. And Finally you might have a DeviceTypeID for all the types of devices you have.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts