Reports in Client Server

[T Dow]

Im using an Access ADP w/MSDE SQL. User interface (forms
& reports) are stored on client app., the ADP. If new
reports are created they must be distributed to all of
the users and added to their ADP. Whats the best way to
allow users to use centralized repository of reports? For
example, if one of the reports is a sales order form, and
you want to ensure that everyone uses the same version
after you make some changes to its design.

Thanks!

TD

 

[SA]

TD, there's many ways to go about this, probably none of them as simple as
you'd like.

One way to do this is to use an INI file on the server, which you control,
that has the last the date of the last update, objects updated and the path
to your update db., Then have the autoexec macro call a function that reads
that file and if objects have been updated, delete the existing object and
import the new one and set last updated date in a table in the db.

Another method is to automate the distribution of the FE parts. Check out
Tony Toew's FE Updater:

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