Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

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

Posted on 2015-01-19
23
Medium Priority
?
177 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 97

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 39

Assisted Solution

by:PatHartman
PatHartman earned 400 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
Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

 
LVL 85

Assisted Solution

by:Scott McDaniel (Microsoft Access MVP - EE MVE )
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 1600 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 39

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 39

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 85
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 39

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 39

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 85

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 1600 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 97

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 85
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 97

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

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

Question has a verified solution.

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

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.
Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

721 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