How to convert Access 2007 to 2002?

[jdvon]

I have downloaded a neat MS Access 2007 template which has some extra functionalities.
The "save as" option in MS Access 2007 for saving as 2002 format generates a message saying the file cannot be saved in teh 2002 version - unless all the
attachments, complex data, multi-valued fields, offline data, links to external files are deleted.

I have gone to every form, table and query and deleted the said entities but still get the same message. The program gives no hint what they are or where to find them. I thought it would be neat if this happened automatically - the program should strip the complex data upon the conversion. But it has to be done manually.

Does anyone have an idea how to find the rest of the stuff to be deleted for teh conversion to 2002?

jd

[ADezii]

I have downloaded a neat MS Access 2007 template which has some extra functionalities.
The "save as" option in MS Access 2007 for saving as 2002 format generates a message saying the file cannot be saved in teh 2002 version - unless all the
attachments, complex data, multi-valued fields, offline data, links to external files are deleted.

I have gone to every form, table and query and deleted the said entities but still get the same message. The program gives no hint what they are or where to find them. I thought it would be neat if this happened automatically - the program should strip the complex data upon the conversion. But it has to be done manually.

Does anyone have an idea how to find the rest of the stuff to be deleted for teh conversion to 2002?

jd

If you feel as though you have efficiently cleaned house, try Importing all the relevant Objects in the Access 2007 Database into a New Access 2002 one. I've never tried this before and I'm not sure if it will even work, but it is worth a try.

[jdvon]

If you feel as though you have efficiently cleaned house, try Importing all the relevant Objects in the Access 2007 Database into a New Access 2002 one. I've never tried this before and I'm not sure if it will even work, but it is worth a try.

The import to 2002 worked - thanks for the tip!

jd

[ADezii]

The import to 2002 worked - thanks for the tip!

jd

Glad to be of assistance.

[NeoPa]

Just to clarify, and correct me if I'm wrong...
It should work if you use Access 2007 to open the 2002 version database and import from the 2007 database.
I would not expect this to work if you were trying to do this using Access 2002 (XP).

[ADezii]

Just to clarify, and correct me if I'm wrong...
It should work if you use Access 2007 to open the 2002 version database and import from the 2007 database.
I would not expect this to work if you were trying to do this using Access 2002 (XP).

That was exactly what I was thinking but apparently it is forward compatible in this instance which is kind of odd.

[NeoPa]

Odd...but good.
It's documented in here now anyway, which is even better :)

[wageslave]

Hi,

I know for most people on here that its probably pretty obvious what you had to do to strip the complex data manually and to import all the relevant Objects in the Access 2007 Database into a new Access 2002 one.

I'm a bit of a newbie to trying this though. I'm looking to use an Access 2007 template in work so I would be very interested in a more thorough run through of what you had to do. Would that be possible?

I know it might be a bit of an ask - if you don't have time perhaps I could just see how I get on and post any issues here? I won't get to try it till tomorrow night but any tips or things to loo out for would be much appriciated!

Thanks for your time!

Padraic

[NeoPa]

I can't tell you much more than is in here already without running through the whole process myself.
I suggest you try it out and post any questions you have if you get stuck.