Re: ADO and Jet creates error on XP Home Edition SP2

Dear Uwa,
Thanks for replying. Indeed the error comes from the vb code when we try to
call Jet to compact access 97 files.

We couldn't recreate the error on our machines, so we put a function that
writes message to a text file for each step of the program. We asked the user
to run the program and send us the text file and we see what message was
reached before the error message.

I also went to the customer today and ran the software myself to see the
error messages occuring.

The problem occurs in a function that calls the Jet's CompactDatabase
function :

Set JRO = New JRO.JetEngine
strParameter = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" +
strDataBase
strParameter2 = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" +
mvarSourceApplicationDirectory + "\temp.mdb;Jet OLEDB:Engine Type=4"
Call JRO.CompactDatabase(strParameter, strParameter2)

This is where we get the error 13 message. (Note: we have to run the compact
function on our databases because otherwise we get error message concerning
the collating order when we run the software on a different operating system
then we use for development, e.g. German Windows).

We put a parameter to bypass this function, the next step is to connect to a
database file with ADO :

Set conBPDefs = New Connection
conBPDefs.CursorLocation = adUseClient
conBPDefs.Open "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source=" +
App.Path + "\SYS\BPDefs.mdb;"

There the user gets the error -2147467259 with a message 'can't open a
database that was created with a previous version of the application'
(translation from Hebrew).

I hope this information will help to find the problem.

Best Regards

A general note: We already have about 8000 users and we managed to find
solutions to all problems (e.g. setup, printing, dlls, etc..) but when it
comes to ADO we feel we don't know what to do (except asking the user to
reinstall MDAC and JET). We would like atleast a tool that will enable to
manage and uninstall ADO components. Compchecker is not helping at all.



"Uwa Agbonile [MSFT]" wrote:

> XP Home Edition SP2 ships with MDAC 28 SP1 so that would explain why the
> MDAC 28 RTM won't install.
>
> If I recall correctly, error code 13 is a VB6 error code so is not
> originating from ADO. You might want to take a second look at the cause of
> the error because it might not be related the MDAC on the machine.
>
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
> Regards,
> Uwa Agbonile[MSFT]
>
> "Garry Grolman" <GarryGrolman@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:FBAD5914-CF93-4519-BB6D-71849DA6B1C5@xxxxxxxxxxxxxxxx
> > We develop with VB6, and use ADO and Jet4 to store and read data from
> > MS-Access 97 files.
> > In some installations users report that when starting the application,
> they
> > get an error message : 'error 13-type mismatch'. We checked and it happens
> > when we try to compact the database files.
> > In most cases the problem is solved when we instruct the user to update
> MDAC
> > and Jet 4 to the latest versions from Microsoft site.
> > In several cases, mostly in XP Home Edition SP2, update to MDAC2.8 won't
> run
> > (a message says that MDAC2.8 RTM isn't compatible with this version of
> > Windows...) and update to Jet 4 SP8 will also not run (message says that
> the
> > installed service pack is newer...).
> > How can we solve this problem ?
> > are there any tools to manage ADO (compChecker doesn't help) ?
>
>
>
.

Relevant Pages

  • Re: Distributing MDAC with VB Application
    ... using both DAO and ADO in your project is to be SURE to qualify object names ... > Is there something else I need to include if using MDAC 2.5 or higher? ... include the Jet components ADO requires. ... you might have to distribute the Jet Components installer. ...
    (microsoft.public.vb.winapi)
  • Re: ADO and Jet creates error on XP Home Edition SP2
    ... For the JET error you mentioned, please take a look at the KB article at ... it appears to me the issues you are having is not really with ADO ... > database file with ADO: ... >> MDAC 28 RTM won't install. ...
    (microsoft.public.data.ado)
  • Re: DAO360.DLL - can I redistribute it?
    ... Older versions of MDAC include Jet 4.0...the newer ones do not. ... PC...whether or not you use ADO. ... schema used is common among the various database you might connect to. ...
    (microsoft.public.access.developers.toolkitode)
  • Re: Compact & repair w/VB6
    ... Is there a best method of compacting a database? ... 'Compact a JET database using ADO ...
    (microsoft.public.vb.database.ado)
  • Re: Which is the best single-user DB ?
    ... Jet SP is available from http://www.microsoft.com/downloads and Jet is ... installed on most computers even not being part of MDAC. ... There is also ODBC driver if you do not want to depend on ADO ... > Jet-Engine is DAO and no longer part of the MDAC installation, ...
    (borland.public.delphi.thirdpartytools.general)
Loading