ok so - problem solved! whoop
I recompiled the code in source ACCDB file - didn't get any errors - but this time SAVED after the compile. (I'm sure its the SAVE that did the trick)
When i saved AS ACCDE the DB worked as expected! :)
Strive4Peace shoud get the credit as haddnt thought of doing...
Thanks all the help :-)
I dont think its a bug from a windows upgrade -(remember the: Access error: "Query is corrupt" - in December update - yikes!)
.. its something in my code. Im working through DB changes to spot when it happens.
The compile code doesn't pick up on any errors -...
I look after a small MS ACCESS DB - we use office 365 and have latest updates on.
The DB loads with a Display Form: "frmLoginDialog" - this lets a user select their NAME and IMPORTANTLY - runs VBA command
Private Sub Form_Load()
DoCmd.ShowToolbar "Ribbon", acToolbarNo
Outlook works fast (and loads profile in 1 second - even when closed).
New emails create instantly.
The database is super quick. (lol)
The DoCmd works same speed with / without documents (i can see it seems to create document very quick)
I look after a small MS Access application where basic emails can be generated via a button click.
(sometimes with attachment and sometimes without)
When we use the DoCmd.SendObject method the email now takes between 20 to 30 seconds to 'pop up' - previously this was 1 to 2 seconds...
Im an SQL developer with 18 years experience.
Ive have various interactions with MS access over the years and have now moved into a role where im developing an Access Application for a small finance company.
Im hoping to be able to find some support through this forum - it certainly...