Using /runtime slows database a lot

bignose2

Registered User.
Local time
Today, 05:20
Joined
May 2, 2010
Messages
251
Hidden Navigation pane SLOWS continuous forms refresh

Hi,

Running my DB with the Navigation pane (shutter) hidden make continuous forms display very slowly.

Whether closed in settings, Via VBA or simply not show because I have used /runtime.
Same on the accdb or the compiled accde.

It is the exact same database.
I assume must be some sort of bug but is same on two PC's. One Windows 10 the other windows 8.

Uninstalled some AV, I did find Malwarebytes really strangely messed with a split database with networked BE. (that was an odd one) while back.


Office 365 Access 2016 (Installed version, not online or anything)

I have a accde. It is a split database, local back end.
(compiled from my accdb)

I run using a windows 10 shortcut & has been fine but a few weeks back noticed it slowed down, can't rememeber when so not sure I can try or want to go back to using windows restore. Especially on 2 PC's.

Fully installed same MS office on both PC's.

It looks like it is refreshing the page 2 or 3 times (when I know it's not)
You can see the lines populate down the page, perhaps in under half a seconds but still noticable especially when 2 or 3 times.

If I run just testdatabase.accde
it is lightning fast, full page instant and only seems to do once, no refresh.

I want to open without the side menu & other design view stuff. Can't currently see a way to move close the pane on startup (not full hide)

-------

Just realized it is NOT the /runtime switch

If I simply HIDE the navigation pane from option/settings/current database, does it whether accdb or accde & without the /runtime switch.

Just minimizing to the left does not effect it, it still work fast.

this is really odd?!?

I have checked for updates - restarted etc etc.
Full repair install - still very slow


Any ideas?
thanks I/A
 
Last edited:
D'oh!!

SOLVED & feel rather stupid.

Removing the navigation pane made the continuous form window wider & brought into view a small text box that actually held a lot of data. I had it in a tiny box but still visible.
It seems that because it was trying to display this memo field perhaps 20 lines down it was struggling. If I drag the window to hide it is was finebut I now have hidden.

To be fair It did does not seem to do this on access 2010 for some reason, I have had this same form in operation for over a year & never have had this behaviour. Perhaps 2016 handles it a little different. either way pleased to have found cause.
 
Interesting observation, and well spotted.
 

Users who are viewing this thread

Back
Top Bottom