?
Solved

Access 2010 don't load forms correctly for .mde file

Posted on 2016-08-22
13
Medium Priority
?
63 Views
Last Modified: 2016-08-22
Hi,

Some users are still using Access 2003. Nowadays I use the 2010 to develop new .mdb program versions. The .mdb file is copied to a 2003 system and a .mde file is created. The .mde works fine with 2003, but not any longer for 2010. The error is the following.

When most forms are loaded, access will ask for the parameter values that are used in the listboxs' queries. For example, "Enter Parameter Value" and the control name referenced to. Since it works for 2003 the name is correct and the control exists.

I am still using Dao 3.6. Beföre the creation of the .mde, the refercencies are the proper one. Notice that I use the dao 3.6 also in the 2010 version.

What is happening? I have never seen anything like this.

Thanks in advance

BAnders
0
Comment
Question by:BACapta
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 8
  • 5
13 Comments
 
LVL 58
ID: 41765713
<<What is happening? I have never seen anything like this.>>

<<For example, "Enter Parameter Value" and the control name referenced to. Since it works for 2003 the name is correct and the control exists.>>

 Broken references and possibly 32 bit Office vs 64 bit Office.  Are all your Access 2010 users using 32 bit?   I'd start with that.

 References are harder to pin down in terms of fixing.

Jim.
0
 

Author Comment

by:BACapta
ID: 41765730
32-bits but win7 64 bits
0
 

Author Comment

by:BACapta
ID: 41765732
Sorry not all my users use 2010.
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
LVL 58
ID: 41765751
<<When most forms are loaded, access will ask for the parameter values that are used in the listboxs' queries. >>

 A2010 did tighten up on a lot of things internally; what kind of syntax are you using for the control reference?

Jim.
0
 

Author Comment

by:BACapta
ID: 41765756
Notice, I have put in msgbox in Form_open event at the beginning and the "Enter .." turn up before that event. So, it is while loading the controls.
0
 

Author Comment

by:BACapta
ID: 41765757
[Forms]![FormName]![ControlName] the same as you get using the Build Tool.
0
 
LVL 58
ID: 41765765
Well syntax is OK.

<<Notice, I have put in msgbox in Form_open event at the beginning and the "Enter .." turn up before that event. So, it is while loading the controls.>>

  Are you doing anything in the form open event with the controls, like assigning rowsources?

Jim.
0
 

Author Comment

by:BACapta
ID: 41765779
The Rowsources are assigned at design.

I am not 100% sure, the problem was not around a week or so ago. I have run a .mde which was created a couple of weeks ago and that one worked,, not anylonger, same problem.

BAnders
0
 
LVL 58

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 2000 total points
ID: 41765803
<< I have run a .mde which was created a couple of weeks ago and that one worked,, not anylonger, same problem.>>

  Has to be references then somehow...

  Put a copy of the MDB on a 2010 machine and open it (assuming your not using the run-time) and see if there are any problems with references.

  Watch it though; the basic references for Office/Access will auto update to the 2010 versions, so make sure you don't mix it up with what you use for A2003.

 If that works, then try making a MDE on with A2010 and test that.  If that works, then it's definitely references breaking in some way from the 2003 version.

Jim.
0
 

Author Comment

by:BACapta
ID: 41765889
To start with the last test creating the .mde with A2010. It works for A2010, but not for A2003. It will not recognize the database format. It is like that it can't handle the future referencies. Notice, it is a .mdb that has been created to .mde.

I have exported referencies via printscreen of a MsgBox, see attachement. I can't see any difference between the later two, and still one not work and the other one does.

BAnders
0
 

Author Comment

by:BACapta
ID: 41765922
Does not should it be. This is Ok for now. I will start to use package installation kits later on.

Many thanks.

BAnders
0
 

Author Closing Comment

by:BACapta
ID: 41765924
You always learn something new. I didn't know that you can create a mde from 2010, anyway not working on A2003.
0
 
LVL 58
ID: 41765978
Yes, you can create a MDE in any version of Access and it is recommended that you use a MDE that was created with the same version that your executing to avoid problems.

 Although for the most part, you can take a MDE from a prior version and run it in a later version. A2010 is a bit different in that it was the first version to have both 32 and 64 bit VBA and there was some issues with that early on when it compiled VBA code.   That may or may not have something to do with this (they made a few changes in VBA to accomplish that).

 A MDE by the way is nothing more than a MDB with the source code stripped out.

Jim.
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering 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

Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
This article describes a serious pitfall that can happen when deleting shapes using VBA.
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

752 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