Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

.adp Access file to .ade

Posted on 2013-01-15
4
Medium Priority
?
1,099 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 58

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 2000 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 58
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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
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…

886 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