I've nearly finished writing an application in Access with the intention of marketing it commercially to targetted (but unvisited) users as a runtime MDE. I started out with Access97 Developer, but part way through the project upgraded to XP Developer - because it seemed best to be using a newer version, and it also had "compact on exit" to keep things running smoothly.
However, having recently joined this EE group, and seen the various problems people are reporting integrating runtime on end user machines (particularly if they already have Office/Access/other runtime installed), and other problems with differing operating systems and environments - I'm beginning to wonder if this is going to be a good solution.
I'm seeing products like Wise and SageKey being suggested (at huge cost!) as better than Developer, and also a tendancy for some authors to prefer 97 over XP?
I've also read somewhere that if you distribute in XP, than you need to provide two CDs?
So, this is my 500 point question:
What is the best way (as in compatible, successful, reliable) to distribute an Access application out to the masses, and what limitations would apply?