Opening Access 03 reports in vb 06

[jml1988]

i am doing a project for school, and this is a nessacery function for my project, anyone who can help me with this i would highly appricate it.

[padhuwork]

i am doing a project for school, and this is a nessacery function for my project, anyone who can help me with this i would highly appricate it.

Use ADODC control
Add this component to your project
Microsoft ADO Data Control 6.0 (OLEDB)
and set the ConnectionString properties.

Below is just an example, you can set all these using the wizard.

Provider=MSDASQL.1;Persist Security Info=False;Extended Properties="DBQ=C:\Documents and Settings\5144\My Documents\db1.mdb;DefaultDir=C:\Documents and Settings\5144\My Documents;Driver={Driver do Microsoft Access (*.mdb)};DriverId=25;FIL=MS Access;FILEDSN=C:\Program Files\Common Files\ODBC\Data Sources\test.dsn;MaxBufferSize=2048;MaxScanRows=8; PageTimeout=5;SafeTransactions=0;Threads=3;UID=adm in;UserCommitSync=Yes;";Initial Catalog=C:\Documents and Settings\5144\My Documents\db1


Regards,
Padhu

[jml1988]

Use ADODC control
Add this component to your project
Microsoft ADO Data Control 6.0 (OLEDB)
and set the ConnectionString properties.

Below is just an example, you can set all these using the wizard.

Provider=MSDASQL.1;Persist Security Info=False;Extended Properties="DBQ=C:\Documents and Settings\5144\My Documents\db1.mdb;DefaultDir=C:\Documents and Settings\5144\My Documents;Driver={Driver do Microsoft Access (*.mdb)};DriverId=25;FIL=MS Access;FILEDSN=C:\Program Files\Common Files\ODBC\Data Sources\test.dsn;MaxBufferSize=2048;MaxScanRows=8; PageTimeout=5;SafeTransactions=0;Threads=3;UID=adm in;UserCommitSync=Yes;";Initial Catalog=C:\Documents and Settings\5144\My Documents\db1


Regards,
Padhu

Thank you very much.
Just wondering is this component a seperate driver or do i just set it up withen vb?

Thanks.

Josh

[jml1988]

Thank you very much.
Just wondering is this component a seperate driver or do i just set it up withen vb?

Thanks.

Josh

dont worry i have found it and set it up.

[jml1988]

dont worry i have found it and set it up.

Just wondering how do you use this control to show the reports from a .mdb file.
I am struggling with this as it stands.

Thanks.

Josh