Legacy Access breaks with Access 2015

Silas2
Silas2 used Ask the Experts™
on
I've got a very cherished version of Access 2k, I'm supporting a number of legacy apps with all the old toolbars, etc. All the good stuff which has gone....so I really need it...but I've just installed Office 2015 and to my horror Access 2000 breaks/ runtime exception.
Up till now, I've been able to run Access 2k with the later versions side by side...is there a way to continue?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Application Developer
Top Expert 2007

Commented:
First thing to do is ... open the VBA Editor ... Tools>>References
Look for any that show:

**MISSING <SomeReferenceName>

Resolve missing references if any.

If no missing References (unlikely) ... the Debug>>Complile

There will likely be some compile errors ...  report back

mx
JohnBusiness Consultant (Owner)
Most Valuable Expert 2012
Expert of the Year 2018

Commented:
Either set up a virtual machine with an older operating system to run your legacy application, or else upgrade the application. Coexistence of Office was never the greatest idea.
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Application Developer
Top Expert 2007

Commented:
Also "  Office 2015  " ... I assume you mean Office 2016 ?
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Database Architect / Application Developer
Top Expert 2007
Commented:
No need for a VM really.  I've run multiple version of Office on one machine for many years.

Although you may ... have some issues coexisting A2K with A2016 ... SO much has changed.

Author

Commented:
Actually, I think I panicked a bit early. I have got the old 2k running, its just the VBA code editor is behaving a bit strangely.. mmmm...its nothing very consistent to be easy to comment on...for the first time ever (I an remember) I'm getting the code window saying:
"Not enough memory to show window..."
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Application Developer
Top Expert 2007

Commented:
That is bizarre !

Have you tried rebooting ?

If so ... try running an Office Repair on 2016
Jim Dettman (EE MVE)President / Owner
Most Valuable Expert 2017
Most Valuable Expert 2012

Commented:
Hopefully Access 2016 went in a separate directory from A2000.  If not, your going to need to un-install both, then re-install in order.

Jim.
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Application Developer
Top Expert 2007

Commented:
"then re-install in order."
Just to elaborate slightly ... Install A2K then A2016 *in separate folders*

However ... since A2013 no longer supports A97 mdbs ... It's VERY likely that >A2016 may not support A2K mdbs.

So ... at some point ... you will need to convert your mdbs to ACCDBs ... the sooner, the better.

Author

Commented:
Phew....its working now, strange behaviour at first, seemed to get better with use...weird.
Leave Access 2k, never! What about the toolbars? The use-level security?
What's really been added? The VBA is the same vintage isn't it?
The only thing I've actually missed is the ability to embed some text functions into SQL...but easy to work round.

Author

Commented:
btw, I've just tested my 2k legacy apps in the 2016, and they seem to work fine. I reckon 2k will see me to retirement.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial