2003 Access to 2007 Access

[access2010]

The organization that I volenteer at would like to start a conversion of their Access 2003 Data Bases to Access 2007.

The organization has their main files in a folder on their server, which is shared by links on local computers.

Can I upgrade their main data bases on their server to Access 2007 and link their Access 2003 files which are on local machines to their Access 2007 files?

Thank you.
Nicole

 

[pbaldy]

I assume you mean the back end files. You probably could, but I suspect you'd have to save them as mdb files as I don't think the 2003 front end would recognize an accdb file. I'd do the opposite, convert the front ends first. The back ends would be relatively simple to convert. Heck, they'd probably all be easy, just opening and saving as accdb files.

 

[arnelgp]

you can leave the db format "as-is", just remove A2003 and install A2007 (preferably on all machines).
if you plan to "convert" the mdb to accdb, make a backup first of mdb (both FE and BE).

 

[access2010]

Thank you both for your comments.

Would you agree that we could convert the Back End, first which will be relatively easy, as no forms are required?

For the 2003 Data Bases that the users are currently using, I think that this will be more complicated as the charity's office uses about 18 separate databases and many forms.

Nicole

 

[isladogs]

No. As @pbaldy explained, A2003 MDB files cannot read ACCDB files created in A2007 or later.
Convert the FE first and, if you want to do so, convert the BE afterwards.
However you can keep the BE as MDB if you wish...as @arnelgp stated