MS Access Database running extremely slow all of a sudden

[tsansone]

Hello,

I know you probably hear this a lot. But my MS Access Database just started running to a crawl. But only with specific functions.

It is a two part database the front end (system) and back end (tables). The back end has all the data.

It is slow with three functions.

1. While opening a "Product" to edit (this is a POS (point of sale) / inventory management database) it takes a long time to open the form. Up until a few days ago it was almost instant. If i look at the status bar while waiting I can see "Calculating..."

2. While trying to open up a NEW POS record. Same thing with the "calculating"

3. While trying to add items to an invoice. Same thing... Calculatiing...

Our original designer isn't available. We have been running this database since 2011 without issue.

I am not a database programmer and don't know how to program or modify forms. I was hoping someone can take a look at the database. If you think you can fix it i would be willing to discuss.

Thanks for listening.

The link to the database files is: www dot mediafire dot com /folder /v4cix94enhfbl /Database --- for some reason i can't put a link in the post


There isn't anything proprietary or personal in the database that isn't public. We don't store payment information in this database.

 

[CJ_London]

Sounds like your forms have been saved with a sorting and/or filtering option. Open your form in in design view and remove any sort and/or filter properties (under the data tab)

 

[tsansone]

Sounds like your forms have been saved with a sorting and/or filtering option. Open your form in in design view and remove any sort and/or filter properties (under the data tab)

Thanks for the reply

Ok, i tried this but the result is the same but the database is a bit complicated so i don't know that i applied these on the correct form.

I went into the design mode for the form that is taking forever to load. i went to the data tab and changed "Filter on load" to No and changed "Allow filters" from Yes to no. But the result is the same.

 

[CJ_London]

did you remove the sort and/or filter properties?

Alternatively of the recordsource is just a table - did you remove the filter properties from that (open table in design view, right click and select properties)