Solved

Access '97 MDE and Windows '95/NT

Posted on 1998-11-02
16
577 Views
Last Modified: 2013-12-05
MS-Access '97 is suppose to be portable accross Windows '95 and NT.  I recently created an MDE under NT workstation but couldn't run it on a '95 PC.  I also created the MDE under '95 but couldn't run it under NT.  Any ideas as to why this causes an "invalid page fault in module VBA332.DLL" or a solution?
0
Comment
Question by:mcmonniesa
  • 6
  • 4
  • 2
  • +3
16 Comments
 
LVL 1

Author Comment

by:mcmonniesa
ID: 1967528
Edited text of question
0
 
LVL 2

Expert Comment

by:Belz
ID: 1967529
Access 97 is portable from Win 95 NT 4.0.  I move applications all the time between them.  Remember a MDE is not equivilent to a EXE, you still need MS-Access installed on the NT machine.  You also may want to download the latest version of VBA332.DLL from a shareware location or MS.
0
 
LVL 1

Author Comment

by:mcmonniesa
ID: 1967530
Thanks, but I have MS-Access '97 running on both systems and I have the latest version of VBA332.DLL.  Several others have told me they had no problems moving MDE's from one OS to another.  At this point, I'm wondering if the problem isn't with something else in my environment.
0
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 
LVL 2

Expert Comment

by:Belz
ID: 1967531
My brother just came to me last night asking about a page fault problem he's getting in the VBA322.DLL.  He works on Win95 PC's only.  His application is written in VB 6.0 and worked just fine last week.  He's one of MS larger clients so he's passing it back to them.  If I here anything I'll let you know.
0
 
LVL 5

Expert Comment

by:kulikuli
ID: 1967532
In case of win95 you should get the latest version of OLE32.dll
This will avoid different use of dates between the operating systems (the dll provided in win95 is NOT Y2K compliant).
0
 
LVL 1

Author Comment

by:mcmonniesa
ID: 1967533
Thanks!  I hadn't even think to check the DLLs, at work for Y2K.  I guess I shouldn't assume Microsoft would certify all their DLLs and notify us.  But I'm still left with the same basic problem.  Several other people have told me they had no problems between NT and '95.  We ran a test to see if it was just my environment but everyone else on my team ran into the same problem.
0
 
LVL 5

Expert Comment

by:kulikuli
ID: 1967534
Please let me know when the error on NT occurs; after which operations.
0
 
LVL 1

Author Comment

by:mcmonniesa
ID: 1967535
More Info:
1.  Created an application MDE with MS-Access '97 (SR-2) on a Windows NT 4.0 workstation then ran the MDE with MS-Access '97 (SR-1) on a Windows '95 PC.  Error Message - "MSACCESS caused an invalid page fault in module VBA332.DLL at 0137:651503f7. Registers: ..."

2.  Created an application MDE with MS-Access '97 (SR-1) on a Windows '95 PC then ran the MDE with MS-Access '97 (SR-2)on a Windows NT 4.0 workstation .  Dr. Watson Error Message "MSACCESS.exe Exception: access violation (0xc0000005), Address(0x651503f7)"

Any ideas why this is happening and how do I fix it.  I'm stuck working with multilpe environments and transporting application across them.
0
 
LVL 2

Expert Comment

by:Belz
ID: 1967536
SR-2 made changes to OLE32, VBA322, COMDLG, and a few other items.  I would try to update these 3 things and see want happens.  All three systems can be gotten from Microsoft as EXE upgrades.
0
 
LVL 1

Expert Comment

by:tuck
ID: 1967537
The mde will crash when refereneces in your mde at compile time on the Windows NT machine are not taken across to the windows 95 machine,  That is, if any other references like controls or other databases are in your mde on the windows nt machine then these have to be on the windows 95 machine either located in the directory where the mde is to run from or in the windows system directory.
Hope this helps


0
 
LVL 1

Expert Comment

by:tuck
ID: 1967538
The mde will crash when refereneces in your mde at compile time on the Windows NT machine are not taken across to the windows 95 machine,  That is, if any other references like controls or other databases are in your mde on the windows nt machine then these have to be on the windows 95 machine either located in the directory where the mde is to run from or in the windows system directory.
Hope this helps


0
 
LVL 1

Expert Comment

by:csalves
ID: 1967539
Hi,

Did you have included the system MDW in your MDE?

Bye,
0
 
LVL 1

Author Comment

by:mcmonniesa
ID: 1967540
The MDW is tickling the back of my brain, but I can't put a finger on it (old age).  I didn't do anything more than create an MDE from the Tools menu (Database Utilities).

Also, I'm setting up one of the '95 PCs with SR-2 to see if we can resolve this issue.  BELZ I let you know what happens.
0
 
LVL 9

Expert Comment

by:perove
ID: 1967541
A few more things to try:

Start the mdb with /DECOMPILE on the win95 machine, then compile & see what happen.(Take a backup first)

check out page:
http://support.microsoft.com/support/kb/articles/q148/4/24.asp
That deal with several situations for page faulting

perove
0
 
LVL 1

Author Comment

by:mcmonniesa
ID: 1967542
For those of you who are waiting for the test results:

  We upgraded the Windows '95 Office suite to SR-2 and guess what everything now runs fine.  Building an MDE with SR-2 did not run on SR-1.  Building an MDE with SR-1 would not run on SR-2.  Evidently, several DLLs changed with the new service release (SR-2) and are not completely compatible with other versions.

Belz,
   Thanks for the answer, please submit your last comment as a proposed answer and I'll award you the points.
0
 
LVL 2

Accepted Solution

by:
Belz earned 100 total points
ID: 1967543
SR-2 made changes to OLE32, VBA322, COMDLG, and a few other items.  I would try to update these 3 things and see want happens.  All three systems can be gotten from Microsoft as EXE upgrades.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question