ADO and Access 2007

[RogueElement]

Thank you for the quick reply - I found the information related to question (2) - that works.

In regards to question (1) - I did the same thing - upgrade the sample.mdb to sample.accdb - received the following:

"Opening connection to 'C:\DOCUME~1\jbelloch\LOCALS~1\Temp\VisBuildPro\sa mple.accdb' with Microsoft.Jet.OLEDB.4.0 provider...
Unrecognized database format 'C:\DOCUME~1\jbelloch\LOCALS~1\Temp\VisBuildPro\sa mple.accdb'."

How would I confirm that my ADO/Access driver is the correct one (if that is the cause of by issue) since Access 2007 is installed? My Access installation was installed normally, is there something I need to configure?

Thanks again,