Results 1 to 5 of 5
  1. #1
    4 Star Lounger
    Join Date
    Apr 2001
    Location
    Guatemala City
    Posts
    515
    Thanks
    0
    Thanked 0 Times in 0 Posts

    PtoP network and Access DB (Win XP Access 2003)

    I don

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: PtoP network and Access DB (Win XP Access 2003)

    The biggest problem you have with a peer-to-peer network and Access is that the other machines will not map the drive letters the same way. Aside from that, you will need to provide more information on the number of machines in the network, whether the database is split into FE and BE or not and the kind of usage involved.
    Charlotte

  3. #3
    4 Star Lounger
    Join Date
    Apr 2001
    Location
    Guatemala City
    Posts
    515
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: PtoP network and Access DB (Win XP Access 2003)

    This will be a small network, 3 or 4 users. One of the added users will take payments, consulting the DB. Another user will consult A/R balances and inventory. The DB is divided into FE and BE.

    I am good at taking a book and learning about this stuff. Do you have any recommendations?

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: PtoP network and Access DB (Win XP Access 2003)

    I've never encountered a book that covered peer-to-peer networking of an Access database. Perhaps someone else has.
    Charlotte

  5. #5
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: PtoP network and Access DB (Win XP Access 2003)

    In the scenario your suggesting one of the computers will have to be the server for the BE in the PtoP network.

    This computer will be the server for the BE that all the workstations including the server/workstation will access the BE data.

    You should choose the most reliable and least used computer in the PtoP to be the server for the BE.

    All workstations including the server will have C:ApplFEFE.mdb (front end program)

    The server computer will have C:ApplBEBE.mdb (backend data)

    This same serevr drive C:ApplBEBE.mdb can be mapped as F:ApplBEBE.mdb for this workstation/server and other workstation computers in the PtoP network.

    All workstations including server C:ApplFEFE.mdb will be linked the F:ApplBEBE.mdb

    This will work, however you can see the disadvantages:

    1. Workstation response can be slow based in server activity

    2. If the operator on the server/workstation hangs up the system, all workstation will have to log out of the application so server can reboot.


    HTH, John

    PS: Your system administrator or Woodys Windows XP forum can explain how to do the networking/mapping

Posting Permissions

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