Solved

.adp Access file to .ade

Posted on 2013-01-15
4
999 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
[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
  • 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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

Suggested Solutions

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…
As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
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…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

739 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