Executing Access Reports through VB 6 Code

[M. R.]

Hi everybody,

i'd like to know how i can open a report in MS Access through VB 6.0 Code
(not VBA or MS 9.0 Object Library);
I'd like at first a preview of the report.
There is a password for the MS Access Database which i have to enter before
opening the database, how can i include the password in the code ?

The connection string is "Provider for Access = MSDASQL 1.0; filename-dsn"
but over this connection.
I have entered the password in the System-DSN Name. The connection works
fine but
just for queries not for executing reports through VB 6.0 !


Thanks in advance

Matthias

 

[Brian]

Hi everybody,

i'd like to know how i can open a report in MS Access through VB 6.0 Code
(not VBA or MS 9.0 Object Library);
I'd like at first a preview of the report.
There is a password for the MS Access Database which i have to enter before
opening the database, how can i include the password in the code ?

The connection string is "Provider for Access = MSDASQL 1.0; filename-dsn"
but over this connection.
I have entered the password in the System-DSN Name. The connection works
fine but
just for queries not for executing reports through VB 6.0 !


Thanks in advance

Matthias

The only program that can open Access reports is Access, therefore the only
way to do what you want is to use Automation.

 

[Douglas J. Steele]

The only program that can open Access reports is Access, therefore the only
way to do what you want is to use Automation.

To add to Brian's advice, check out:

http://support.microsoft.com/?id=210132
http://support.microsoft.com/?id=210111


You'll have to have Access installed on each workstation to use this (the
runtime version will be adequate)