Avatar of Silas2
Silas2

asked on 

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?
Microsoft AccessVBA

Avatar of undefined
Last Comment
Silas2
Avatar of DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
Flag of United States of America image

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
Avatar of John
John
Flag of Canada image

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.
Also "  Office 2015  " ... I assume you mean Office 2016 ?
ASKER CERTIFIED SOLUTION
Avatar of DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
Flag of United States of America image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Avatar of Silas2
Silas2

ASKER

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..."
That is bizarre !

Have you tried rebooting ?

If so ... try running an Office Repair on 2016
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.
"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.
Avatar of Silas2
Silas2

ASKER

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.
Avatar of Silas2
Silas2

ASKER

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.
Microsoft Access
Microsoft Access

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

226K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo