User Created Objects In Local Front-End

[debot54]

I have been working with the FE/BE concept in Access for years and never has any problems with this approach. That is until now. The problem has to do with user's creating objects in their local copy of the FE - primarily queries. The problem comes up when I have a new version to roll-out. In the past I have simply replaced their existing copy of the FE with the new version (using an automated tool). Everything has worked wonderfully - until now.

Now I have users who create their own queries which of course are stored in their local copy of the FE - the copy that I will wipe out when I replace with the new version of the FE. The question is, how do I save these user defined objects when I copy the new file to their machine. I am sure there must be a solution out there but I can't find it. Hopefully the solution will be easier to implement that it is to find. Thanks in advance for your help.

 

[Remou]

How about a table on the back end with fields to hold the user name, the query name and the query SQL, which can be used to rebuild the queries every time a new front end is created?

 

[dhookom]

The is a fairly flexible query by form applet at

http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.

This system stores "query/report" information in two tables that you leave in the b-e database. There are a few forms required. Users can select fields, sorting, grouping, criteria,... They are about 2 clicks from sending the results to Print, HTML, Excel, CSV, Word, Merge, Graph,...

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]