Unable to open front end

[mjdemaris]

Hello all,

I just split a DB that I had put plenty of time into, and now I cannot open the front end.

It is recognized as an accdb file, when I double click or press enter, Access opens to the 'Choose Your File' screen. It shows the file size as 7.25MB, has no password, not hidden or read-only.

I cannot open it "Exclusively" either.

i copied it to a network drive and tried to open with another computer, same problem.

Any ideas?

Thanks.

 

[theDBguy]

Hi. When you split your db, you probably moved your USysRibbons table in the BE. Move it back to the FE and try opening your FE again.

 

[mjdemaris]

How can I do that if I cannot open the FE?

Unfortunately, I did not back this up before splitting...never had this issue before and was going to back up after the split.

I just realized that I took a previous FE, developed on that, dumped the old tables, and split again. Not sure if this cause the problem I have, tho.

 

[theDBguy]

How can I do that if I cannot open the FE?

Unfortunately, I did not back this up before splitting...never had this issue before and was going to back up after the split.

I just realized that I took a previous FE, developed on that, dumped the old tables, and split again. Not sure if this cause the problem I have, tho.

It's really nice to have backups, sometimes. Cheers!

 

[isladogs]

Try each of the following in turn. Hopefully one or more will work
First make a backup of what you have now! Just in case!

1. Hold the shift button down as you open the FE database
2. Decompile the database to remove any corrupt compile code. See http://www.fmsinc.com/microsoftaccess/performance/decompile.asp
3. Import all items into a new blank database

Assuming you can open the FE after doing one or more of the above, recompile then compact.

Good luck

 

[mjdemaris]

Well, looks like this a do-over! Fortunately it's not a critical db and I get paid by the hour, lol.

Thanks guys!

Backup copies are a very good thing to have!

 

[isladogs]

Well, looks like this a do-over!

Not familiar with that phrase.
Does that mean you tried each of my suggestions with no success?

 

[mjdemaris]

Ahhhh, yes, the import worked.

So, lesson learned, and thanks again for the quick responses.

 

[mjdemaris]

And file back up made!