Jim DeMarco
Jdemarco at hudsonhealthplan.org
Fri Feb 24 06:53:26 CST 2006
>>They maybe running old VB6 programs calling DAO 3.51 Thanks Marty. This is exactly what they're doing. So will SP3 still fix for them? Or should they recompile their VB apps using a newer Jet version? Jim D. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of MartyConnelly Sent: Thursday, February 23, 2006 2:34 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Access 2000 Runtime Error (X-posted) Have client look at this file in windows explorer c:\program files\common files\microsoft shared\vba\vba6\vbe6.dll Right click on file select properties then selectr version tab and then file version For Office 2003 I have version number for vbe6.dll 6.04.9972 If you have equal to or lower than 6.3.91.8 then it is the faulty Office 2000 vbe6.dll And needs the Office 2000 SP3 installed Jet or DAO 3.51 in msjet35.dll is only installed by Office 97 or MDAC 2.1 (hasn't been downloadable for 2 years from MS) Access 2000 uses DAO 3.6 msjet40.dll They maybe running old VB6 programs calling DAO 3.51 I have Office 97 and 2003 installed C:\WINDOWS\system32\msjet35.dll My version is 3.51.3328.0 C:\WINDOWS\system32\msjet40.dll version 4.00.8618.0 I have heard of certain DAO 3.6 installs removing DAO 3.51 so you might want to check they are both there Most DAO calls that ran against 3.51 will run against DAO 3.6 except for security fixes. Jim DeMarco wrote: >Thanks Gustav. > >It looks like they may have changed the link to that article. I get this article when I click the link you attached: > >"You receive an error message when you try to view the code in a module, compile a database, create an MDE file or execute code in Access 2000" > >I think they're running WinXP as well but I'm waiting for an answer on that. > >I'm the meantime I think I need to find a better search phrase. I'm coming up blank (irrelevant) on Google and kbalertz.com. > >Jim > >-----Original Message----- >From: accessd-bounces at databaseadvisors.com >[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Gustav Brock >Sent: Thursday, February 23, 2006 12:28 PM >To: accessd at databaseadvisors.com >Subject: Re: [AccessD] Access 2000 Runtime Error (X-posted) > > >Hi Jim > >Could it be the old VBE6.dll issue: > ><snip> > >Take a look at >http://support.microsoft.com/default.aspx?scid=kb;en-us;Q304548 > >This is a typical error when you do not have O2k SR-3 and you have a 2002 or later app installed on the same machine. The VBE6.DLL for 2002 breaks the 2000 Access executable. > >Charlotte Foust > ></snip> > > > >>>>Jdemarco at hudsonhealthplan.org 23-02-2006 17:47:27 >>> >>>> >>>> >X-posted AccessD: dba-VB > >Lists, > >We inherited (and distribute) an Access 2K app that uses the Access runtime. One of our user sites (not affiliated with our company) is having a problem running VB apps on machines where this app is installed. Here's a copy of what I got from their IT resource: > ><errorDescr> >"...happens when an application is started. >A window opens saying somthing like "Loading Access 2000 Runtime" and displaying a Windows progress bar. >Then a "File Not Found" message window opens. If you cancel out of the window, another "File Not Found" windows opens, etc.. >If you cancel out of these windows about 3 or 4 times, the program will start. ></errorDescr> > >They're using Jet 3.51 for "ADO and DAO data access" (quoting their IT resource). Is anyone familiar with this? I searched M$KB but didn't find anything. > >TIA > >Jim DeMarco >Director of Application Development >Hudson Health Plan > > > -- Marty Connelly Victoria, B.C. Canada -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com *********************************************************************************** "This electronic message is intended to be for the use only of the named recipient, and may contain information from Hudson Health Plan (HHP) that is confidential or privileged. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution or use of the contents of this message is strictly prohibited. If you have received this message in error or are not the named recipient, please notify us immediately, either by contacting the sender at the electronic mail address noted above or calling HHP at (914) 631-1611. If you are not the intended recipient, please do not forward this email to anyone, and delete and destroy all copies of this message. Thank You". ***********************************************************************************