First post and hopefully something that hasn't been asked and answered already. Although it probably was 10 years ago when everybody else made this switch to Access 2000. I have been fighting to tooth and nail to stay the Access 97 course as long as I could. I am not a programmer, but I play one at work. We have been using Access 97 (DAO 3.5.1) for 17 years and it has worked wonderfully. But since the most recent computer crash, it is time to get the upgrade and update religion flowing. 32 bit XP won't be around forever. I now have a Windows 7 - 64 bit computer running the trial.

So moving to Access 2007 is going to be a chore. As I prepare for the switch over, I have a 60 day trial version of 2007 on which I have converted the front end A97.mdb to 2007. I haven't tried linking tables to the back end mdb (a97), where all the tables are. Of course when I converted it stripped all and I mean all the modules from the database.

My first issue will be getting the A97 VBA modules imported to 2007 and learning what changes need to be made with the newer vba language so that they will function again. I have saved all the A97 modules as text files and am assuming that I can just create a new module and import the text files, even though they won't work initially. They contain some laborious code, mostly just calculations for invoice line items and grand totals.

I don't create from scratch vba code, although I can pretty much edit what has been written, as long as it is not programming related. Where I fall down is references that are no longer available DOA for example. It is now something else. Recordset properties, dim statements etc.

My question is, is this something I can handle as an amateur, or is this something that needs to handled by a pro? Can the pro look through the code text files and point to code that won't work and know how to replace it with current vba code? Or is it more involved like all the forms and reports that won't work anymore and will need to be updated as well?

Is there some cross reference guide that says a line of code in VBA 3.X.X should now be replaced with this updated format and show an example?

I apologize if my question is kind of vague. My mind is a little overwhelmed, the navigation of the new interface of Access 2007 alone is just not as easy as 97 and certainly not familiar.

Any advice, references would be greatly appreciated.

Dave