MS-Access Command Line Parameters

[JimP]

I'm currently using MS-Access as a standalone app to run reports based on a
SQL Server db.

I'd like launch MS-Access from within a SQL Server db interface (e.g.
PowerBuilder), passing values to select a particular report as well as
parameters for the report.

MS-Access accepts a command line parameter to run a macro as well as a
command line string. I can see how these could be used to select a
particular report to run as well as parameters for that report.

Is this the preferred route to go, or are there other/better options for
accomplishing this?

Thanks,
Jim

 

[Alex Dybenko]

Hi,
you can also start access as automation server with CreateObject() (or
whatever function supported in your environment), then open database, run
reports, etc

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

 

[JimP]

Thanks,

I'll look into this. Will this allow allow me to,

1. specify parameters for the report (e.g. cust ID or date ranges)?
2. work in a runtime environment?

Jim

 

[Chris O''Neill]

It should, but that depends on the capabilities and functionality of the
environment you're working in. Check the docs for that environment to be
sure.

Regards, Chris