Solved

.ade and .adp Access files

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

Free Gift Card with Acronis Backup Purchase!

Backup any data in any location: local and remote systems, physical and virtual servers, private and public clouds, Macs and PCs, tablets and mobile devices, & more! For limited time only, buy any Acronis backup products and get a FREE Amazon/Best Buy gift card worth up to $200!

Join & Write a Comment

Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

706 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

23 Experts available now in Live!

Get 1:1 Help Now