Access 2007 is operating extremely slow after Office 2016 got installed!

Hi Experts,

We have an Access ADP project connected to SQL 2008 that was working fine on A2007.
Now since users upgraded their Outlook to 2016 suddenly everything is moving very slow.
For example just moving the mouse from control to control in form causes Access to pause for a second..

FYI- They are continuing with Access 2007.

PS. I know the right is moving to MDB ACCDB etc..however I'm desperately looking for immediate solution..

Any advise?
LVL 6
bfuchsAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Gustav BrockCIOCommented:
Different versions of Office work very badly together - if at all - on the same machine.

However, the runtime should work:

Access 2007 Download: Access Runtime

/gustav
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
bfuchsAuthor Commented:
Hi,

Will try that runtime.
Just wondering if opening Access with the runtime switch would do the trick?

Different versions of Office work very badly together - if at all - on the same machine.
This only happens to A2007-O2016, while on A2003-O2016 its fine.
Perhaps because ADP is saved with 2003 version file, as newer versions dont support it.


Thanks,
Ben
0
bfuchsAuthor Commented:
@Gustav,

For me looks like the runtime switch solved the issue.
However will wait for next week when users get a chance to test it.

BTW, Realized that all build in menus (like sorting/filtering etc..) are not avail at runtime, any solution?

Thanks,
Ben
0
The Five Tenets of the Most Secure Backup

Data loss can hit a business in any number of ways. In reality, companies should expect to lose data at some point. The challenge is having a plan to recover from such an event.

Gustav BrockCIOCommented:
Not that I know, except building the menus/bands yourself:

WYSIWYG Ribbon Editor for Microsoft Access 2007, Microsoft Excel 2007, Microsoft Word 2007

/gustav
0
Anders Ebro (Microsoft MVP)Microsoft DeveloperCommented:
You can add e.g. a popup menu for filtering, that uses the same commands that the "full" access version does.

Public Enum OfficeConstants 'For late binding
    Late_msoBarPopup = 5
    Late_msoControlButton = 1
    Late_msoControlPopup = 10
    Late_msoControlEdit = 2
End Enum

Public Function RuntimeRightClick()
' Purpose: Create custom right click menu

' Variables
    Dim cmbShortcutMenu As Object 'Office.CommandBar

' Err handler
    On Error GoTo err_handler

' Delete commandbar
    On Error Resume Next
    Application.CommandBars("DefaultRightClick").Delete
    On Error GoTo 0

' Create a shortcut menu named "MyShortcutMenu.
    Set cmbShortcutMenu = CommandBars.Add("DefaultRightClick", Late_msoBarPopup, False, False)

' Menu items
    cmbShortcutMenu.Controls.Add Type:=Late_msoControlButton, id:=210 ' SortUp
    cmbShortcutMenu.Controls.Add Type:=Late_msoControlButton, id:=211 ' SortDown
    cmbShortcutMenu.Controls.Add Type:=Late_msoControlButton, id:=12267 ' SortRemoveAllSorts
    'cmbShortcutMenu.Controls.Add Type:=Late_msoControlButton, id:=10068 ' FilterEqualsSelection
    'cmbShortcutMenu.Controls.Add Type:=Late_msoControlButton, id:=10071 ' FilterNotEqualsSelection
    cmbShortcutMenu.Controls.Add Type:=Late_msoControlButton, id:=10080 ' FilterContains
    cmbShortcutMenu.Controls.Add Type:=Late_msoControlButton, id:=10081 ' FilterDoesNotContain
    cmbShortcutMenu.Controls.Add Type:=Late_msoControlButton, id:=605 ' FilterClearAllFilters

    'cmbShortcutMenu.ShowPopup
ExitSub:
' Cleaning
    Set cmbShortcutMenu = Nothing

Exit Function
err_handler:
    MsgBox "An error occured. Contact Admin if error persists.", vbExclamation, "Error!"
    Resume ExitSub

End Function

You can then in properties for "Current database" set that the "Shortcut Menu Bar" is "DefaultRightClick".
0
bfuchsAuthor Commented:
@Anders,

Added that code to a public module, however not sure how to apply that.
You can then in properties for "Current database" set that the "Shortcut Menu Bar" is "DefaultRightClick"
See attached options I have in A2007 regular version.
while in A2003 I dont find this option.
And in A2007 runtime version I only see open and exit menu avail..
Also see second attachment msg I get when tried typing manually under Shortcut menu.


Thanks,
Ben
Capture.PNG
Capture.PNG
0
bfuchsAuthor Commented:
Hi Experts,

I would really appreciate if someone can help me with applying what Anders has suggested #a42388445 , as I proposed users with the runtime option & they refused to accept it since the right click options are not there..

Thanks,
Ben
0
Dale FyeOwner, Developing Solutions LLCCommented:
Ben,

You might want to take a look at the Access Shortcut Tool, which makes it easy to either copy the built-in shortcut menus or create your own.  You can then assign those new menus to the ShortcutMenu property of your forms, controls, and reports.

I've also written an article on using shortcut menus in the Access runtime, you might want to read that as well.
0
bfuchsAuthor Commented:
Hi Dale,

(From your article)
In versions of Access prior to 2007 there was a built-in mechanism for creating these shortcut menus, but when Microsoft released Access 2007, this feature had been deprecated (fancy term for removed), and has not been restored.
So this means if I use A2003 for design, then users of A2007 will be able to use these menus?

Thanks,
Ben
0
bfuchsAuthor Commented:
Hi Dale,

Your article prompted me to post the following..

https://www.experts-exchange.com/questions/29075356/How-do-I-create-a-custom-menu-bar.html

Thanks,
Ben
0
Dale FyeOwner, Developing Solutions LLCCommented:
If you have 2003 available to you, you can use it to create shortcut menus, and can then use the Get External Data feature of 2007 to import those shortcut menus from 2003.  But when running the import, you have click the Options button, and check the option for "menus and toolbars".

However, the ribbon has replaced the "menu" so you will not be able to use the actual menus, only shortcut (right-click) menus.
0
bfuchsAuthor Commented:
Hi Dale,

If you have 2003 available to you, you can use it to create shortcut menus,
This is exactly where I'm currently stuck with..
Since I never used custom shortcut menus yet, would like to know how to start, as posted in link above, I tried doing it thru customize but was not successful..

Thanks,
Ben
0
Dale FyeOwner, Developing Solutions LLCCommented:
Let me see if I have 2003 installed on a VM.  If so, I'll see if I can record the steps for you.

But I really encourage you to look at the Access Shortcut Tool.  It is extremely easy to use and you can either copy the built-in menus (and then delete the options you don't want to include) or build your own from scratch.

Dale
0
bfuchsAuthor Commented:
Hi Experts,

I got an answer for this at the other post, just waiting for users to test in order to finalize.

Thanks,
Ben
0
Dale FyeOwner, Developing Solutions LLCCommented:
Sorry, Ben.  I ended up going out of town over the New Years and did not get back to this.  I did identify that I no longer have 2003 installed on any of my VMs.  Did you look at the Access Shortcut Tool?
0
bfuchsAuthor Commented:
Thank you my experts!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Office

From novice to tech pro — start learning today.