Reports from an unbound database

[OD]

Hi

sorry if this is the wrong group for this. I have a split database and
trying to run a report from the front end. I can get the sql query to build
correctly but when I try to run the report it says it can't find the main
database. This is because the command CurrentProject.Connection gives the
path to the front end files and not the backend databases. How can I get the
report to see the backend database. I've tried a number of things to no luck.
Any help is greatly appreciated.
Thank you

 

[OD]

Hi

Yes, that is what I'm doing. I have all the tables in one file and the
programming in another. These are MDB files as I have to work with clients on
an older version.
I was wondering about linking. It does seem the easiest solution!

 

[OD]

Thank you!

Hi

Yes, that is what I'm doing. I have all the tables in one file and the
programming in another. These are MDB files as I have to work with clients on
an older version.
I was wondering about linking. It does seem the easiest solution!

Hi

[quoted text clipped - 11 lines]

everything but your tables in the front end and only data tables in the back
end. Is this what you are doing?

In that case, put only the tables in the backend (and maybe any code that has
to run there), and put all the other objects in the front end. Then you can
just relink and move to a new DB. Infinitely easier.