
Microsoft.Jet.OLEDB.4.0 OLE DB provider
Dear All,
I am using Crystal Report 7 and MSAccess 2000 to develope my data report.
I am using OLEDB driver-Microsoft Jet to connect to the MSAccess database
and insert data to the database.
But when i using crystal report 7 to generate report, i should design it
with an ability to change the datasource at runtime. The problem is i don't
know how to type the code for changing the datasource. Here is two method
that i have tried, but it doesn't success.
Method 1
Report.Database.LogOnServer "Microsoft.JET.OLEDB.4.0", "c:\databse.mdb",
Table1
Method 2
Report.Database.SetDataSource ADOrs, 3, 1
Both methods are not success, is there any mistake that i made?
One more, it my report should include more than one table, what
programming code should i use?
Thanks so much for you all.