General discussion

Locked

VB6 /Access 2000 - unrecognized format

By jmcgaughan ·
I have developed several applications using VB 6.0 which read and write data into Access 97 database tables. These have been working with no problems. Now we want to upgrade Access 97 to Access 2000, but upon experimenting I discovered I get an error stating unrecognized format when I run the applications using these converted databases. Any ideas how I can get my applications to work if we upgrade all the databases to Access 2000. Presently these applications are used on computers running Windows 95, 98, ME, NT, and 2000; all applications were written using VB 6.0 Professional version; and all databases were developed using Access 97. My company wants to upgrade all the computers to use the Office 2000 suite but can't until I resolvethis problem. Any help would be greatly appreciated.

This conversation is currently closed to new comments.

7 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

VB6 /Access 2000 - unrecognized format

by Bob Sellman In reply to VB6 /Access 2000 - unreco ...

It sounds like you haven't changed the ODBC driver to re-link your tables through the Access 2000 Jet driver, which is different than the Jet engine for Access 97.

Collapse -

VB6 /Access 2000 - unrecognized format

by jmcgaughan In reply to VB6 /Access 2000 - unreco ...

Poster rated this answer

Collapse -

VB6 /Access 2000 - unrecognized format

by sl-campbell In reply to VB6 /Access 2000 - unreco ...

Make sure that you have the most recent service packs for VB6 (4 or 5) and, in this case, the MDAC_Typ32.

Databases created with Jet 3.5 use a different format than 4.0.

Also, go to this site:
http://support.microsoft.com/search/preview.aspx?scid=/search/viewDoc.aspx?docID=KC.Q238401%26dialogID=10813936%26iterationID=1%26sessionID=anonymous|9880835%26url=kb;en-us;Q238401

(REMOVE ANY SPACES in the Url or the page will not be found)

Collapse -

VB6 /Access 2000 - unrecognized format

by jmcgaughan In reply to VB6 /Access 2000 - unreco ...

The Q article mentioned told me about SP4 & SP5 for VB6.0. Once I ran those everything started working. Thanks.

Collapse -

VB6 /Access 2000 - unrecognized format

by fmufti In reply to VB6 /Access 2000 - unreco ...

Read this
http://www.buygold.net/v02n12/v02n12.html
and download from here
http://www.microsoft.com/data/download_25SP2.htm
also see this
http://www.microsoft.com/data/download.htm for the lates. Install MDAC 2.5 atleast, it will be ok

Collapse -

VB6 /Access 2000 - unrecognized format

by jmcgaughan In reply to VB6 /Access 2000 - unreco ...

Poster rated this answer

Collapse -

VB6 /Access 2000 - unrecognized format

by jmcgaughan In reply to VB6 /Access 2000 - unreco ...

This question was closed by the author

Back to Web Development Forum
7 total posts (Page 1 of 1)  

Related Discussions

Related Forums