Down grade an access 2007 db

[petebob796]

Anyone know any issues that would stop me down grading an access 2007 database. Someone up converted it without me knowing but I want it to be usable for people on older versions.

I went to save as access 2003 and nothing happened. My initial thought was recompile the vba code and do a compact and repair. I did this and still nothing happens. I hit save as access 2003 and nothing happens no error messages or anything (HELPFUL).

 

[Moniker]

Use your backup that hasn't been upgraded. Backups are... what's the word... helpful. If you don't have that helpful backup, you may be able to grab the objects within 2003 by importing them from the 2007 DB. You should be able to at least get the tables and queries. I'm not positive about the forms and reports.

 

[petebob796]

I was hoping there would be an easier suggestion the trouble with the backup is it's from 2 weeks ago I made a backup at the start of the week but that is again an access 2007 version which I hadn't realised. I have since changed many things. But I guess I will have to if no other suggestions.

 

[petebob796]

I modified a bit of vba code and what do you know it suddenly can be saved as 2003. This was just the addition of an if statement nothing was inherently wrong with the code I just wanted slightly different functunality.

 

[Moniker]

Pass on the knowledge to others. What code got modified that didn't allow an Access 2007 DB to be retrofitted for 2003? What did you do to make it work?