Solved

.ade and .adp Access files

Posted on 2013-01-29
5
1,434 Views
Last Modified: 2013-01-29
Hi all.

I'm looking at a .adp file that I'm not sure if it was worked on with Access 2003, 2007 or 2010. Access 2010 is currently installed on the one computer where the work is to be done while all the end users have an Access runtime to work with the .ade file.

Should I just edit it with Access 2010 and then create the .ade file?

I get 2 errors when trying to work with the .adp file in Access 2010:

"Your <<project name>> database or project contains a missing or broken reference to the file 'wiascr.dll' version 1.0"

and

"Your <<project name>> database or project contains a missing or broken reference to the file 'MSCAL.OCX' version 7.0"

Mind you, Access 2010 was just installed on this workstation where the work will be done.

Any help or guidance would be greatly appreciated.
0
Comment
Question by:printmedia
[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
  • 4
5 Comments
 
LVL 57
ID: 38832614
General rule of thumb has to always been create mde/ade's with the same version that the users are using.

<<"Your <<project name>> database or project contains a missing or broken reference to the file 'wiascr.dll' version 1.0">>

  That is a windows image aquistion .dll.  You'll need to find out where it came from.  You can try unchecking the reference and see of the app compiles.  It may be an old reference or not needed.

<<"Your <<project name>> database or project contains a missing or broken reference to the file 'MSCAL.OCX' version 7.0">>

 The calendar control does not come with Access as of 2010.  It was replaced with a date picker in Access.  You need to use the date picker or another calendar control.

 Do your users have the full retail version of Access or are they using runtimes?  If runtimes, I would update all to the A2010 runtime and develop in the same version.

  If not, then I would go back to A2007 on your station for development.

Jim.
0
 
LVL 57
ID: 38832631
<<'wiascr.dll' >>

 I just double checked on this and it is the Windows Image Application Scripting lib and was part of windows XP.

Support for it stopped in Vista.  If your still using it, you're going to need to find another way of image handling in Windows Vista/7.

 I would buy a 3rd party control to replace it depending on what it is your doing.

Jim.
0
 
LVL 57
ID: 38832640
0
 

Author Comment

by:printmedia
ID: 38832929
Could the calendar error be my answer, that this .ade was created from a .adp file created in Access 2007 and not Access 2010?
0
 
LVL 57

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 500 total points
ID: 38833072
<<Could the calendar error be my answer, that this .ade was created from a .adp file created in Access 2007 and not Access 2010? >>

 Most certainly something other then 2010.  Otherwise it would not have had the calendar control.

Jim.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

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…
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
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 …

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