Solved

.adp Access file to .ade

Posted on 2013-01-15
4
967 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Today's users almost expect this to happen in all search boxes. After all, if their favourite search engine juggles with tens of thousand keywords while they type, and suggests matching phrases on the fly, why shouldn't they expect the same from you…
Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

932 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

9 Experts available now in Live!

Get 1:1 Help Now