473,327 Members | 2,118 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,327 software developers and data experts.

Why is Access Counting?

2
Sometimes, when opening another form from my main form (via a button), the program will start counting records before opening the form. The count takes 5 or 10 seconds, goes to a count of around 300, and occurs intermittently. Does anyone have any experience with what is happening here?

Edit: Okay, this problem was described better by dgunner71 some time ago (See "Calculating..." showing in info bar at {almost} all times). There were 20 replies but no solution.... Tns71
DGunner71:
I have a MS database running in 2010 on a server that is running MS Server 2008r2.

When I open my database on this server, the info bar at the bottom of the screen just shows "Calculating..." at almost all times (when tables are open, forms or queries). The only times it does not show is 1.) when you put a form or report in design mode or 2.) when I first log in, I have a custom log in screen. This screen shows just fine (i.e. my field descriptions show up appropriately).

As soon as I log in, I'm getting the "Calculating...".

I've tried bypassing the log in screen by pressing shift and I still get the "Calculating...".

I've opened this exact same database on 2 another computers (1 - MS Access 2010 on Windows 7 and the second MS Access 2007 on Windows 7) - these appear to work just fine???

I did see a 2009 post on this but I did not see a solution.
Apr 18 '19 #1
7 1366
twinnyfo
3,653 Expert Mod 2GB
Do you have a screen shot of this that you could post so we can see what you are talking about?
Apr 18 '19 #2
NeoPa
32,556 Expert Mod 16PB
I would just make the point, since your question does refer to a main form, that this is clearly related to your project rather than Access per se.

If it were related to Access you'd be describing what happens when you open Access on its own.

That said, you tell us nothing about your actual project so we don't really have much hope of helping you further at this stage.
Apr 18 '19 #3
Luuk
1,047 Expert 1GB
Also when using Google (search for 'access calculating')

if found this page: https://social.technet.microsoft.com...um=officeitpro

The link above also has a general description of the problem 'calculating' occurring, but it also has additional info (the poster did upgrade from 2003 to a newer version...)

And, of course, no mention if the solution was found for this problem 😒
Apr 20 '19 #4
NeoPa
32,556 Expert Mod 16PB
I'm not sure that's overly helpful Luuk, but congratulations first and foremost on >1,000 posts :-)

All our members are advised to research their problems first before posting a properly-worded question here. As the question is quite poorly expressed I suppose it's not unreasonable to assume they also missed out the first and most important part before they even posted. Nevertheless we do try to discourage the type of post that simply suggests they look elsewhere for a similar question.

NB. It's perfectly valid to link to forums run by or owned by Microsoft as Access is a Microsoft product.

It looks like TNS has now updated their question so we'll have another look and see if there's enough there to work from.
Apr 20 '19 #5
NeoPa
32,556 Expert Mod 16PB
Let's take a step back here. Certainly a link to the other thread gives us something to go on, but, and it's a big but (No anatomy jokes here please ;-) ), there is still nothing from you to confirm that this is database related (as opposed to Access related). There's still nothing about your actual database.

More importantly, considering your introduction into the equation of DGunner's thread, nor is there any acknowledgement that a solution was suggested late on in that thread and what results you saw when you tried out that solution.
Apr 20 '19 #6
Tns71
2
The hot fix solution was for Access 2010. My dB runs under Access 2007, so the hot fix is not relevant and may not have actually fixed the issue, except coincidentally. In terms of describing the project, I don’t think that’s going to be particularly helpful. This is an access project which is operating on over 150 workstations/servers and the calculating issue is occurring on only two sites, both of which are on the same server. I do not have access to the hardware that this is occurring on. I was just hoping someone had a quick answer. It’s obvious that this has happened to other coders. It’s unfortunate that there doesn’t seem to be a solution out there.
Apr 20 '19 #7
NeoPa
32,556 Expert Mod 16PB
It seems more unfortunate that there's no real question out there. It takes you till now to explain you're running on 2007? To explain that it's only going wrong on two of the hundreds of PCs it's running on? You wonder why we struggle to be more helpful when you have to be prompted repeatedly just to get the basic facts of the situation into the thread.

No. There is no quick answer I'm aware of. We have been willing to attempt to help but it seems you've now decided, after only now sharing some of the most important information related to the question, that you know better and that it's nothing to do with your project.

That wouldn't be my conclusion but that's actually fine. You make your decisions and that's your responsibility. Good luck.
Apr 21 '19 #8

Sign in to post your reply or Sign up for a free account.

Similar topics

6
by: Elbert Lev | last post by:
Please correct me if I'm wrong. Python (as I understand) uses reference counting to determine when to delete the object. As soon as the object goes out of the scope it is deleted. Python does...
4
by: Alicia | last post by:
I am having a problem grouping by week. I am looking for the simpliest way of doing it in Microsoft Access. I have tried to use a pre-loaded calender, access did not like it at all. If there is...
1
by: mjobrien | last post by:
Thanks for the hint Allen (see below). But I am already doing that count as total records read (5)in the report footer. That count is unduplicated for the record not for the field - student ID as...
8
by: John Beeler | last post by:
I am a graduate student writing a thesis on a space in Indianapolis called the Circle. I'm trying to figure something out that would really help me out as I write this thing. I would like to...
18
by: ChadDiesel | last post by:
I appreciate the help on this group. I know I've posted a lot here the last couple of weeks, but I was thrown into a database project at my work with very little Access experience. No other...
32
by: William Stacey [MVP] | last post by:
Here is the link. If you find an issue or think of a feature, please post a reply or send an email. Cheers! http://www.mvptools.com/doco/csharp/semaphoredjikstra.htm -- William Stacey, MVP
4
by: aaronfude | last post by:
Hi, Please consider the following class (it's not really my class, but it's a good example for my question): class Vector { int myN; double *myX; Vector(int n) : myN(n), myX(new double) { }...
4
by: Dado | last post by:
I have a next situation with the textbox field: A - B = C 1. How to fill the A fill with the data from my previous recordset ? Can I do it with the expression builder ? 2. I want that every...
4
by: MLH | last post by:
MyString = "All men are created equal" Debug.PrintLen(MyString) Now that's easy. But how about just counting the letter "e"? Or, if I were curious to know how many commas were in the string....
0
meLady
by: meLady | last post by:
Hello, I have a form called feedback which has three columns and each cell in a column has a combo box that holds (Yes/No/Empty), and I want to count each column's value for example let's supposed...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.