Database calculating constantly

[rplohocky]

Recently my database has now begun to show "calculating..." in the lower left corner. Every time I click on any field on any form it does this. Any idea why this started all of a sudden?

 

[MarkK]

Are you running a timer?

 

[rplohocky]

Are you running a timer?

No, this seemed to come out of no where. The issue is every time I click in a field I have to wait about 8 seconds to click to the next field. I've seen online others having this issue but haven't found anyone that can answer why its happening.

 

[CJ_London]

is your db multi user? split?

Do you recall any changes that might have occurred around the time this started happening? Not necessarily changes to code, but perhaps you have changed servers, added a bunch of new users, added a large amount of data, now working off a front end located on the server?

 

[rplohocky]

is your db multi user? split?

Do you recall any changes that might have occurred around the time this started happening? Not necessarily changes to code, but perhaps you have changed servers, added a bunch of new users, added a large amount of data, now working off a front end located on the server?

The DB that has this issue is NOT split. I work on this DB for updates and then move it and split it. So this issue is happening before I split. I've made some mod's to it but nothing big, just a new form and a few queries and reports. I am running the same DB on another network and its split. Seems to not have this issue.

 

[CJ_London]

I've made some mod's to it but nothing big, just a new form and a few queries and reports

size does not necessarily come into it.

Suggest go back to a backup - or take a copy of the latest distributed front end and add your changes one by one until the problem reoccurs