I have created several databases for use in my department. I was wondering if there is any way to link all the databases together without recreating the wheel. The only thought I could come up with was to create one more database, but this database would link to all other databases. In other words,I would like the associates to be able to open one database and access all other databases from there. Do you have any suggestions as to how to make this happen?
I can find where to link tables in different databases, but not where to link forms or queries. A lot of work as been put into these forms, and I don't want to start from scratch.
Any advice you can provide would be greatly appreciated.
I can find where to link tables in different databases, but not where to link forms or queries. A lot of work as been put into these forms, and I don't want to start from scratch.
Any advice you can provide would be greatly appreciated.