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

upgrade

ResolvedVersion 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

 

Training courses

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

Access tip:

Random sampling

Data is th key to a good database, therefore checking is essential.

A good way of checking data is by random sampling. You can do this in a query, by typing the follow:
1) In the Field box create a RandonID field eg. Randon Id: Rnd(fieldname])

2) sort the field
3)Right click and chage the properties for To value to be the number of randon records you want to see.

4) Change the set to Show row for Randon ID to be False, add all the other fields you want to see and the run the query.

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.