Database Cannot be opened error

[santhosh23]

Hi

I have an access 2013 project in my machine, today I just swapped my machine with another high config machine which has Access 2013 installed in it. But when i tried to open my database i got the below 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 module,forms and reports. you should back up your database before attempting to open the database and delete the VBA Project. "

To Create a Backup copy, click cancel and then make a backup copy of your database. To open the database and delete the VBA project without creating a backup copy, click ok.

Anyhelp is appreciated ..thanks in advance

 

[llkhoutx]

Make a copy of your database, then do as the message suggests on the original, not the copy.

 

[mattmyers789]

Make a copy of your database, then do as the message suggests on the original, not the copy.

And then what? I having this issue as well. Doing what it says just clears all your vba code out and you still can't access the code in the copied one.

 

[llkhoutx]

If you can't open the original or a copy, you're toast.

I'd create anew blank database and try to import all the "bad" database objects. Maybe you'll get some code. If unsuccessful, try importing from the copy.

I've experience total failure before. It makes the case of backing up you program, frequently. My Access 2007 programs used to crash frequently and corrupt the font end. Search this site for "database corruption" or merely "corruption."

 

[speakers_86]

You should do the steps David Fenton describes here once every day or so. Also, make backups frequently. Especially anytime you make large changes, whether it be to code or to objects (such as deleting a form!).

Also, email yourself all necessary files regularly.

 

[santhosh23]

@IIKhoutx , @mattmyers789 ,@speakers_86

Thanks for your comments..I tried backing up the db and follow as directed , but i guess this method is tedious as i have around 10 db. I thing the problem is database developed in 64 bit is not running in 32 bit office..so right now I am planning to remove the 32 bit and install 64 bit which i have, which should probably work ...let me give a try

 

[speakers_86]

Noooooo...you want 32 bit. Get rid of 64.

 

[santhosh23]

@speakers_86 ..

Yeah i tried the 64 bit but its not working... do you think i need to install 32 bit office now??

 

[speakers_86]

I've always seen people recommend against 64. Personally, I don't know one from the other. I've only read that you do NOT want 64.

 

[santhosh23]

@Speakers_86

Right now my db is working but the screen resolution and icons are shifted. I hope my previous lap was best and had no issues..