How do I connect a VB6 application to MS Access 2007 database using ADO 6.0 (all code please, no data "widgets")

I'm still using the vb6 development environment but I want to step up the database and ado versions to the latest and greatest.  I'm currently using the following to connect to an access 2000 mdb:

Set conn = New Connection
conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & dbPOSPath & ";Jet OLEDB:Engine Type=4;Jet OLEDB:Database Password=test"

also I haven't found ado 6.0 for download yet, any ideas?
EdwardSpechtAsked:
Who is Participating?
 
carsRSTCommented:
"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & dbPOSPath & ";"

0
 
EdwardSpechtAuthor Commented:
OK, I'm sorry, That was way too easy and I should have come up with that on my own!  Thank you!
If I may, just 2 followup questions...

How would I compact the database using vb6 code?
What is the easiest way to copy a record from one 2007 db to another using code?
0
 
EdwardSpechtAuthor Commented:
also any chance you would know if I can still use the vb6 dataenvironment and datareport designers with an access 2007 db.  If so how would I set up the connection string?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.