Database Options Issue

[enilc]

Hello



I have a database that I've been using and updating for several years. It is split with a separate .accde front-end.

Microsoft® Access® for Microsoft 365 MSO (Version 2209 Build 16.0.15619.20000) 32-bit

After I make changes, I go into Options >> Current Database and turn off "Display Status Bar", "Display Document Tabs", and "Display Navigation Pane". Close and re-open db, then save as accde.

Been doing this for years with no problem.

The db has an opening 'splash' screen. It's just a form with a logo image. The only properties are "Timer Interval" 4000, and "On Timer" has a macro that closes the splash and opens the starting form. In Options >> Current Database , the "Display Form" is set to this splash form.

Yet again...years and no problem.

Today, after saving as above for accde and re-opening the splash form does not appear and the starting form does not open. I go into Options >> Current Database and "Display Form" reads "(none)". I set it to the splash form and close. Re-open Options and find that it doesn't take the change. Still reads "(none)". Cannot set "Display Form" to anything. I tried bypassing the splash and going straight to the starting form ("Client Finder") but the setting doesn't 'stick.' As soon as I close and re-open Options, the "Display Form" field is back to "(none)."

I believe it's an Access setting and not a database setting because I have daily backups of the .accdb. When I go back to versions from weeks or months ago, the splash screen opens the first time. But as soon as I go into "Options" and close out, the issue starts on that old version of the database.

However, I have tried opening from a different PC/different Access install and the issue persists there. So in that sense, it seems like it might be a db issue.

I've checked the code. No orphaned Sub anywhere. I've done 'compact/repair' and nothing seems to resolve the issue. Since I cannot set a start form, I'm kind of dead in the water as far as pushing out updates because any new version has this issue.

The issue I'm trying to resolve and cannot find anywhere: Options >> Current Database >> Display Form will not accept changes.

Any help greatly appreciated.

Steve

[Gicu]

Hi Steve, very weird indeed, maybe a recent update is causing this? I would suggest you try leaving the Display form as None and set it instead in an AutoExec macro.
Cheers,

[enilc]

Hi Steve, very weird indeed, maybe a recent update is causing this? I would suggest you try leaving the Display form as None and set it instead in an AutoExec macro.
Cheers,

Perfect. This accomplishes exactly what I needed.

Thank you!

[CJ_London]

I set it to the splash form and close. Re-open Options and find that it doesn't take the change.

you did save before close?