Solved

I want a windows 8 system with Access 2013 and Access 2002 to always use 2002

Posted on 2015-01-19
23
164 Views
Last Modified: 2015-01-22
I need to install programs on the windows 8 system that have an access 2002 based application. How can I make access 2002 the default version that the system uses?
0
Comment
Question by:dovidf
[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
  • 11
  • 5
  • 4
  • +1
23 Comments
 
LVL 95

Expert Comment

by:John Hurst
ID: 40558993
I am fairly sure Access 2002 is not ever going work on Windows 8. Too old.

So you need to create a virtual machine in Windows 8 (probably XP) and run Access 2002 in the virtual machine.
0
 
LVL 37

Assisted Solution

by:PatHartman
PatHartman earned 100 total points
ID: 40559030
I don't know how to do it in Win 8 but with Win 7, right click on an .mdb and use the OpenWith menu to set the default.Set Program Default
If this is your own development computer, don't double click on databases.  Open the Access version you want to work with first, then choose the database file.  If this is a user's computer, he shouldn't have two Access versions installed.  He should be working with the highest level version he needs for any app.  If you "must" have him work with multiple versions (not recommended at all), then create shortcuts for each Access app that open Access itself and pass in the database name.
0
 
LVL 4

Author Comment

by:dovidf
ID: 40559061
I have it working for a standalone mdb. I need it to work for word automation. It complains that it can't handle replicated databases.
0
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.

 
LVL 84

Assisted Solution

by:Scott McDaniel (Microsoft Access MVP - EE MVE )
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 400 total points
ID: 40559550
You could also use SageKey. It's an installation program used with Access which can "rewrite" the necessary registry keys to make a specific application run with the correct version of Access. When that program is done, Sagekey will the write back the original reg keys.

http://www.sagekey.com/installation_services.aspx
0
 
LVL 4

Author Comment

by:dovidf
ID: 40559573
Scott,

Sagekey sounds like the right idea but it's a bit expensive. The user doesn't need the later version of Access. I am going to try to uninstall it.
0
 
LVL 37

Expert Comment

by:PatHartman
ID: 40559789
Does what I suggested not work in Win 8?  If the right-click menu has been changed and you can't find the Win 8 equivalent,  surely the shortcut method will work unless MS has removed shortcuts from Win 8.
0
 
LVL 4

Author Comment

by:dovidf
ID: 40560018
PatHartman,

I don't know how to apply it in the Word vba code.
0
 
LVL 37

Expert Comment

by:PatHartman
ID: 40560108
You don't apply it in Word.  You apply it in Windows by setting the program to open for any given file type.  Were you able to do that?  Did Word still complain?  It is more likely that the problem is using Word 2013 against an .mdb that is replicated.  Do you still have O2002 installed or just the Access part?

is the database actually replicated or is the replication flag an artifact that you can get rid of by turning it off?
0
 
LVL 4

Author Comment

by:dovidf
ID: 40560177
I have used to code previously for older versions. Now the Word programming is complaining that it doesn't handle replicated data sets. I don't see why that should be an issue since the table structure and content is unaffected by the replication status.

I only installed access 2002. The tables that are replicated are marked with some sort of indicator.
0
 
LVL 84
ID: 40560315
If the Automation if running in Word, then I'm curious how this will work. Word would contain the reference needed to create those objects, of course, so if you force Word to use the 2002 reference, you'll have to be very careful when making changes to that document. You'd have to be sure the reference was "reset" correctly after making those changes, and the only way to do that would be to either (a) use Late Binding or (b) do the Word doc changes on a machine running 2002 or earlier.

Either way, a review of the process, and possible fixes to make it a bit more "future proof" would be in order.
0
 
LVL 37

Expert Comment

by:PatHartman
ID: 40560337
Have we determined that it is Word that is having the issue?  If so, can you install W2002 and use that?

Of course removing the replication may be the best option.  Then you can use the newer versions of Access and Word.  Can you remove the replication?

Another alternative is to create a VM and install only O2002.  Then run the automation process in the virtual machine.  Thirteen years is a long time as the lifespan for a piece of software.  As you can see, the world around it is changing and many older features are no longer supported.  The VM will allow you to isolate the app and work in a time warp.
0
 
LVL 4

Author Comment

by:dovidf
ID: 40560421
Word is not creating any objects. it is only referencing the access table for read only purposes.

I need the replication because data is being added in 2 different places and needs to be merged from time to time. For various reasons, an online connection is not possible at the moment.
0
 
LVL 4

Author Comment

by:dovidf
ID: 40560445
Removing the replication may work if I make a copy of the table without the replication and have the word program reference it.
0
 
LVL 37

Expert Comment

by:PatHartman
ID: 40560493
Setting up the VM will allow you to keep the old stuff and simply run it in a bubble.  You won't have to change anything.
0
 
LVL 4

Author Comment

by:dovidf
ID: 40560816
Do you know of a free vm?
0
 
LVL 84

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 400 total points
ID: 40560825
I'd agree that creating a VM would allow you to keep things as is - but eventually you'll have to migrate this to a more modern platform. I'd suggest you do this sooner rather than later. Access replication is gone in 2007 and newer, and eventually you'll have to move to those newer platforms.

Note that SQL Server does replication also, so it's conceivable you could migrate to SQL Server and be done with all of this. SQL Server Express is free, and might be the better long term answer.
0
 
LVL 95

Expert Comment

by:John Hurst
ID: 40560843
VMware Player is free, Workstation is much better but not free. Virtual Box is (I think) free.
0
 
LVL 84
ID: 40561516
VirtualBox is free:https://www.virtualbox.org/

I've read of a free version of HyperV, but can't find it anywhere.

Note that with any VM software, you must treat it like a physical machine in terms of licensing, so you'd need to have a full license for the OS, any Office products, etc.
0
 
LVL 4

Author Comment

by:dovidf
ID: 40561891
I've come to the conclusion that I need to move to a new design as Scott suggested as it's becoming more cumbersome to maintain the current design for a number of reasons.

In the meantime, I want to either uninstall Office 2013 and reinstall without Access 2013 or take the mdb from the 2013  based system and run the report on an older system which doesn't have the current problems. This would require a bit of extra work but could work in the short run.
0
 
LVL 4

Author Comment

by:dovidf
ID: 40563473
I tried to uninstall and reinstall Office 2013 without access and I was told it didn't have it. I installed full office 2002 and now the word program comes up and doesn't complain but it's not running the code. On to the next step.
0
 
LVL 4

Author Comment

by:dovidf
ID: 40563475
Office 2002 superseded office 2013 when it was installed. In any case, I think the ultimate solution is to move to a more modernize approach.
0
 
LVL 95

Expert Comment

by:John Hurst
ID: 40563525
Modernizing is a good idea. Perhaps uninstall all Office, restart and then install only Office 2013.
0
 
LVL 4

Author Closing Comment

by:dovidf
ID: 40564390
I've got it working now. Installing the full 2002 office enabled everything. I still had to enable macros in the word program. Installing the 2002 version over the 2013 version gave it precedence. I discovered that the version of 2013 office that was on the machine didn't even have Access.

The ultimate solution for this software would be to find a commercial program that provides the functionality for it. So modernizing it is the way to go.
0

Featured Post

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

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

Suggested Solutions

This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
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…

751 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