أنشئ حسابًا أو سجّل الدخول للانضمام إلى مجتمعك المهني.
I have a client requirement to upgrade our Windows XP , Access 97 application to Windows 7, Access 2010. •This application involves more than 20 forms and sub-forms with VBA •Reports generation If you can share/guide me on step by step pre and post upgradation process/procedure from Access 97 to 2010 will be greately appritiated. Quick Questions: •What are the thing to be in handy before migration? •Is there anything, do i have to re-create? •Performance issues? •Any expected issues after post migration?
The same observations apply here as to those for converting Access97 to2003 databases. DMW hear of major problems in converting modules.
You may experience database problems if you install both Access97 and Office2007 or Office2010 on the same PC. There can be interference not only between the versions of Access but also between Access97 and other programs in Microsoft Office.
DMW no longer attempts to mix Access97 with programs from later versions of Office. Instead an old PC is kept solely for the purpose of running Access97.
There is a 'convert database' feature in Access2003. In DMW's experience, this rarely makes the conversion without some errors.
If your database is in the form of an MDE file, there are utilities advertised that claim to unlock MDEs. Once unlocked, so the claim goes, you can make changes to your MDE.
DMW have tried one unlocker program that gets mentioned a lot on the Web. In those of Access97 MDEs that DMW have 'unlocked' using it, the majority of forms and reports will not go into design view. Furthermore, none of the VBA modules are accessible.
So now may be the best time to review the functionality of your database prior to offering to tender for the rewrite