Will 2003 database be compatible with Access 2007

[BillD]

I would like to find out if my Access 2003 databases will be compatible and
run if I upgrade to Access 2007.
The reason I am asking is I was trying to run Access Bible 2003 tutorial to
learn more about Access. When I tried to open the sample files on the
computer I was using the files would not open and a message window opened
stating I was trying to use an earlier version of Access or an incompatible
database. When I checked the properties I found that they have Access
2000/Office 2000 loaded on the computers (my computer at home has Office
2003).
I would hate to purchase Access 2007/ Office 2007 and find out that none of
my databases or other files will not run in 2007
Please advise on this
Thank you in advance.

 

[Tom Wickerath]

Hi Bill,

In general, you should be able to open your databases in Access 2007 without
any problems. It would be most helpful to verify first that you have no
compile errors in the earlier version, before you upgrade. To do this, open
any code module and click on Debug > Compile. Also, while you are in the VBE
(Visual Basic Editor), verify that you do not have a reference set to
Utility.mda. It seems that this file is not included in Office 2007.

Do make sure to download and install Service Pack 1 for Office 2007.


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

 

[Tom Wickerath]

PS. I forgot to mention that User Level Security (ULS), Data Access Pages
and Replication are not supported in Access 2007, at least not in the new ACE
database engine, which uses the .accdb file extension. In order to enjoy most
of the enhancements, you need to use the .accdb file format.

Also, a caution is in order:
I suggest that you not work on your database in Access 2007, and then try to
downconvert it to move it to an earlier version. There are many new features
in A2007 that simply are not supported in earlier versions. Also, the wizards
were re-written to create "Embedded Macros". So, any controls that you add to
your form using the assistance of a wizard, will not work if you later
downconvert, if the wizard created an embedded macro in the process. A
classic symptom of this would be a command button that does nothing when
clicked. It's always best to do any development work in the oldest version,
when you need to support multiple versions of Access.


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html

 

[BillD]

Thanks for the input Tom. I have printed out your information and will use it
when I install Office 2007

 

[Tom Wickerath]

Hi Bill,

You might want to see this new posting by Access MVP Albert Kallal, in the
Getting Started group:

http://www.microsoft.com/office/com...rted&mid=6cbe0041-b17c-4b0c-a70b-77952dc88527

It contains two links to training videos available on-line.


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________