Missing MsysResources (1 Viewer)

Drand

Registered User.
Local time
Today, 16:46
Joined
Jun 8, 2019
Messages
179
Hi
After a Microsoft365 upgrade, my databases will not load reports. When I try to compact and repair I get a message that the MsysResources file is missing. I have copied the front end from another computer which is working fine but the error persists on my laptop.

Would appreciate any assistance.

Many thanks
 

theDBguy

I’m here to help
Staff member
Local time
Yesterday, 23:46
Joined
Oct 29, 2018
Messages
21,473
Can you physically see that the MSysResources table is there? Can you create a new blank database?
 

Drand

Registered User.
Local time
Today, 16:46
Joined
Jun 8, 2019
Messages
179
Can you physically see that the MSysResources table is there? Can you create a new blank database?
Yes I can create a new blank database. Where would I see the MsysResources table?
 

theDBguy

I’m here to help
Staff member
Local time
Yesterday, 23:46
Joined
Oct 29, 2018
Messages
21,473
Yes I can create a new blank database. Where would I see the MsysResources table?
You would see it in the Navigation Pane if you show the System tables in the Options settings.
 

Drand

Registered User.
Local time
Today, 16:46
Joined
Jun 8, 2019
Messages
179
Thanks

It doesn't show in the original db or the blank one I created.
 

tvanstiphout

Active member
Local time
Yesterday, 23:46
Joined
Jan 22, 2016
Messages
222
I have a hard time believing that. Show us a screenshot of your Navigation Options dialog.
 

Drand

Registered User.
Local time
Today, 16:46
Joined
Jun 8, 2019
Messages
179
1699062908931.png
1699062908931.png
1699062908931.png
 

Drand

Registered User.
Local time
Today, 16:46
Joined
Jun 8, 2019
Messages
179
Sorry, it does appear if I enable show hidden objects, however when I try to open it I get a message stating unrecognised database format
 

Gasman

Enthusiastic Amateur
Local time
Today, 07:46
Joined
Sep 21, 2011
Messages
14,299
I was just aboiut to say, you need to show hidden objects. :)
 

gemma-the-husky

Super Moderator
Staff member
Local time
Today, 07:46
Joined
Sep 12, 2006
Messages
15,656
Which version of access were your databases written in? Maybe they are not compatible with the current version.

Although the unrecognised format points to a corrupted database maybe.
 

The_Doc_Man

Immoderate Moderator
Staff member
Local time
Today, 01:46
Joined
Feb 28, 2001
Messages
27,186
Do you get the "unrecognizable format" message when opening MSysResources in the blank database you created?

If so, it might be good (if you can still do so) to roll back the M365 update one version and try again.
 

Users who are viewing this thread

Top Bottom