Re: JET DAO access to Access 97 from VB4 in XP SP2

Tech-Archive recommends: Speed Up your PC by fixing your registry

On Thu, 5 May 2005 13:08:08 -0700, Edward <Edward@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

¤ I have an application written in VB4 that uses an Acces 97 database. This
¤ application has been widely used beginning on Win95 and NT4 through Win98,
¤ WinME, Win2K, and WinXP. The first problems reported on this program was
¤ when someone installed it on a machine with WinXP SP2. The program will not
¤ run on *some* machines with SP2 installed but runs fine on others.
¤
¤ In-house I installed WinXP SP1 on a test machine and installed the program.
¤ It ran fine. I then installed the SP2 update and the program continued to
¤ run fine. We just received a machine that came with XP SP2 already
¤ installed and it will NOT run on this machine. It gets to the command to
¤ open the database and then exits because the database could not be opened.
¤
¤ I wrote a quickie program in C# .NET just to test the file and it will open
¤ the file, open a table, display two fields from every record in the
¤ database, and then close the file.
¤
¤ Given the massive number of VB4 programs we have, it would not be feasible
¤ to update them all immediately to something suce as C#. But we can't update
¤ our in-house machines (which would come with XP SP2) if our programs won't
¤ run on them.
¤
¤ Files installed by the app:
¤ vb40032.dll
¤ msjt3032.dll
¤ msjter32.dll
¤ msjint32.dll
¤ vbajet32.dll
¤ vbdb32.dll
¤ mswng300.dll
¤ vbar2232.dll
¤ ven2232.olb
¤
¤ Additional files copied to the test machine:
¤ msrd2x32.dll
¤ msrd2x35.dll
¤ msjter35.dll
¤ msjint35.dll
¤ vbar332.dll
¤ vbdb300.dll
¤
¤ Also ran the JET35SP3.EXE update program. But at this point the program
¤ still will not open the database. Any suggestions what changed in XP SP2
¤ that prevents it from opening the database?

What is the error you are getting? I'm guessing you're probably using a previous version of the Jet
database engine that is not installed on the machine.


Paul
~~~~
Microsoft MVP (Visual Basic)
.

Relevant Pages

  • Re: Load Picture from MS Access to VB6
    ... in code to compact the database via a menu option. ... there is a chance the filename of the photo itself can ... > ¤ Well, I figured it out I think. ... loaded images into the database directly through Access (so that I could ...
    (microsoft.public.vb.general.discussion)
  • Re: Please Help Me in Visual Basic 6.0 SP6
    ... Dim dbPath As String ... Above is my programming where in this programming, ... how can i indicate myself which one i'm gonna insert to the database. ... > ¤ solution where as somebody can help me where to start. ...
    (microsoft.public.vb.database)
  • Re: Any reason why accessing Access should slowdown?
    ... On the MSACCESS / JET OLEDB front, you responded to a query I had about the ... Declared connection to Access database using string based on Jet OLDB ... Set up recordset filter in response to earlier input / selection ... ¤ I am writing a VB6 App using an Access database backend ...
    (microsoft.public.vb.database)
  • Re: Copy database schema from Access to SQL Server
    ... It can import a JET database in a single stroke. ... Hitchhiker's Guide to Visual Studio and SQL Server ... ¤ projects to SQL Server, ... schema and then use DDL code to create the corresponding objects in SQL Server. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Dynamic MDB creation for specific formats 2000-2007
    ... If the specific format could be created from the outset - ... the resulting database - if they were - wouldn't care about any of this. ... ¤ If the database is being created on one system which by default creates ... It doesn't matter when accessing the database through Jet ADO or DAO. ...
    (microsoft.public.vb.database.ado)