Slow .MDE file when loading forms

[Cschmitt]

Good Day All!

This is my first time posting so a little about me. I've been thrown into a position to manage our database. What I know about Access/VBA/SQL has been self taught (Thanks Google!). I have been able to accomplish some design changes in the .MDB and create .MDE files for our users, amongst a few other little things. But on to my problem.

My .MDB file is located on a network location. The tables in the .MDB are linked to SQL. When I create a .MDE for my users, they report that it takes up to 30 to 40 seconds to load forms.

I have tried to put the users individual .mde on the users station, still pretty slow. I have tried locating the users .MDE files in the same location as the .MDB and giving the users a shortcut to their .MDE, still slow.

Any suggestion would be great! Thanks all.

[CJ_London]

these links may help

https://msdn.microsoft.com/en-us/lib...ffice.12).aspx
http://www.techrepublic.com/blog/10-...cess-database/
https://support.office.com/en-za/art...7-7a14addab6be

[Cschmitt]

Thanks for the info. Lots of good information,