Question Access 2007 Database to Access 2003

[davidjearly]

Hi all,

I have got a database solution that I need some help with. The main problem is that it was designed in Access 2007 and I need it to run in Access 2003.

When I try to convert the database, it tells me there are some features present which prevent it from being converted.

I know that two of these are:
Attachments field in one of the tables and on a form
Tabs on my main database form.

The database is used to store patient records and on the first tab of my main form, the individual details are there, but another tab holds details of their diet.

When I change a patient record on the first tab and move to the second tab, the diet details have reflected the change made on the first tab and display correctly for the selected patient. In other words, when a patient is selected on the first tab and I move to the second tab, the dietary requirements have been updated to reflect the current patient in the first tab.

How would I go about altering this database to make it compatible with Access 2003 so that when I select a patient record on my form I can then click on a command button to bring up a new form with the dietary details for that patient?

Also, is there any way to include an attachment feature within a 2003 database. This is not critical - just thought I would ask!

Any help would be greatly appreciated!

 

[HiTechCoach]

I would recommend that you create a new blank MDB in 2002/2003 format. I would then import all the objects and make any changes needed to get then to work.

You will also need to convert the back end to 2002/2003 format.


Going forward, I would do all the development within the MDB only and not in the 2007 format. This will help insure as much compatibility as possible without actually using Access 2003.

NOTE: You can use the same MDB with 2003 ands 2007 without any changes required.

is there any way to include an attachment feature within a 2003 database

You can write your own code to provide something very similar.