Reference on multiple databases

[OlafOdersky]

I have three databases (mdb):

Main.mdb -> references ReportTool.mdb
ReportTool.mdb
Auto.mdb -> references Main.mdb & ReportTool.mdb

There are some automatic procedures in the Main.mdb which causes the database to grow extremly. Because the Main.mdb cannot be compressed while running I created a new database Auto.mdb that should start the automatic procedures in the Main.mdb and compress the Main.mdb after the size of the Main.mdb exceeded a specific value. The Main.mdb uses some functions in the ReportTool.mdb, so I need a reference from the Main.mdb to the ReportTool.mdb.

Now the problem in the Auto.mdb is the following:
The code cannot be compiled because the reference from the Main.mdb to the ReportTool.mdb cannot found in the Auto.mdb.
The compiler stops at a function in the Main.mdb ( Main.StartReport() ) that calls a routine in the ReportTools.mdb ( ReportTool.OpenAutoReport() )

How can this be done - any suggestions?

Thanks in advance
Olaf

 

[thornmastr]

I think you need to reference your other db’s from the auto db. This is very easy to do. Get to your reference menu. Click on browse. Then click file type of mdb. Find the two mdb’s you wish to reference from auto, and click them.

At that point auto will be able to reference the functions in the other mdb’s.
Robert Berman
Data Base consultant
Vulcan Software Services
thornmastr@yahoo.com

 

[OlafOdersky]

Hi Robert,

thanks for your help, but as I said I already referenced the Main.mdb & ReportTool.mdb from the Auto.mdb.

 

[thornmastr]

Olaf,

Sorry, I have only had to reference to only one other mdb and after diagramming your problem, I don’t think I want to try this using two or three deep. But, having said that, and with the clear understanding I do not have a quick and ready way to test this hypothesis; is it possible to reference both reporttool and auto to main.

Reference main and auto to report tool.

Reference main and reporttool to auto.

If that is an invalid combination, is it possible to link all common tables within all three databases and not change your reference structure from what you now have.
Robert Berman
Data Base consultant
Vulcan Software Services
thornmastr@yahoo.com

 

[OlafOdersky]

Robert,

there seems to be no solution for this problem by using references. I searched other forums and did not find any hints.

Now I did it as you described: I created a database that is used for all local tables, linked them to the other databases, changed some of my code and everthing seems to be fine.

Thanks
Olaf