Re: CurrentProject.Connection failure

alex.hatzisavas wrote:
Tried this, didn't work.
The problem has to do with a certain functionality of Access being
corrupted.
Would a re-installation help?

I would try running the MDAC component checker found at:

http://www.microsoft.com/downloads/details.aspx?FamilyId=8F0A8DF6-4A21-4B43-BF53-14332EF092C9&displaylang=en

In the past it has identified for me inconsistencies between the
version of Access and the completeness of the installation of certain
components of MDAC. These inconsistencies resulted in problems with
CurrentProject.Connection; I'm sorry that I cannot remember the details
(I've shut them out of my mind, actually as ITs position was that the
application was flawed, when in fact, their installation of Office or
Windows was flawed; some tension developed at that time, but component
checker supported my position) so I cannot say if they were identical
with yours.

In any case, before resinstalling Access I would try installing the
latest version of MDAC, available from the same site, or its parent.; I
suspect it would be much simpler and just or more likely to cure the
problem.

.

Relevant Pages

  • Re: W2K to XP ADOX 2.5/2.8 problem
    ... I ran the MDAC component checker again and looked carefully at the ... I just ran the MDAC 2.7 Refresh installer, ... ODBCCP32.dll,Error,Field 'FileVersion' mismatch: Expect '3.520.9030.0' ...
    (microsoft.public.vb.database.ado)
  • Windows XP SP2 & MDAC
    ... ran the latest MDAC Component Checker. ... It identified my current MDAC ... installation as UNKNOWN. ... What MDAC installation is supposed to be on this ...
    (microsoft.public.data.ado)
  • Re: Runtime Error 91
    ... > I have a VB6 Application wich connect to an Access 97 database. ... > Runtime Error 91 Object variable or width block not set ... > told me that the version of mdac is already updated. ... > I checked the version with the MDAC Component Checker, ...
    (microsoft.public.data.ado)
  • Re: VB6, AdoStrm.ReadText...not reading text file
    ... Microsoft MVP Scripting and ADSI ... According to MDAC Component checker, ... Vista comes with its own data access libraries - the DAC 6.0 "Data Access ... MDAC packages are no longer supported on Vista. ...
    (microsoft.public.vb.general.discussion)
  • MS03-33 MDAC
    ... Nothing about MDAC turned up anywhere in a quick frisk. ... In February, I downloaded & installed MDAC 2.6SP2, or at least I thought ... As I now look at the MDAC Component Checker window, ... just go And download & install teh version I want once again. ...
    (microsoft.public.security)