Results 1 to 5 of 5
  1. #1
    New Lounger
    Join Date
    Jan 2003
    Location
    Ocean, New Jersey, USA
    Posts
    19
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Networking and Databases (XP)

    Suppose you have 7 or 8 laptops that have wireless access to a server on which an Access application resides. The 7 or 8 users utilize the application while in the office, but would also like to use the application at home.
    If you split the Access application into front-end and back-end components and place the front-end on each of the laptops:
    1) is there a way for the users to run the application when not in the office?
    2) do you need to create a database (back-end) in each laptop?
    3) how do you then "update" the back-end on the server when the user returns to the office?
    4) although not too likely (due to the nature of the data), if more that one user changes the same record, how do you resolve conflicts and synchronize the various elements?
    5) does the situation change if you keep the tables, forms, etc. together (i.e., don't split the application)?
    Thanks.

  2. #2
    Super Moderator
    Join Date
    Dec 2000
    Location
    Renton, Washington, USA
    Posts
    12,560
    Thanks
    0
    Thanked 4 Times in 4 Posts

    Re: Networking and Databases (XP)

    Before we go any further, we need to know your total Access, Windows and Networking back ground. If you have less that ten (10) years experience is any of these, I would say go hire a consultant that understands exactly what you want. This is NOT a simple task. Sorry.

    Now running HP Pavilion a6528p, with Win7 64 Bit OS.

  3. #3
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Networking and Databases (XP)

    Unless you laptops can somehow connect to the server when they are "on the road", what you are talking about involves Replication. This is NOT an easy topic! There are many of us who have been using Access for years who have managed to avoid using Replication. You will definitely need the help of someone with experience in this area.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  4. #4
    New Lounger
    Join Date
    Jan 2003
    Location
    Ocean, New Jersey, USA
    Posts
    19
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Networking and Databases (XP)

    While I have a computer science background, it is not specifically Windows or networking (I'm an old telecommunications person: switching, protocols, ISDN, etc.) Is it worth investigating Access' replication/synchronization capabilities, or do these require extensive crafting to become compatible with the specific network environment?

  5. #5
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Networking and Databases (XP)

    There isn't really anything special from a networking point of view in order to make replication work. And it is designed to deal with the problem of users who are "loosely connected" to a network. You might find our tutorial on replication a reasonable starting point, and it contains links to lots more detailed info, but there are a number of pitfalls and traps you need to be concerned about. In many cases a database will need some redesign in order to work under replication. If you have further questions or concerns, feel free to post back.
    Wendell

Posting Permissions

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