Unable to open front end (1 Viewer)

mjdemaris

Working on it...
Local time
Today, 07:15
Joined
Jul 9, 2015
Messages
424
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

I’m here to help
Staff member
Local time
Today, 07:15
Joined
Oct 29, 2018
Messages
21,357
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

Working on it...
Local time
Today, 07:15
Joined
Jul 9, 2015
Messages
424
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

I’m here to help
Staff member
Local time
Today, 07:15
Joined
Oct 29, 2018
Messages
21,357
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

MVP / VIP
Local time
Today, 14:15
Joined
Jan 14, 2017
Messages
18,186
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

Working on it...
Local time
Today, 07:15
Joined
Jul 9, 2015
Messages
424
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

MVP / VIP
Local time
Today, 14:15
Joined
Jan 14, 2017
Messages
18,186
Well, looks like this a do-over!

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

mjdemaris

Working on it...
Local time
Today, 07:15
Joined
Jul 9, 2015
Messages
424
Ahhhh, yes, the import worked.

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

Users who are viewing this thread

Top Bottom