HOW TO REFRESH ACCESS FRONT END

Topic

New Reply

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

Reply | Quote

Replies

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.

Reply | Quote

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

Reply | Quote

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?

Reply | Quote