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

access

Forum home » Delegate support and help forum » Microsoft Access Training and help » Access 1997 & 2003 Compatibility

Access 1997 & 2003 Compatibility

ResolvedVersion 2003

Tim has attended:
Access Introduction course

Access 1997 & 2003 Compatibility

I am doing a beginner Access 2003 Training Course. However at work we currently have Access 1997 (we going to move to 2003 in a couple of months).

What major issues do I need to consider to apply my 2003 training to designing and working with a database using Access 1997

Many Thanks

Tim

RE: Access 1997 & 2003 Compatibility

Dear Tim

Thank you for attedning Access Introductiuon course. I hope you enjoyed it and benefited from it.

As you may appreciate that Access 97 is a very old version. Normally if you were migrating from 97 to 2000 then you wouldn't have seen that many changes but from 97 to 2003 there have been quiet a few changes.

The good thing is that once you have fully migrated to Office 2003 in the near future then you can convert your 97 databases to 2003 without much problems.

I think the following link will help you with the known compatibility issues when migrating from 97 to other versions!!

http://allenbrowne.com/ser-48.html

I hope this helps. Please mark the post as resolved if I have answered your query.

Many thanks

Kindest Regards

Rajeev Rawat
MOS Master Instructor 2000/2003
MCAS Master Instructor 2007

Access tip:

Deleting duplicate records from a table

You cannot delete records tables where there duplicate records. A way around this is to create a new table which wont hold the duplicates. and then deleting the old table.

1. Use a make-table query based on this table only. IMPORTANT - Ensure that you include all of the fields from your original table or you may loose data.

2. Open the query's property sheet by using VIEW, QUERY, PROPERTIES, and set the Unique Values property to Yes

3. Because you have selected the Unique Values to Yes when you run the query, Access creates a new table without duplicate records. You can now delete the old table and rename the new one.

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.