Question Cannot Convert from 2000 to 2010 (1 Viewer)

[Toff]

I have a 2000 database that just will not convert over.

Nothing is open. No one is in it besides me. No linked tables or anything fancy.

I'm doing:

Save and Publish
Save Database As
Access Database (*.accdb)

I then hit Save As and it asks me if I would like to close all objects. I say yes, specify the save location and name and then it tell me "Could not use "file location and name is here"; file already in use.

Anyone have any tips?

Microsofts site was no help.

Thanks in advance.

 

[boblarson]

The way to ensure all works well is to create a new 2010 database file (blank) and import everything (including any applicable options in the options on the import dialog). You'll have to reset your startup options but it is the most consistent way I've found of converting a database to the 2010 format.

 

[Toff]

Thanks Bob.

I should have thought of that.

 

[baghian364]

i have the exact same problem. i tried your method but got this error
"the object was saved in invalid format and can not be read"
then another error
"110 errors occured when you loaded the form or report"
then
"no current record"
then
"the search key wsa not found in any record"
rest happens smoothly and seems alright until i try to edit some form like adding a new button. the error pops up saying
"the data can not be readbecause the VBA project contained in itcan't be read. database can be read onlyif VBA project is first deleted....."

 

[boblarson]

baghian364:

Are you on Windows 7 SP1 or using Office (or just Access) 2010 SP1? If so, it is an ADO compile issue because the registry keys changed in the SP1s of those.

If not, then you may have a corrupt database.

 

[Toff]

To get my old ADO code to still work when I converted from 2000 to 2010 I had to add an ActiveX Reference.

Get in a module, then Tools/References, then check "Microsoft ActiveX Data Objects 2.7 Library".

Hopefully it will work for you also.

I do not have Office 2010 SP1 installed as it doesn't like my databases at all.

I do have Win 7 SP1 installed.

 

[baghian364]

thnx alot.
i hav alrdy found a soltn i.e wen u convert from 2000 to 2010 format, VB code needs to be compliled and that is it.