Organizing coded reports and end user reports.

[Kjell Nilsen]

Hi,

I have an Access report application ( Access 2000 ) with som coded reports
running on top of several linked tables against SQL Server.

Now the end users shall use this ( or another) Access database also as a
tool to produce some reports themselves. How can this be done so that
later on it is easy to merge their reports with a new version of the coded
reports? And even if the end user reports are kept in a separate
application, this application must still contain code ( to link the basic
tables against SQLServer etc.) that will need some updates.

I have looked in my books and tried seaching the net, but not been able to
find any help on this one. Surely this must be a scenario handled many times
before - so hopefully some of you can give me an advise?

Tia, Kjell.

 

[Joe Fallon]

Keep a Master copy and just periodically import their reports from their
copy.
The re-distribute the Master as the newest version.

See Tony Toews' website for a free tool to do this.
(AutoFE Updater)