Solved

Moving a .mde file to another PC.

Posted on 2004-08-26
23
227 Views
Last Modified: 2013-12-05
I currently have a .mde on a windows 95 machine using access 97.  I want to move it to an xp machine also using access 97.  When I try to open up the mde, Access 97 just crashes and I get the Send error report dialog.  Is there something that needs added to the Access 97 install or something in XP that needs changed?
0
Comment
Question by:jhaiken
  • 10
  • 5
  • 4
  • +1
23 Comments
 
LVL 65

Expert Comment

by:Jim Horn
ID: 11902307
You cannot run an .mde file compiled in a specific version of Access ('97) on a machine with another version (XP).   This is by design.

The only option you have is to find the Access '97 .mdb file that created the .mde, upgrade that file to an Access XP .mdb, then compile to an .mde.

Hope this helps.
-Jim
0
 

Author Comment

by:jhaiken
ID: 11902381
I'm not using Access XP.  I have Access 97 loaded on an XP machine.
0
 
LVL 65

Accepted Solution

by:
Jim Horn earned 43 total points
ID: 11902477
In that case, there's still a number of issues going on with file references that were good on your 97 box, but not good on your XP box.  Since you can't break into code in an .mde file, or even introduce new code to diagnose it, you can't fix it.

You'll still need to find the Access '97 .mdb file that created the .mde, and move it to your Windows XP/Access 97 box.  Then go into any code module, break into code, and click on the Tools menu, References menu item.  If any references are bad, you'll see the word 'MISSING' in front of them.  You'll have to manually reconnect these files to wherever they are at on the XP box.

This also assumes that all of these files are on your XP box, including (most likely) Microsoft Data Access Objects (DAO).

Also, it would be a good idea to eventually install Office/Access XP on your XP box, as Microsoft tends to make things very uncomfortable when you don't follow their migration strategy.

Hope this helps.
-Jim
0
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 

Author Comment

by:jhaiken
ID: 11902759
I have the mdb file; but I can't even open that.
0
 
LVL 36

Assisted Solution

by:SidFishes
SidFishes earned 41 total points
ID: 11903423
can you start A97 with a blank mdb?

can you start the crashing mdb by holding down the shift key when you open?

0
 

Author Comment

by:jhaiken
ID: 11903594
Yes and Yes.  Now what?
0
 
LVL 36

Expert Comment

by:SidFishes
ID: 11903820
ok click on any form and view code

goto debug and select compile...see what errors you get...
0
 

Author Comment

by:jhaiken
ID: 11903868
I do not see "view code"
0
 
LVL 36

Expert Comment

by:SidFishes
ID: 11903945
sorry...that's a200*....open the form in design view...you should see a view code there (i think...don't have a97 with me )
0
 

Author Comment

by:jhaiken
ID: 11903967
Design view is greyed out
0
 
LVL 36

Expert Comment

by:SidFishes
ID: 11904020
you must be in the mdb not the mde
0
 

Author Comment

by:jhaiken
ID: 11904041
No Im in the .mde
0
 
LVL 36

Expert Comment

by:SidFishes
ID: 11904080
you can't be...there's is no way to debug an mde...you must use the mdb where the source code is...for our purposes, the mde is useless right now...
0
 

Author Comment

by:jhaiken
ID: 11904124
Okay, I opened the mdb by holding the shift key.  I go to the forms tab, highlight a form and Design is greyed out.  Same thing if i open the mde.
0
 
LVL 41

Assisted Solution

by:shanesuebsahakarn
shanesuebsahakarn earned 41 total points
ID: 11904230
There is no reason that an mde file should not work - Access 97 works just fine on Windows XP.

The first thing to do is check that you have all Office service packs installed, and the Jet 3.5 update. Let us know if you've installed all of these. The other thing is, are you using any custom controls, such as ActiveXs in your forms? A file mismatch *can* cause this, but more often just causes reference errors.
0
 

Author Comment

by:jhaiken
ID: 11905309
How do I find service packs for Access 97?  I don't think it is supported anymore.
0
 

Author Comment

by:jhaiken
ID: 11905334
I even tried installing this on another Win95 machine and I get a page fault error.

MSACCESS caused an invalid page fault in module VBA332.DLL at 016f:651503f7
0
 

Author Comment

by:jhaiken
ID: 11906703
Okay, it works after the office 97 updates.  However, I am getting an error that the file is read only when I log in as another user on that XP machine.
0
 
LVL 41

Expert Comment

by:shanesuebsahakarn
ID: 11906738
The read-only error is being caused by XP permissions. Check that all users have read/write access into the folder where you have the mde file.
0
 
LVL 65

Expert Comment

by:Jim Horn
ID: 12166955
jhaiken - Looks like you've received some solid advice from multiple experts.  Since this question appears to be old, please consider awarding points for the effort and closing it.  Thanks in advance.  -Jim
0
 
LVL 65

Expert Comment

by:Jim Horn
ID: 12821377
Recommend include SidFishes
0

Featured Post

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

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

It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
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…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

808 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