upgrade

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Access Training and help » Upgrade from 2003

Upgrade from 2003

resolvedResolved · Low Priority · Version 2007

Craig has attended:
Access Introduction course
Access Intermediate course

Upgrade from 2003

We have a 2003 access database and we are upgrading the office to all the Office 2007 products. There seem to be some aspects of the 2003 database that when opened in Access 2007 do not seem to work properly. Is there anything we should be doing to the 2003 database before we open from Access 2007?

RE: Upgrade from 2003

Hi Craig,
Thank you for your post, sorry its taken a while to respond. To my knowledge if you open a 2003 database in 2007 you will see the Database Enhancement dialog box which allows you to choose to open the database and change it to 2007 or to refuse the Enhancement option which will not upgrade the database and deny you the opportunity to change any design features of the database, as this must be undertaken in the original/previous version.
I have enhanced a number of my databases and have not noticed any particular areas where there is an incompatibality issue, if this is the case where you are concerned please come back with more specifics and I will see if it is possible to assist you. Best regards Pete Emmerson Microsoft Office Specialiast Master Instructor


 

Access tip:

Hide Access Tables

One method of stopping your Access tables appearing in Database window, is to rename the table(s) with the prefix usys.

This converts the table into a system object, which cannot be viewed in the Database window.

You can show system objects in the Database window by the following:

Step 1: On the Tools menu, click Options.
Step 2: Click the View tab.
Under Show, select the System Objects check box.
Click OK.

View all Access hints and tips


Server loaded in 0.09 secs.