Legacy Access breaks with Access 2015

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?
Silas2Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
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)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 / Systems AnalystCommented:
Also "  Office 2015  " ... I assume you mean Office 2016 ?
Your Guide to Achieving IT Business Success

The IT Service Excellence Tool Kit has best practices to keep your clients happy and business booming. Inside, you’ll find everything you need to increase client satisfaction and retention, become more competitive, and increase your overall success.

DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
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.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Silas2Author 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 / Systems AnalystCommented:
That is bizarre !

Have you tried rebooting ?

If so ... try running an Office Repair on 2016
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
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 / Systems AnalystCommented:
"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.
Silas2Author 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.
Silas2Author 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.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.