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

    HOW TO REFRESH ACCESS FRONT END

    HOW TO REFRESH ACCESS FRONT END

    New to Access, I don't have a versioning strategy. In my scenario, there is only one developer that wants to replace (after hours) the entire front end on each workstation each time the updated front end is put on the server. I want to rely on backend table update dates to decide if workstation front end needs to be updated.

    In the old days I could use a batch file with something like "if exist copy".

    I have three workstations attached to a computer network server.

    The Access 2000 project is divided into front-end back-end as follows:

    Build.mdb Application Query, Forms, Report, Macros, Modules
    Build_BE.mdb Application Data Files

    I have Build_BE.mdb on the server F:Build Drive.

    I have Build.mdb on each workstation C:Build Drive.

    I want to have the capability to phone/modem into the server after hours to refresh the Build.mdb on the F:Build Drive application with updates.

    I then need, on first time login, each workstation to refresh itself from the server with the new Build.mdb if the version on the workstation is older than the version on the server.

    What is the best way to accomplish this?

    Thanks for your help

    John Graves

    NBS7335

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

    Re: HOW TO REFRESH ACCESS FRONT END

    There was an article in Access-VB-SQL Advisor 11/2000, "Automatically Update Access Databases" written by Ken Wilkinson, that demonstrated a technique for doing this. His approach, which I have implemented myself, uses a table in the backend to hold the latest version information and a local table in the front end with the same kind of record. When the database is opened, it checks the two tables to see if they match. If not and if the backend information is later, it shells out to a second database which copies the updated master over the first database. It works quite well, but you do need to have all the machines using the same mapping.
    Charlotte

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

    Re: HOW TO REFRESH ACCESS FRONT END

    Hi Charlotte

    Thanks for all the access refreence info, still can't find orders9.mdb as described in Q248674, says site cannot be found/loaded.

    Just subscribed to Access-VB-SQL Advisor.

    Is there another site I can find and download orders9.mdb?

    John Graves

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

    Re: HOW TO REFRESH ACCESS FRONT END

    I would do a search on the MS site. Since 9 is now the "previous version" they'll have moved some stuff. However, I thought the Orders database was on the CD. Or was that Solutions?
    Charlotte

Posting Permissions

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