subform linked to different database

[scorpiofire2]

I have one database that has many tables (in a separate backend), queries, forms and reports. All operations stem from a multitab switchboard. I would like to split the operations so that the report generation option is actually located in a separate database. In otherwords when the user hits the report tab on the switchboard it will appear the same a it has in the past but in reality it will be a subform that is located in a separate database and all info returned will be generated from that separate database. Can this be done or is it just another of my "personal computer fantasies?"


Programmer wannabe, No one can go back and make a new beginning, but it's never too late to make a new ending.

 

[Rolliee]

Link the tables or queries in the foreign database to current and then treat like it belonged.


Rollie E

 

[scorpiofire2]

Sorry Rollie,
You'll need to be a little more specific in your response. I've already created the extra database and placed the linked tables in it. Where I am lost is on how to integrate the front end form into an existing form. How can I connect a subform as if it were a bound object from a separate application?

Programmer wannabe, No one can go back and make a new beginning, but it's never too late to make a new ending.

 

[Rolliee]

If you do a File/Import you can point to another database and import anything in that database - include tables and queries.

If they are tables, you can choose LINK. This makes your database 'think' that the table is it's own and it can now be used to link a subform to a mainform. Is that any clearer?

Hang in there and keep asking till you get your answer. We all started out as HL Menkin said, "I was not always as smart as I presently am!!!"

Rollie E

 

[scorpiofire2]

I see what you are saying now. I was concentrating on the front end problem when the front end does not need to be altered. Just change where the front end is pulling from. Couldn't see the forest! Thanks

Programmer wannabe, No one can go back and make a new beginning, but it's never too late to make a new ending.