Database Update

[Todd C]

I have created a database (the Frontend) that is being used on many different
machines and by multiple users. My Backend is placed on the LAN so that all
machines can access it. I was told to put the database into service before
it was fully ready, so now I have to make updates to it to fix the bugs. The
problem is that unless I make one one frontend and have everyone copy that
database to there desktop, they will never get the updates. Is there a way
to make access automatically update all objects in the database when a user
opens the database? I may be doing this completely screwed up already, if
so, feel free to let me know. But I am getting the feeling that this isnt
going to be an easy thing to do.

 

[pddxxx]

Todd,

We have a utility specifically designed for this. It is called
Application Starter. A beta version (which I use successfully at a
number of sites) is available for download here: http://www.peterssoftware.com/aps.htm
.. It is free.

When making Front-End changes, make the changes and test them on a
local computer, then replace the .mdb (or .accde) file in the "master"
location as specified on the Application Starter properties form. When
users close and re-open their application, Application Starter will
notice the new version in the master location, download it to the
user's computer, then start it.

Hope this helps,

Peter De Baets
http://www.peterssoftware.com

 

[Todd C]

So does that mean that there is no way for the users to just log in and it
automatically copies everything to there db, or at least automatically
upgrades their version of it? I am really trying to make it where they dont
have to do anything but log on.

 

[John W. Vinson]

I have created a database (the Frontend) that is being used on many different
machines and by multiple users. My Backend is placed on the LAN so that all
machines can access it. I was told to put the database into service before
it was fully ready, so now I have to make updates to it to fix the bugs. The
problem is that unless I make one one frontend and have everyone copy that
database to there desktop, they will never get the updates. Is there a way
to make access automatically update all objects in the database when a user
opens the database? I may be doing this completely screwed up already, if
so, feel free to let me know. But I am getting the feeling that this isnt
going to be an easy thing to do.

Tony Toews (among other people) has a good solution to this problem:

http://www.granite.ab.ca/access/ufad.htm

 

[Fred Boer]

Dear Todd:

Check out Tony's Auto FE Updater!

http://www.granite.ab.ca/access/autofe.htm

HTH

 

[pddxxx]

The end user double-clicks an icon on their desktop and Application
Starter determines whether or not to download a new copy of the
"master" FE .mdb file based on the file modified date. Application
Starter then starts the application from the local copy.

FYI, Tony's FE updater will do this also, as others have noted:
http://www.granite.ab.ca/access/autofe.htm

Peter De Baets
http://www.peterssoftware.com