Database Corruption?

[cherokee]

Hi all,

I have a database split into FE and BE.

Did some VBA work on the FE yesterday, before leaving the office. This morning I go to open the FE and am told that Access has encountered a problem and needs to close without even opening the DB.

The BE on the other hand opens fine.

I suspect somehow my database has become corrupted somehow? I tried a compact and repair, to no avail.

Can anyone help?

 

[RuralGuy]

Can you get in by holding down a <SHIFT> key? Does everyone have their own copy of the FrontEnd?

 

[cherokee]

SHIFT Key doesn't work, and there's only one FE file at the moment - I'm the only person using the database....

 

[RuralGuy]

I hope you have a good backup. You can try importing everything into a new db but are likely to run into the same issue.

 

[cherokee]

I hope you have a good backup

Not quite the response I was after

Have only just started 'building' the database, so didn't have a backup yet - aside from a backup prior the splitting the database - could work from that but was hoping for an easier fix?

 

[RuralGuy]

Did you try importing everything into a new mdb?

 

[cherokee]

Did you try importing everything into a new mdb?

Yes, seems to have done the trick? Still none-the-wiser as to what happened to the original file though?

 

[RuralGuy]

And you just finished making a backup right? Call it lucky.

 

[cherokee]

And you just finished making a backup right? Call it lucky.

Yup - backed up both FE and BE files....

...Lucky is an understatement!

 

[EraserveAP]

Ran into this once or twice but never knew what the cause was. It would be interesting to know why this happens.