Microsoft.Jet.OLEDB.4.0 OLE DB provider 
Author Message
 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",

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.

Mon, 17 Mar 2003 11:27:47 GMT  
 [ 1 post ] 

 Relevant Pages 

1. Microsoft Jet 3.51 Ole Db Provider, where is?

2. Microsoft.Jet.OLEDB.3.51 provider not registered

3. Microsoft Jet OLEDB Provider 3.51: Does it support parameterized querys

4. Create Jet 3.5x DB with OLE DB Provider 4.0

5. Updating child recordsets using the Microsoft.Jet.OLEDB.3.51 provider

6. Provider=Microsoft.Jet.OLEDB.4.0 vs 3.51

7. Microsoft.Jet.OLEDB.4.0 Provider not working with Access 97 MDB

8. Command.Execute with parameter works with ODBC provider, fails with Microsoft.Jet.OLEDB.4.0

9. How can I add Microsoft Jet OLEDB 4.0 Provider with my PDW Setup Files

10. Microsoft Project 2002 Database VS. Microsoft Project 2002 OLE DB Provider

11. Jet OLEDB:Link Provider String to secured db

12. Replace OLEDB provider Jet 3.51 with Jet 4.0


Powered by phpBB® Forum Software