Jump to content

rendrag

Member
  • Posts

    694
  • Joined

  • Last visited

  • Donations

    $0.00 

Posts posted by rendrag

  1. I didn't see a forum specifically for databases, so hopefully this is a suitable alternative.

    I'm trying to program through access 2007 a golf scoring database for my father (and myself by extension). It'll track the different courses we play at, and the number of strokes for each hole of each round. I know there are free versions of this online already, but half the fun of this stuff is building it myself.

    My issue I'm having is I'm unsure how to set up the relationships between each Hole of a given Round to the Course's particular hole. I've attached my relationship report as I have it now, hoping one of you guys could shed some light on what I can do to fix it.

    Ultimately i want the form to look like scorecard where each hole has the Course's Hole Number, Distance and Par, and beneath that I have the total strokes, whether the fairway was hit or green was reached in regulation, as well as the number of putts.

    Thanks!

    relationship_report.pdf

  2. they should not be lost unless for some reason you choose to format those drives. If you only re-install Vista on your C: drive, then the files on other drives should remain untouched.

    I'm not sure how the recovery DVDs are created as to whether or not they format the drive or just reinstall Vista on top of the existing installation. hopefully someone else can answer that. If a file is not backed up and the drive the file is stored on is formatted, then the file would be lost.

  3. it should put the appointmentt in your calendar, but it will not automatically accept the time. Before the appointment is accepted, it is marked as tentative in your calendar. I don't know that there's an option to not automatically place into your calendar

  4. Would you just let DHCP assign all the IPs on this network pretty much...........?

    Probably not... I'd use a mix of Static addresses and DHCP. For the workstations, DHCP is fine, and recommended. For the servers, printers, and various other devices, I'd do a static IP address.

    Also, would you be ok with cat5 cables or would you benefit much from cat5e/6/6e or fibre etc....?

    Where possible, I'd use cat6, especially if I'm building the site from scratch.

    Also what if your router died how would you have a back up router (or switch if that died) so that you never lost connectivity or can you do this?

    Sometimes you have to plan for that and have a backup plan in place. If 0 downtime is allowed, then you'll have to pay for that and keep a backup router and/or switch on hand in case of a failure.

  5. afaik, GPOs are only available from a domain controller where group policies are defined. That doesn't stop you from creating additional organizational units for each remote location and set up the additional group policies for pushing printer connection for each location.

    In my opinion, that's the easiest/best way to do it. You can still set up an XP box to host the printer connection, and just push the connection to that particular printer out to the particular OU where it applies.

  6. an IP that starts with 192 is fine. the entertainment PC that starts with 162 is bad. They should all start 192 in your residence.

    There are a few reasons that your entertainment PC (hence forth to be called ePC for purposes of typing) has a 162 address:

    1. cannot communicate with the router's DHCP server (DHCP is what assigns each device an IP address)

    2. can communicate with the DHCP server, but the DHCP server is out of available addresses to assign

    3. device has driver malfunction

    3. device has hardware malfunction

    Possible resolutions are listed below. Make sure you can log into the router's web interface (usually accessed via 192.168.x.1) Replace the 'x' with whatever your ip address has listed

    1. check signal strength on the ePC. make sure it's got a good signal

    2. in the router's interface, there should be a section where you can define the DHCP range (check the documentation). Make sure it has a pool of at least 5 addresses (the default is usually 50)

    3. update the drivers on the device. grab them from the manufacturer of the usb stick

    4. remove and re-insert the device. see if anything changes.

    while the above aren't exhaustive options, it should at least get you started.

  7. if your laptops have the auto-sensing network ports, then yes, you can test with 2 laptops.

    Have you tested drop 2 with any other kind of device besides the XBox? Or maybe try a different port on the hub. It should be really easy to tell if the cable is bad or not because if the drop goes into a hub, then that port light should be lit if the cable is good. If the cable is bad, you should not get any link light

  8. Ultimately you are limited by your ISP's internet connection speed. So even if you double your throughput to 200MBit by bridging 2 connections to the router (you're limited by the port speed on the router, not the switch), it wouldn't matter because your internet connection speed is going to be less than that.

    At the end of the day, I would not connect the managed switch to 2 LAN ports on the router. It serves no useful purpose.

  9. it would probably be easier and less costly to just run the cat5. I'd probably get STP (shielded twisted pair) cable, unless you'll be running in ducting, in which case i'd get plenum-rated cat5. The shielded will help prevent interference from lights and anything that generates electromagnetic interference.

  10.                                Internet
    |
    |
    Router
    |
    |
    Managed 1 Gbit Switch
    | |
    | |
    Unm. 1 Gbit Sw. Unm. 100 Mbit Sw.

    Or...

                                   Internet
    |
    |
    Router
    / | \
    / | \
    Man. 1 Gbit Sw. | Unm. 100 Mbit Sw.
    |
    Unm. 1 Gbit Sw.

    it's completely up to you. Think of the LAN port section on your router as another unmanaged switch (because it is, actually), so if you want to connect additional devices/switches directly to the ports on the back of your router, you certainly can.

    So let me sum it all up: The router is connected to the internet. Of the four 100 Mbit LAN ports on the router, we only use one port, number 1, which will be connected to port 1 on the managed 1 Gbit switch. On this switch on port 2 we need to connect the unmanaged 1 Gbit switch and on port 3 we need to connect the unmanaged 100 Mbit switch. We don't link these unmanaged switches together, as it would create a loop. On the managed 1 Gbit switch we connect all servers. On the unmanaged 1 Gbit switch we connect all workstations. Devices which only require 100 Mbit, such as printers, need to be connected to the unmanaged 100 Mbit switch. Is this all correct? Have I understood it all?

    You have it all understood. While you don't need to connect them exactly as you have noted, it's certainly a great way to keep things organized.

  11. if you have wireless, as long as the signal reaches (it should, but there are a lot of variables involved), you don't need to do anything. Just have wireless cards installed in PC's in the office. Alternatively, you can buy a wireless bridge, and connect all the office PC's to a switch, connect the bridge to the switch and the bridge will connect wirelessly to the home router

  12. you have a lot going on, and a lot of how you connect depends on the physical location of devices etc... If a device has a gigabit network card, then try to connect it to a gigabit switch. If the device only supports 100Mbit (printers usually only support 10/100), then you gain no additional benefit by connecting that device to a gigabit port.

    In a perfect world you would generally use managed switches at the backbone and unmanaged as you work farther out unless there is some other need that dictates otherwise. That would mean you connect the managed switch to your router, and all unmanaged switches would connect to the managed switch. I don't really know how your network is physically set up, so how you branch out from your managed switch backbone is completely up to you and is generally dictated by port need, however please heed the following:

    You want to avoid creating more than 1 path for information to follow as it moves from device to device.

    A

    /\

    B C

    A, B and C are all switches. Note how there is only 1 direction information can travel. If a device connected to B wants to communicate with a device connected to C, the data must travel through A. What you DO NOT want to do is to also link B and C together directly because you will have created a loop, and for the purposes of this discussion, loops are bad (loops do exist, in fact the internet would not work without loops, but they're generally bad in a closed network).

    Unless you have a specific need/desire to segregate traffic (keep all the cameras together, or all the ILO's together on there own virtual network), VLANs are unnecessary and may further complicate things unless you really understand how networks work and how to configure everything properly.

    If your servers have Gigabit network cards, definitely connect them to a gigabit switch (probably the managed one since you have 48 ports available).

    The workstations can connect to managed or unmanaged switches... whatever port availability allows. Same with the access points and printers.

    Hopefully this information proved useful. hit us back with further questions.

  13. solved it, though it's not very elegant.

    1. Through ODBC, pull out all my customers with fax numbers into excel.

    2. Edit the list in excel to format the fax number canonically (1+ fax number with area code), and save it as a CSV.

    3. Import those customers into outlook as contacts.

    4. Using the fax mail transport protocol, type my message and select all the contacts as recipients



×
×
  • Create New...