O
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
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