MS Access as a control table

Meeting place for R&R customers and clients to share tips and ideas. Post your questions, messages or problems here.
Post Reply
Gordy
Posts: 11
Joined: Tue Oct 10, 2017 12:44 pm

MS Access as a control table

Post by Gordy » Fri May 18, 2001 1:13 pm

Can Microsoft Access 2000 (winter.mdb) be used as a "Control Table" when passing parameters to the Report Viewer?____I am running R&R SQL v8.1____Access database = winter.mdb__table name in winter.mdb = rrparms____The following command line dosen^t work. Any ideas?____RSWRUN /TSwinter.mdb 1____Thanks____Gordy__:-)

kfleming
Posts: 5795
Joined: Tue Oct 10, 2017 12:44 pm

=> RE: MS Access as a control table

Post by kfleming » Fri May 18, 2001 3:06 pm

You need to set up an Access datasource that points to the winter.mdb. You could call it Winter____You then use the command line:____RSWRUN /CSWinter /TSrrparams 1____To tell R&R to use the control talbe rrparams that is available in the datasource named Winter.____Kathleen__R&R Support

Post Reply