Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

.ade and .adp Access files

Posted on 2013-01-29
5
Medium Priority
?
1,527 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 58
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 58
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 58
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 58

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 2000 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

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

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

You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

715 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