Anyway, on some of their forms the forms open and run extremely slowly for no apparent reason. There is one form which takes a long long time to open on everyone's computer but runs fine when it's there and there's another form that runs fine on most people's computers and is practically unusable on a few.
The forms have a few subforms on them and no VBA script running in the background that might cause an endless loop and I am stumped for ideas. I have turned auto namecorrect off and it came up on one of them saying "The recordset cannot be edited" because of some grouping on one of the text boxes but even when I worked my way around that it still ran just as slow.
You can tell if this is the cause of the problem if opening the first form is slow, and opening successive forms are not slow if you leave the initial one open.
This can happen if, for instance, you work on the front end on your test server, move it to the production environment and update the connect strings to point to the production back end. Updating the connect string doesn't refresh all the metadata stored in the linked table definitions, and there's no way to actually fully refresh them.
So, you have to delete and recreate the linked tables in the production environment. The symptom of this one is that in the test environment forms open immediately or in only a second or two, and in the production environment take a minute or more to open. After opening, they generally work just fine.
FWIW, I haven't really seen this problem except in the earliest days of Access when it was a significant and terrible problem that almost cost me a job my first A project. Slow-performing forms is more complicated to fix, but the cause is usually pretty uncomplicated: the forms are loading too much data at once. Forms with lots of subforms usually on a tab control and lots of large combo boxes are the usual culprit.
In a tab control that means loading the subform for each tab in the tab control's OnChange event. For combo boxes, you'd load them when they are displayed, or if they have too many records in them over , I'd say , don't load a rowsource until after the user has typed 1 or 2 characters using the OnChange event of the combo box.
It's a trade-off and you have to decide where you want your pain. Interesting how the same stories repeat themselves. I'm using MariaDB at home. Last edited: Oct 1, If you ask for space on a older server you are more likely to be granted permissions. The point being they can isolate you away from the main server.
I remember 20 years ago I was able to surf the directory of any server at our organization. No Mas, the new switches went in the firewalls went up and the new server software was installed. Everything changes sooner or later. When I faced that problem, I got the government manager involved and told him why we needed a file server for what we were doing.
Once he realized that my database's reports were driving a deliverable monthly document, he had a little chat with IT, who suddenly saw the light.
Sometimes the solution is to find the person who wants something that you can give him or her, then stand back and watch the fur fly. I've never used the latter. Does it offer any advantages over SQL Server? Local time Today, Joined Jul 21, Messages Originally a drop-in replacement, it has actually forked quite far now. Why use it over SQLServer express? Really, a case of what you're comfortable with. You must log in or register to reply here.
Similar threads J. Strange Performance Issue. Data Management. Tags: MS Access. Thanks in anticipation. Access is a network hog. Are they running all Gigabits? Greg Mules Posted August 21, 0 Comments.
Hope this helps Greg Mules. May your days get brighter and brighter, Jim P. Barbara, As Brett pointed out, Access is a data hog. Michael S. Mary Trounson Posted August 22, 0 Comments. Good luck, Mary.
Michael, I agree with the assessment that SQL and stored procs would be the better answer. Have them log out when not using it, or put a activity timer on. Archive some of your data if the tables have gotten too big. Randy Guber Posted August 22, 0 Comments. Definitely licensing fees. Luke Chung Posted August 22, 0 Comments. Register or Login. Welcome back! Reset Your Password We'll send an email with a link to reset your password.
Stay ahead! Leave a Reply Cancel reply Your email address will not be published. Like most sites on the Internet, this site uses cookies to collect data on usage comments, downloads, post views, etc… to improve your experience. By continuing to browse this site you consent to this policy. You assume the risks if you choose to try any of the code, samples, etc Close Privacy Overview This website uses cookies to improve your experience while you navigate through the website.
Out of these, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent.
You also have the option to opt-out of these cookies.
0コメント