Access 2007 convert to access 2003

S

Stan

I have 2007 database that I wish to save as 2003, so that my colleagues can
use it. I have downloaded the conversion tool. However when I click on the
save as tab on the ribbon, All the formats are greyed out and I can not save
it. If I change the suffix 2003 looks at it but can not open it.
Help please
 
A

Allen Browne

1. Go to:
Office Button | Access Options | Populate
and set the Default File Format to Access 2000 format.

2. Create a new database:
Office Button | New
It will be in A2000 format.

3. Open the new database, and import everything.
Click the External Data tab of the ribbon, and the Access icon on the Import
group.

You now have a database that can be opened and manipulated in Access 2000,
2002, 2003, or 2007.
 
L

LBC

I have developed an application in ver. 2003. A customer want to use this
application in Access 2007. Is it possible that my customer uses it and
frequently returns the database to my and I make corrections in my ver. 2003
and then returns the corrected database to the customer. Briefly: Can you "go
back" in version number?
 
P

Paul Shapiro

You don't have to go back in version number. Split the db into 2 databases:
a) a front-end db with all the forms, queries, code and reports, and b) a
backend db with just the tables and all the relationships. Now your customer
owns the backend, with their data. You can replace the frontend with an
updated version, without needing to get the latest data from the client.

If you keep building in Access 2003, it will remain an Access 2003-formatted
database, which your client should be able to use in Access 2007. If there
are some issues, you can probably fix them in your master version of the
front-end db.
 
Top