Executing Access Reports through VB 6 Code

  • Thread starter Thread starter M. R.
  • Start date Start date
M

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
 
M. R. said:
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
Click to expand...

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