office upgrade

[jjosephson]

Hi Everyone,
I work in a small office where we are still using office 2003 pro. I would like to upgrade to office 360 2013 and I am wondering if I can safely convert my access tables, forms, etc. directly from 2003 or do I need an in between version 2007 or 2010?
Thanks.

 

[Trevor G]

Welcome to the Forum,

I would suggest take a copy of the database first then convert the copy and see if there are any issues. As we don't know the database in question it is hard to give you a clear concise answer. For instance:

Is the database using and VBA
Is the database connected to any other programs

 

[The_Doc_Man]

Trevor's advice is good. I'll say that between Ac2003 and Ac2013, some of the defaults changed slightly, so be very careful if you use recordsets. Used to be that DAO was the default for record access. Then it became ADO. If you always qualify your definitions, it will work. It is just that you might get some missing references.

 

[jjosephson]

Hi Guys,
Thanks for your input. My Access application is very basic, a table, one form created with the wizard, which has a few control buttons, search, print and exit. That's pretty much it. Just wondering if I open with 2013 will I have any trouble. Thanks again.

 

[Minty]

I believe you can't convert directly from 2003 to 2013.
However if your application really is very basic you might be able to import most of it.

To convert you will have to use either 2007 or 2010, then use 2013. The tools to convert an mdb to an accdb simply aren't present in 2013.

 

[jjosephson]

Thanks Minty, I've been trying to locate a copy of 2010 just in case.

 

[jjosephson]

Just to follow up. I installed office 365 2013. I opened my 2003 database and tried to save as .accdb. A pop up advised that I must first decode the database, which I did in the users and permissions option. I was then able to save as the 2013 format and all seems well. Hope it stays that way. Thanks.

 

[Minty]

That's interesting to know - thanks for the feedback.

 

[Trevor G]

Thanks for letting us know you have resolved the Thread.