ADO and Access 2007

[RogueElement]

(1) I am able to use ADO feature to communicate with an Access 2003 database but receive an error (invalid format) when using a 2007 version of the same database - is Access 2007 supported and if not why and when might it be?

(2) When I return some results (using the 2003 db) into the ADO_RS macro, all I get is <object> rather than data - what might I be doing incorrectly?

Thanks,

[kinook]

Originally posted by RogueElement
(1) I am able to use ADO feature to communicate with an Access 2003 database but receive an error (invalid format) when using a 2007 version of the same database - is Access 2007 supported and if not why and when might it be?I was able to use the ADO action with an Access 2007 database and Access 2007. Using the Server.bld sample (Database -> ADO section), I upgraded the sample.mdb to Access 2007 format, and the steps worked afterwards. I would guess that something is misconfigured with Access and/or ADO if it's not working. Make sure Access 2007 is installed and that the ADO Access driver is using Access 2007.

(2) When I return some results (using the 2003 db) into the ADO_RS macro, all I get is <object> rather than data - what might I be doing incorrectly?The ADO_RS temporary macro is the ADO recordset object. See the Server.bld sample for iterating over the recordset after it has been populated.
http://www.kinook.com/VisBuildPro/Manual/ado.htm
http://www.kinook.com/VisBuildPro/Manual/serversample.htm

[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,

[kinook]

On second glance, it looks like Access 2007 created an .mdb and .accdb file when converting, and I was still using the .mdb file (pre-2007 format). For .accdb files, you need to use

Microsoft.ACE.OLEDB.12.0

in the Provider field.

http://www.google.com/search?q=access%202007%20oledb%20provider

[RogueElement]

Thank you - that works.