Good morning.
I have a very large complex database I have been using for 9 months.
This database is split with a front end and backend. It has 3 tables linked to a server via ODBC.
I suddenly started having issues with this database. My ODBC Connection has become very slow and a query I used to run, normally would have taken less than an minute to run, is now running for more than 5 hours, and then I have to just shut it down. I've done everything I can think of, including getting a new hard drive, decompiling the data base, running all the checks and balances on my code, etc (I had not made any changes to the database in weeks, when this started happening) and can not find the issue.
I have created a new data base, and was going to import all the objects from the original database, when I noticed, even opening Access, with nothing in it... completely blank, it was taking 45 seconds to open... I'm not sure what the deal is. Thinking it may be permissions on my user ID, since I have a new hard drive? Thoughts on what could have happened, or questions for more info, or other things I could be checking for?
The database works fine other computers. Just this PC has the issue. Thanks in advance for your input!