Solved

.adp Access file to .ade

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

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

744 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

10 Experts available now in Live!

Get 1:1 Help Now