0

Recently I am not able to run queries from my Access either 2002 or 2010 (Both installed on my laptop). When I try to execute any query , even simple ones , Access hangs and then not responding.

Scorpion99
  • 248
  • 4
  • 15
  • 1
    On all databases, or just one in particular? Corrupt db, maybe? – Lynn Crumbling Sep 12 '14 at 13:30
  • I already tried compact and repair.Didn't try it on other databases – Scorpion99 Sep 12 '14 at 13:35
  • Try other dbs. If issue persists, reboot and try again. If still persists, reinstall Access/Office (especially if you've recently installed new software). – Lynn Crumbling Sep 12 '14 at 13:38
  • I have to ask - are the databases on a network or anything? You said Access is installed on your computer, but I'm not sure about the location of the actual database files. – Mark C. Sep 12 '14 at 13:59
  • same problem on all dbs.Reinstalling office didn't help.All dbs are on my local drive. – Scorpion99 Sep 12 '14 at 14:01
  • Try the reverse -- if you take your db to a different box, does Access happily execute the query? If so, something on your box is trashed and (if possible) you need to call in IT services. It very much sounds like you're going to find out that your box is the problem, not the db (which, I suppose, is a good thing.) – Lynn Crumbling Sep 12 '14 at 19:05
  • After testing dbs on other machines , they work fine, but I noticed the following: on my laptop queries are fine with local tables but the queries which hangs are connected to Linked tables from SQL. These tables CAN be opened normally from my access db. – Scorpion99 Sep 12 '14 at 19:41

2 Answers2

0

Check if there are other processes that might be consuming all your machine's CPU/RAM: http://technet.microsoft.com/en-ie/sysinternals/bb896653.aspx

Also, did you try to create a new database, populate a test table with some test data and run a simple SELECT statement to see what happens? Did you try to open this database in another machine?

Did you try to turn it off and on again? :)

the_marcelo_r
  • 1,847
  • 22
  • 35
0
  1. Try compact and repair the db.
  2. If it still does not help try to uncompile the db. (see: How does one decompile and recompile a database application?)
  3. Type Alt-F11 (opens VBA), go to menu Tools > References, check if there are faulty references and repair them if necessary.
  4. If it does not help try importing the faulty db objects into a new empty db.
  5. For Access 2002 (I don't know for 2010) execute menu Help > Detect and repair (repairs the Office installation. May sometimes be necessary if you switch between different Access versions and after Windows Updates.)
Community
  • 1
  • 1
Olivier Jacot-Descombes
  • 104,806
  • 13
  • 138
  • 188