How To Convert Access 2003 Application To Access 2007 Version

  • Thread starter Thread starter EarlCPhillips
  • Start date Start date
E

EarlCPhillips

This office is converting to Office 2007. I have been asked to convert a
current Access 2003 Application scheduling volunteers into something
compatible with Office 2007. I have been given a virtual machine with the
application loaded. I do not have any idea how to look at the VBA I wrote,
run diagnostics or step thru the code in Office 2007. Can anyone suggest a
book or web site that covers this topic. I am slightly above beginner
status, so it will have to be fairly basic and step-by-step. As an example,
how do I stop execution at the Current Event for my main page. Something is
not computing there.

EarlCPhillips
Ex-mainframer Learning Access To Improve The
Efficiency Of The Food Bank In Feeding The Hungry
 
Access 2007 can open/run access 2003 mdb without issue. Simply run your db
and see what happens. In general I have had no issues running older db 2000
& 2003 on 2007.

Just try it. Don't look for work, where there may not be any.
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.
 
This office is converting to Office 2007. I have been asked to convert a
current Access 2003 Application scheduling volunteers into something
compatible with Office 2007. I have been given a virtual machine with the
application loaded. I do not have any idea how to look at the VBA I wrote,
run diagnostics or step thru the code in Office 2007. Can anyone suggest a
book or web site that covers this topic. I am slightly above beginner
status, so it will have to be fairly basic and step-by-step. As an example,
how do I stop execution at the Current Event for my main page. Something is
not computing there.

EarlCPhillips
Ex-mainframer Learning Access To Improve The
Efficiency Of The Food Bank In Feeding The Hungry
Click to expand...

The "Ribbon" is a drastic change to the user interface for us developers, and
it does take some getting used to! But a 2003 application should run just fine
in 2007, if you do the right tweaks. For one thing, the database must be in a
folder which Access recognizes as a "Trusted Location".

Allen Browne has compiled a very useful page on the subject:

http://allenbrowne.com/Access2007.html
 
Back
Top