Solved

.adp Access file to .ade

Posted on 2013-01-15
4
974 Views
Last Modified: 2013-01-15
Hi all.

A friend asked me to help him with his company's access form. The problem is I've never worked with .adp and .ade files. So I have some basic questions.

1. I know that I need to make changes to the original .adp file and then save it as an .ade file. But when I do that, does it compile the code and check for any errors during this process?

2. Once I save it as an .ade file how do I make sure the end users throughout the network have the copy with the latest changes? Is there some sort of script? Or if they all have shortcuts to this .ade file they will automatically see the changes?

3. How should I work on code and test before applying these changes to the LIVE system? Should I make a copy of the .adp file and name it something else (say MyTest.adp) and then save the .ade file as MyTest.ade and then try opening it on an end user workstation to see if the changes are ok?

Thank you in advance!
0
Comment
Question by:printmedia
  • 2
  • 2
4 Comments
 
LVL 57

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 500 total points
ID: 38778733
<<1. I know that I need to make changes to the original .adp file and then save it as an .ade file. But when I do that, does it compile the code and check for any errors during this process?>>

  Yes, a adp (or MDB) must cleanly compile before it can be made into a ade/mde.

<<2. Once I save it as an .ade file how do I make sure the end users throughout the network have the copy with the latest changes? Is there some sort of script? Or if they all have shortcuts to this .ade file they will automatically see the changes?>>

 That varies.  Nothing is built into Access to do that.  Some use nothing more then a batch file executed by a shortcut to copy a new version down.  Some do it in the app.  Others use a "launcher" app that starts up, does a version check, and copies down a new FE to the station before the app starts.

  There are also setups where the FE is shared (not recommended) and everyone has a shortcut that points to the same FE, so you only replace the one.

 <<3. How should I work on code and test before applying these changes to the LIVE system? Should I make a copy of the .adp file and name it something else (say MyTest.adp) and then save the .ade file as MyTest.ade and then try opening it on an end user workstation to see if the changes are ok?>>

 That would be one way, but you should have a test environment that is totally isolated from the live one.  In your example, your still going against live production data.

  One wrong filter on a delete and oops....

Jim.
0
 

Author Comment

by:printmedia
ID: 38778812
Thank you for the reply Jim.

As far as <<2. my friend has no idea, he paid some guy years ago to do this and the guy can't be found.

What can I do to find out? Would the batch files be on the individual workstations or the server? What can I search for: "*.bat", how do I look for the launcer? On each individual computer, if so what file extension?
0
 
LVL 57
ID: 38779215
I would first look at the shortcut that points to the app.

 If it references something other then MSACCESS.EXE, or names a DB other then your app, then it is using a launcher.

 If not a launcher, then I would look to the menu system on a station and see if there is any kind of an "update" available.

 If none, then I would look on the server and see if there is a batch file.  It would most likely be in the same directory as a "master" copy of the FE, so do a search for that.

 If none, then I would look in the app iteself and see if there is any logic in it for updating the app.

 If none there, then it may just have been a manual file copy and paste.

 The latter would probably be a good bet if there are only a handfull of users.  Usually, most developers don't worry about program updates right off and leave that till the end if they do it at all.

 Last, maybe talk to an employee that uses the app that's been there a while?  They might remember something.

Jim.
0
 

Author Comment

by:printmedia
ID: 38779282
Great thanks Jim.
0

Featured Post

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

778 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