Re: Problem with MDAC 2.81 on Windows XP with SP2

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance



Hi,

I don't get any errors, but strange behavior.
For example: The following code
rs.find "Item_Size Like '" & typed_Name & "%'", , , 1
works with MDAC 2.8 without SP2,
but the same code with SP2 and MDAC 2.81 cause the rs to jump to EOF.

I also have problems sorting the recordset.

Thanks,
Tal.

Ralph wrote:
<talgreen1@xxxxxxxxx> wrote in message
news:1148454794.069132.39220@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hi,
I have a VB6 application with Access XP Database.
I developed it on XP without SP2, and I had to install MDAC 2.8 to
enable some ADO features (like search backwards in Recordsets).

Now I'm trying to run this application on Windows XP with SP2 but
many features in the ADO (the ones that requires MDAC 2.8) are not
working. I tried to install MDAC 2.8, but it's seems that SP2
contains MDAC 2.81.

My questions are why my app does not work with MDAC 2.81? Are there
some known problems with this version?
And is it possible to install MDAC 2.8 somehow? (Maybe install Windows
XP without SP2, then install MDAC 2.8, and only then install SP2)?

I would appreciate any help on the subject,
Thank you very much,
Tal.


What do you mean by "does not work". What errors are you getting? What are
you trying to do when the error occurs?

As long as you have installed the correct MDAC package for your OS there
shouldn't be any versioning issues. It is more likely a "permissions"
problem.

hth
-ralph

.



Relevant Pages

  • Re: Windows XP SP2 and MDAC
    ... I'm having issues with Windows XP SP2 and MDAC 2.91. ... MS site states that MDAC 2.81 for Windows XP Pro can ONLY be found in SP2. ... and you can't install v2.81 stand-a-lone. ...
    (microsoft.public.windowsxp.general)
  • Re: Outlook.exe - entry point not found
    ... "I have tried to install the latest version of MDAC 2.8 but this can't be ... I'm using Window XP Pro SP2 and Office Standard 2003 SP2. ...
    (microsoft.public.outlook.installation)
  • VB 6 Application with MS Access 2000 backend for Windows 2003 Server
    ... They say it requires MDAC 2.6 Sp2. ... windows 2003 server and a newer version of citrix. ... Microsoft Windows Millenium ...
    (microsoft.public.vb.general.discussion)
  • Re: Error 1919, Error configuring ODBC data source...blah, blah, b
    ... Windows XP SP2" was determined to be the version of MDAC on my system...(also ... Would this reinstall the appropriate version of MDAC? ...
    (microsoft.public.office.setup)
  • Re: Crash VB6 on SP2 Mdac2.8?
    ... I suspect that the version of MDAC your program is designed to use is not ... Run Component Checker ... SP2 introduces a number of interesting side-effects that might also be ... > because it runs excellent on Win98 and Win2000 computers. ...
    (microsoft.public.vb.database)