Need an easy way to open another DB from Current o (A2k SR-1)

Topic

New Reply

I am quite clueless and would appreciate any advice.
I want to allow the user to open another database from the one I created so that they may create reports, forms, etc. I must frequently update/Revise the front end and so their reports can’t be stored there, or they would be lost anytime I sent them an update. Thanks in advance for any help, Michael

Reply | Quote

Replies

Here is a link to a site with a free Access97 or 2000 add-in that is supposed to do what you want: (http://www.trigeminal.com/index.asp?1033) without the parentheses. I have another possible solution for you: If you have a user who wants to create their own custom forms and reports, but they need to use the tables in an existing database, why not simply give them a front end, that only contains links to those tables? Then they can design their own queries, forms, and reports. If they must use some of your reports, they could use your front end when necessary (two shortcuts, one to your original front end, that you continue to modify as you see fit, and a second shortcut to their front end, that they control).

Reply | Quote

You could always insert a hyperlink that points to the other DB

Steve

Reply | Quote

Thanks to both of you!!! I have been working on this problem for a few months & now have the solution because guys like you took the time to help! Thanks again, Michael

Reply | Quote