I have the following requirements for an Access 2013 database:

Convert the 2008 Access database to Access 2013.
The 2013 database should be a desktop installation, not web.

Can you tell me and/or point me to links (urls), that will tell me how to accomplish the tasks that I just listed above?

• Moved by Lanlan HuangMicrosoft contingent staff Tuesday, May 19, 2015 2:10 AM

If the format is .accdb there really isn't much to do except open a copy in A2013 and compile it. Then Check for missing references and fix if necessary. I am guessing when you say A2008 you really m

Thanks for your reply!

I do have the following questions to ask you:

1. I need to convert an Access 2000 database to Access 2013 database. I incorrectly said Access 2008, Sorry! I basically opened the *.mdb and did I file save as '.accdb'and then the conversion happened. Is that correct or is there another way for the conversion to happen?

2. Since I have never worked with Access before, can you tell me how to do the following steps that you just suggested? 'compile it. Then Check for missing references and fix if necessary'.

**Note: I have vb.net experience working in visual studio, so I would understand what you mean by 'compile' and check for references. Can you tell me and/or point me to a reference on how to accomplish these steps?

1. I need to convert an Access 2000 database to Access 2013 database. I incorrectly said Access 2008, Sorry! I basically opened the *.mdb and did I file save as '.accdb'and then the conversion happened. Is that correct or is there another way for the conversion to happen?

2. Since I have never worked with Access before, can you tell me how to do the following steps that you just suggested? 'compile it. Then Check for missing references and fix if necessary'.

**Note: I have vb.net experience working in visual studio, so I would understand what you mean by 'compile' and check for references. Can you tell me and/or point me to a reference on how to accomplish these steps?

1) That is the method I use for convenience.

2) Compile is in the VBA Project. Before you compile, while the db is open just press ctrl + g to open the VBA project. go to Tools/References and note any references that have "missing". After you note these then deselect and re-select the correct references (usually you see missing next to a reference that has been replaced by a newer reference ie. you may see (missing) Microsoft Office 12.0 Object Library. Then you may need to unselect it and re-select something like Microsoft Office 15.0 Object Library) After selecting any you may need to select, then click OK to close the dialogue window. The Click Debug/Compile "Your project name". Close the VBA project window.

I suggest adding the Compact & Repair to your QAT menu and not use any automation with it. I have seen several databases ruined by that automation. Just when you are done working on database design changes and ALL database objects are closed then select the C&R in the QAT. You'll see a quick flash of the database window and then it is done.

Hth