MS-Access Error - Obsolet Database Format !

[Makl. Lemmertz]

Hi,

Can anyone help me with this error ?
It's ocurring in an old VB3 app. All was ok but now I have this error...

Thanks in advance

Mark

[Paul Clement]

On 25 Oct 2001 04:51:57 -0700, "Makl. Lemmertz" <gmoulin@uol.com.br> wrote:

¤
¤ Hi,
¤
¤ Can anyone help me with this error ?
¤ It's ocurring in an old VB3 app. All was ok but now I have this error...
¤

I believe this is a DLL problem but the MS KB article (Q115900) that covers it is long gone. I'll
see if I can find an old MSDN Library that has it.


Paul ~~~ pclement@ameritech.net
Microsoft MVP (Visual Basic)

[Paul Clement]

On Thu, 25 Oct 2001 09:31:32 -0500, Paul Clement <UseAdddressAtEndofMessage@swspectrum.com> wrote:

¤ On 25 Oct 2001 04:51:57 -0700, "Makl. Lemmertz" <gmoulin@uol.com.br> wrote:
¤
¤ ¤
¤ ¤ Hi,
¤ ¤
¤ ¤ Can anyone help me with this error ?
¤ ¤ It's ocurring in an old VB3 app. All was ok but now I have this error...
¤ ¤
¤
¤ I believe this is a DLL problem but the MS KB article (Q115900) that covers it is long gone. I'll
¤ see if I can find an old MSDN Library that has it.

OK, couple possibilities based on the articles.

Either the database was converted to a different version of Access, or the 16-bit database driver
layer has changed or is not present.

Here are a couple obsolete MS KB articles:

PSS ID Number: Q115900
Article last modified on 03-13-1995

1.00 1.10 2.00

WINDOWS


---------------------------------------------------------------------
The information in this article applies to:

- Microsoft Access versions 1.0, 1.1, and 2.0
---------------------------------------------------------------------

SYMPTOMS
========

When you run a query against a Microsoft Access database from Microsoft
Word for Windows, Microsoft Excel, or Microsoft Query, you receive the
error message "Obsolete Database Format."

CAUSE
=====

You have not selected the correct database type.

RESOLUTION
==========

If you are trying to query against a Microsoft Access 1.x database, change
the database type from Access 2.0 Database to Access Database.

If you are trying to query against a Microsoft Access 2.0 database, change
the database type from Access Database to Access 2.0 Database.

Additional reference words: 1.00 1.10 2.00
KBCategory: kbinterop kberrmsg
KBSubcategory: IntpOthr

=============================================================================


PSS ID Number: Q115469
Article last modified on 02-09-1995

1.00

WINDOWS


----------------------------------------------------------------------
The information in this article applies to:

- Microsoft Query for Windows, versions 1.0
- Microsoft Excel for Windows, versions 5.0
----------------------------------------------------------------------

SYMPTOMS
========

When you use Microsoft Query to query a Microsoft Access version 2.0
table, you receive the following error messages:

Obsolete Database Format

-and-

Couldn't add data source

CAUSE
=====

This problem occurs when you try to query a Microsoft Access version
2.0 table using the ODBC driver for Microsoft Access version 1.0 and
1.1 tables.

MORE INFORMATION
================

The driver that shipped with the Microsoft ODBC Drivers version 1.0
Fulfillment Kit supports Microsoft Access version 1.0 and 1.1 tables.
The filename and version for this driver are:

Driver: Access Data
Filename: SIMBA.DLL
Version: 1.01.2115

The following driver is required to query Microsoft Access version
2.0 database files:

Driver: Access 2.0 for MS Office
Filename: ODBCJT16.DLL
Version: 1.00.1521

To check for the correct filename and version, do the following:

1. In Program Manager, double-click the Control Panel icon in the Main
Group.

2. Double-click the ODBC icon.

3. Select the Drivers button.

4. Select the driver you want information about.

5. Choose the About button.

If the Access 2.0 for Microsoft Office ODBC driver is not installed on your
machine, run the Microsoft Access 2.0 custom Setup and install the ODBC
support.

KBCategory: kbinterop
KBSubcategory: xlquery

Additional reference words: 1.00 5.00 msquery err msg

=============================================================================

Copyright Microsoft Corporation 1995.




Paul ~~~ pclement@ameritech.net
Microsoft MVP (Visual Basic)