launch New Database queries and reports

[Guest]

I have an existing database that I made a copy of. Within the copy I have
updated some of the queries and reports. What is the best way to launch 10
changed queries and 6 changed reports. The users have changed the table data
in the meantime.

If I delete the changed queries and reports. I can import the new ones.

I originally thought that I could change the names of the tables in my
version and then import the up-to-date ones from users. Problem is that once
I change my version of the table all my queries automatically changed to the
new names.

I hope this was not to confusing, but I am not the first one in this
situation.

Thanks

 

[Tony Toews]

I have an existing database that I made a copy of. Within the copy I have
updated some of the queries and reports. What is the best way to launch 10
changed queries and 6 changed reports. The users have changed the table data
in the meantime.

You want to split the MDB into a front end containing the queries,
forms, reports, macros and modules with just the tables and
relationships. The FE is copied to each network users computer. The
FE MDB is linked to the tables in the back end MDB which resides on a
server. You make updates to the FE MDB and distribute them to the
users, likely as an MDE.

See the "Splitting your app into a front end and back end Tips" page
at http://www.granite.ab.ca/access/splitapp/ for more info. See the
Auto FE Updater downloads page
http://www.granite.ab.ca/access/autofe.htm to make this relatively
painless.. The utility also supports Terminal Server/Citrix quite
nicely.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm