• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 533
  • Last Modified:

Microsoft Access 2003 developer extensions Package Wizard Problem

I have a client who wanted a database application but did not want to purchase copies of access for each computer running the application.
So, using the developer extension package wizard I created a nice installable package which includes the runtime modules for access.  All installed and worked great and the client was very satisfied.  It is time to update the application and a very frustrating problem arises.  I am able to create a new package and CD with no problem.  When the application is installed on the computer, it says the old one must be uninstalled, so I get the original CD and uninstall the application, no problem.  
I now install the updated version of the application, the installation goes fine, and all seems well.  The new updated application is open and it looks just like the old application.  I uninstall and reinstall several times with the same results.  Thinking for some reason the old application is still located on the hard drive somewhere; I find and delete any reference to the old application.  I even create a new title, name, and new installation directory and repackage the application, just to install and get the same result.  I am assuming this has to do with the registry but I do not really know.  So, I need to know why the old application is still being open when no copy of the old application exists on the hard drive anywhere.  The application is written and packaged in MS Access 2003 and Windows XP home.  The application is being installed on a Windows Vista Home Premium machine.  Anyone with knowledge and experience using the developer extensions package wizard would be appreciated.
0
Joe Overman
Asked:
Joe Overman
1 Solution
 
therealmongooseCommented:
Was the install cd for the updated version definitely created with the correct updated version of the database - sounds like it may have been created using the old version and is just reinstalling...
0
 
Joe OvermanEngineerAuthor Commented:
Yes, I double checked it several times.
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Where are you installing the application on the Vista machine? I'd bet you're running into the folder virtualization issue with Vista. See this article:

http://support.microsoft.com/kb/927387

If this was an existing application, the ONLY thing you need to install would be the Access database. That is, there's no reason to reinstall the Access Runtime again if it's already installed.
0
Free recovery tool for Microsoft Active Directory

Veeam Explorer for Microsoft Active Directory provides fast and reliable object-level recovery for Active Directory from a single-pass, agentless backup or storage snapshot — without the need to restore an entire virtual machine or use third-party tools.

 
Joe OvermanEngineerAuthor Commented:
I will investigate on the vista machine try tomorrow afternoon and let you know.
0
 
Arthur_WoodCommented:
When you created the application (the Access part), did you create it as a 'split' database (with the forms, reports, etc in the 'front-end' linked to the data tables in the 'back-end')?
If you DID NOT, then when you replace the old version of the application with the NEW version, all of the OLD data will be lost - having been replaced by the new database.
0
 
Joe OvermanEngineerAuthor Commented:
Yes, it is seperated to front and back ends.
0
 
Arthur_WoodCommented:
ok.  
As indicated, you only need to re-distibute the Front-End database, since the Runtime has already been installed.  In fact, once the run-time is in place, there is no real need for an 'installtion package'. Simply provide the new fornt-end (which holds the new and hopefully improved application) and connect to theback-end, and they should be good to go.
 
AW
0
 
Joe OvermanEngineerAuthor Commented:
I have even tried that and it failed.  Even if I replace the front end with the new and improved database application, the shortcut, direct open, anything I try it still opens the old copy of the application.
0
 
Joe OvermanEngineerAuthor Commented:
Seemed to be the problem, thanks
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.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now