I have an old access 2003 DB containing a number forms, Queries, reports and macros.
I want to convert this DB from 2003 to 2007, is it a case of just opening it in 2007 or are there any pitfalls I need to watch out for?
Thanks.
I have an old access 2003 DB containing a number forms, Queries, reports and macros.
I want to convert this DB from 2003 to 2007, is it a case of just opening it in 2007 or are there any pitfalls I need to watch out for?
Thanks.
Have you searched topic? Lots of discussions. See the "Similar Threads" at bottom.
Should be able to just open and then SaveAs.
Some have encountered issues with VBA. One I read was about referencing nested subforms.
Shouldn't hurt to try. Use a copy of db if you are concerned.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
So just do a SaveAs and all data, forms, queries, macros and reports will port across to 2007 and just use it then in 2007..
Thanks for the help.