access won't let me edit queries

  • Thread starter Thread starter JimS
  • Start date Start date
J

JimS

I'm stumped. I've suddenly become unable to edit queries. I went in to make a
simple change to a query I've changed before (as in yesterday...), and
suddenly, I can add a new table to the query builder, but I can't drag a join
to the table. SQL view shows the table has been recognized.

So, I move on, and try to edit another query. I open it for design, and then
try to add a field to an append query. No add'l tables, no new joins, just
drag the field down to the list of fields, assigning it to a field within the
appended table. No dice. drop-downs are empty.

What's goin on? [Access 2003]
 
I'm guessing that the database is corrupted. At times like this, nothing
beats a good backup. In fact make a complete backup of your database now and
put it away for safe keeping.

Tony Toews has an excellent web page on database corruption.
http://www.granite.ab.ca/access/corruptmdbs.htm

Allen Brown also has excellent info on corruption.
http://allenbrowne.com/ser-47.html

I have a white paper in a Word document named Fix Corrupt Access Database
towards the bottom this page:
http://www.rogersaccesslibrary.com/OtherLibraries.asp
 
Back
Top