Help! DB cannot be opened - Wizard issue

[tearl42]

Greetings to all,


I'm hoping that someone can help me cause I'm frustrated ready to commit Harry Cary...


I'm starting with a completely blank DB. I'm trying to import an excel file and I'm getting the following errors...


"The database cannot be opened because the VBA project contained in it cannot be read. The database can be opened only if the VBA project is first deleted. Deleting the VBA project removes all code from modules, forms and reports. You should back up your database before attempting to open the database and delete the VBA project.


Click Ok to make a backup of the database or cancel if you do not wish to back up"


I click cancel since there isn't anything in the DB yet and get the next error...


"Microsoft Access can't find the wizard. This wizard has not been installed, or there is an incorrect setting in the Windows Registry, or this wizard has been disabled.


So I go in to look and see if there is an issue in the Add-Ins Manager and I get this error...


"The database cannot be opened because the VBA project contained in it cannot be read. The database can be opened only if the VBA project is first deleted. Deleting the VBA project removes all code from modules, forms and reports. You should back up your database before attempting to open the database and delete the VBA project.



Click Ok to make a backup of the database or cancel if you do not wish to back up"


Click Cancel and the get this error...


"The wizard you've requested is not installed or is in a bad state. Please install or reinstall the wizard. If you do not have premission to do this on your computer, please contact your help desk representative."


I have uninstalled Access and Reinstalled, I have looked up and applied KB2581301. I have screamed, cried and begged... Still nothing. Anyone know what's going on and how to fix it?

Thanks,

Tom

 

[vbaInet]

Not seen it before but you can upload your db and we'll give it a quick try.

 

[tearl42]

See that's just it, it doesn't matter what database. It's a new database that I'm just trying to import the data from excel. I've tried a 2010 database and. 2003-2007 database. I just don't get it...

 

[vbaInet]

We have nothing to go on. We will need to see the db.

 

[tearl42]

Ok, here ya go...

Thanks,

Tom

 

[vbaInet]

So I've just opened the db with success. What is the problem? Can you upload a sample excel sheet that's failing when importing.

 

[tearl42]

Here is a test and the actual... Both have the same results as explained in the original post.

 

[vbaInet]

I've just successfully imported both spreadsheets without any glitches.

Did you test it with the database you posted?

 

[tearl42]

Yep, I tested with both of them. Here I have attached a video of what exactly is happening. Sorry for the messages being cut off, it was hard to get a desktop video that showed what was happening under 2 meg.

 

[vbaInet]

Interesting problem you are experiencing there. I followed the exact same steps and still managed to import from that xls. It seems the import dialog is confused as to what kind of object is being imported. I suspect it's an application error.

Have you tried using the DoCmd.TransferSpreadsheet command via code?

 

[tearl42]

Interesting problem you are experiencing there. I followed the exact same steps and still managed to import from that xls. It seems the import dialog is confused as to what kind of object is being imported. I suspect it's an application error.

Have you tried using the DoCmd.TransferSpreadsheet command via code?

Nope, I don't know what that is...

Tom

 

[vbaInet]

You know how to create macros?

Also, do you know where to test code?

 

[tearl42]

You know how to create macros?

Also, do you know where to test code?

Yea, I know how to create macros, I just really suck at it.

No, I don't know about test code...

 

[vbaInet]

So, create a new macro and look through the actions, you should find a TransferSpreadsheet action.

Maybe this will help:

http://www.bluemoosetech.com/micros...le=Microsoft Access Transferspreadsheet Macro

 

[tearl42]

Ok so this turned out to be an issue with Access 2010 64-Bit. We were able to import the data from the sheets to the database with no issues when using 32-bit.

Thanks for your help...

 

[vbaInet]

Rather weird.

 

[woodym]

I need help with a similar issue. I have been using Access for years, and 2010 for a year and have never seen this problem before. I created a new database and went to design view for a table. I have a field for a zip code and want to create an input mask for it. When I click on the eliipsis to create the mask I get the same error code. I am using Access 2010 64-bit.

 

[tearl42]

Sorry dude, wish I could be more help. But I just uninstalled the 64bit version and installed the 32 bit. Problem went away.

 

[woodym]

Thanks, what is so strange is that I have been using it for a year and not one problem. Then this morning when I went to use it there it was.