Some DB really slow and Some works just fine

[jset818]

I recently created a database from scratch with over 30 queries and I don't know when but at one point, it became extremely slow. Opening,running, and saving a query would take a minute to load. If I click the Criteria field, it would sometimes take 2 minutes before I can type. I called the company IT help desk before, and they said it's not our servers, it probably has to do with Access itself. I have other databases on the same drive. linked with the same tables. And those work just fine. However, I didn't make those databases. Any ideas why it's like this?

[June7]

Have you run Compact & Repair? If that doesn't help, try importing everything into a new db.

[jset818]

Have you run Compact & Repair? If that doesn't help, try importing everything into a new db.

The Compact & Repair only took a sec to complete, not sure if that's normal. But that didn't help. How do I import everything into a new db?

[June7]

Create a new db file. Use the Import wizard.

If you want to provide db for analysis, follow instructions at bottom of my post.

[jset818]

Importing doesn't help either. I asked another co-worker to go into the db and see if it's slow for her, she said it's working fine for her. So I really don't know what the problem is.

Thanks anyway though.

[June7]

So something has changed on your computer.

I suppose you have rebooted at some time since the issue started?

Maybe uninstall/reinstall Access?

[jset818]

I believe I found the issue, although I'm not sure why it's only affecting me. But basically too many queries. I created a db, imported all of my tables and 6 queries that I'm currently working on and it's working fine. It's a shame I don't have a solution for this. I suppose I can work on the queries in my new db and then import it back in when I'm done with it.