Re: Which ADO provider to use to connect to MS Access DB under Vista x64 ?


"William Vaughn" <billvaNoSPAM@xxxxxxxxx> wrote in message
news:AE5FD1A5-CD33-4376-8327-676763E53058@xxxxxxxxxxxxxxxx
Bob, I just converted one of my NWind.mdb databases using Access 2007 and
it
created an entirely new database file with a new extension. Now the JET
4.0
OLE DB provider won't open it. What are customers supposed to do now? Fall
back 10 yards and punt?

--

<snipped>

You can not use the new 2007 format with earlier tools.
http://office.microsoft.com/en-us/access/HA100678311033.aspx

Thus - don't convert.

MSAccess 2007 can use Jet 4 formatted databases with a few exceptions.

AFAIK an alternative replacement for the old ADO/DAO data access libraries
for the new format is still in development.

-ralph




.

Relevant Pages

  • Re: QUESTION ABOUT SpyBlocs
    ... >if I have to do a format ... Ray, Seriously. ... I'd just drop back 15 yards and punt and re-do that baby ... Prev by Date: ...
    (misc.news.internet.discuss)
  • Re: How do I Upload XML data to an ACESS D/B
    ... Access 2000, 2002 and 2003 can use the same file format, so if the XML ... >I have a need to upload data that is downloaded by an existing system into ... > Can this be done in MSACCESS 2000 or must I get MSACCESS 2003 and if I ...
    (microsoft.public.access.externaldata)
  • Re: Date Time Format in Access Big Problem
    ... inconsistent date format in access. ... How can we actually define the date format in database. ... The format settings inside MSAccess only provide instructions for MSAccess ... Date-String converters, CSV handlers, ...) ...
    (microsoft.public.vb.database.ado)
  • RE: Text format for a table field
    ... what you suggest me since I started using MSAccess few weeks ago: ... >I would like to automatically force the following format ... >* all other characters lowercase ...
    (microsoft.public.access.forms)
  • Re: Timestamps
    ... field in msaccess? ... Using format, the value is a string. ... Cdate converts it back to a date field. ...
    (comp.databases.ms-access)