I doubt backward compatibility alone is the solution
Access 97 doesn't install very well on XP but it is possible with some hacks.
This is because when they wrote 97 they assumed the computer hard disk would not go above 1MB.
To get it to run on Windows 7 or 8 is like pulling teeth
It probably is possible to get it to install in Windows 7
But once something gets beyond about 3 hacks ...it's time to look for another solution
Unless you only have 1 user. In which case pray they dont get a better job.
Reverse engineering operating systems is not a good idea.
Then again what twit at Microsoft decided to stop me writing to the top of the C drive by default.
Why dont you disconnect the keyboard as well then it definately cant get a virus.
Never write any macros or anything sophisticated in Access
They will change it and all your development time will be lost in the ether.
To be fair this is partly down to the fact Access has to fit in with other database software.
It's far easier to keep Powerpoint and Excel fairly static in structure ...I would imagine
That said ... tried writing an add-in in Excel 2007.
Far easier to write it in 2003 and then reverse engineer.
Could they make it harder?