Access 2007 databases

L

Larry Kuderick

Is there a ODBC driver that I can install that will allow Access 2003 to
understand Access 2007 (*.accdb) data files? If so, can someone point me to
it? I checked around the Access 2003 site and didn't see anything obvious.
 
6

'69 Camaro

Hi, Larry.
Is there a ODBC driver that I can install that will allow Access 2003 to
understand Access 2007 (*.accdb) data files?
Click to expand...

I haven't tried it yet, but if history is any guide, you won't be able to
link to the ACCDB tables from Access 2003 with an ODBC driver. However, you
should be able to use VBA code to create a Recordset object that utilizes
the Office 2007 Data Connectivity Components, which can be downloaded from
the following Web page:

http://www.microsoft.com/downloads/...36-8C28-4598-9B72-EF94E038C891&displaylang=en

The data provider will be Microsoft.ACE.OLEDB.12.0 for your VBA code.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.
 
L

Larry Kuderick

Thanks for the comeback. I've done some further checking and you are
correct, Access 2003 will not be able to read Access 2007 file formats.

However, I have another problem. I'm using Borland's Delphi 2006 and I can
connect to a database created by Access 2007 without problems.

However if I use Sharepoint Services to create a linked list Database in
Access 2007 the ODBC driver doesn't reconize the file even though the
extension is also a .accdb file. Access 2007 opens the file fine and from
all appearances it's the same as a new table that Access creates but the
fact that it apparently has links back into sharepoint makes the ODBC driver
fail.

Any thoughts?
 
Top