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

importing access database

Forum home » Delegate support and help forum » Microsoft Access Training and help » Importing Access 2007 database to Access 2003

Importing Access 2007 database to Access 2003

ResolvedVersion 2007

Fiona has attended:
Access Introduction course

Importing Access 2007 database to Access 2003

Is it possible to import an MS Access 2007 database into Ms Access 2003 with all the field qualities intact?

RE: Importing Access 2007 database to Access 2003

Dear Fiona

Thank you for attending Access 2007 Introduction course!! I hope you enjoyed the course and benefited from it.


It is important to understand that there is no backward compatibility with Office packages.

If you are in Access 2003 and trying to import Access 2007 database object most probably you will not be able to do that.

You best bet would be to open the database in Access 2007 and then use the export option. This will allow you to export in older version. If you need help in how to export or import in Access 2007 please let me know and I should be able to provide you step by step instruction.

I hope this has answered your query.

If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!

Kindest Regards


Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007
MCT

Mon 13 Apr 2009: Automatically marked as resolved.

Access tip:

Splittng a database

Split your database into two (at least).

Keep all of your code, forms, reports, etc. in one 'code' database and all of your tables in another 'data' database which is then linked to the 'code' database.

This makes modifications, updates and back-ups that much easier and allows you to work on a new version of your 'code' database without affecting existing users. It also makes it easier should you wish to convert a single user databases into a multi-user networked version.

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.