Updating large recordsets takes long time in ms access database Free videos chat rooms no cc or sign ups

06-Aug-2020 11:14

Just a tad frustrating in that we suspect MS has a hand in this and yet no true solutions.Worse is that MS hasn't even mentioned the issue one way or another and we all know that they surf sites like and others as a means of Bug hunting (IMHO a good practice as the bugs tend to show up in the forums long before they are reported to MS).

With Remote Desktop Services: It is better if each user has a local install of the Access program rather than running it from the server.Now every time I try to update the links, either Excel hangs or it takes something like 15 minutes. From your description, the problem appears to be the links. Is your memory usage (look at Task Manager) exceeding your available physical RAM? If you do, look at how many times VBA functions are called and how much time they take.Right now I am working on splitting the worksheet into four instances; where I will update four different Excel sheets in sequence. Once memory has to be swapped out to disk, things start to slow down a lot. VBA code that makes a lot of reference to Excel objects can be expensive.both servers are up-to-date with Automatic Updates.

my current guess is the server may have had a run-away process that caused the CPU or RAM to not allow Access to complete it's operations.."Calculating...". While looking around online I noticed that similar questions have been posted before, and none of them seemed to be resolved in a sense of finding a solution.

For example, went into design view on the form and the Design/Arrange/Format tabs were not there.

• Access to a network connecting thousands of people daily. Secure your username by registering in our chat room.… continue reading »

Read more

Online registration includes passing a small psychological test.… continue reading »

Read more