Solved

.ade and .adp Access files

Posted on 2013-01-29
5
1,368 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
  • 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

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

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

When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
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, 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…

815 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

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now