Reading VBA code

[ksammie01]

Hi, i had a database, which i split into BACK END(BE) and FRONT END(FE).
BE opens just fine, but, FE, stopped working, non of the forms or reports works when the database opens.
However, before it opens, i get this error message

"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."


i have read content but non of them seems to make sense.
I am using access 2007
any help, will be highly appreciated
Thanks

[RuralGuy]

Hopefully you have a copy of the db *before* you split it. I would *import* the FE into a fresh new db and see if the problem follows. Is it accdb or mdb?

[ksammie01]

its accdb, and i don't have a copy before i split the database, but i can check to confirm.

[RuralGuy]

Here's pictures of *importing* the db into a fresh new db: http://www.btabdevelopment.com/ts/impnew

[ksammie01]

So, i have tried to do the import, of the FE, into a new DB, like in the tutorials, but i get an error message, , and then it suggest that i repair the database, via manage, then compact and repair, but it still says the file am trying to repair is corrupt, and then complains about the VBA macros

[RuralGuy]

Make a backup. Do you get the same error when you try and open while holding down a <SHIFT> key?

[ksammie01]

yes,,it does the same thing, and then goes ahead to say that," the visual basic for applications project in the database is corrupt

[ksammie01]

then one more question, when u split a database with BLOBS(in this case images), are the images stored in the BE or the FE?
THANK YOU FOR THE HELP!!

[RuralGuy]

Did you let the *import* try and recover the file?

[RuralGuy]

I think the BE but I've not tried it so don't really know.

[ksammie01]

The import, doesn't recover the file...
At this rate, do you think its advisable to just re-design the forms and reports queries and all that stuff in the FE??

[RuralGuy]

The import, doesn't recover the file...
At this rate, do you think its advisable to just re-design the forms and reports queries and all that stuff in the FE??

This looks like a good plan. Sorry.