unable to modify data from a query

[evilman]

Hi,

I'm having this annoying problem with Access.
First off, I have a Query that works fine, no problems... until this morning.

I was able to open the query and modify the data in it. But since this morning, it seems that I'm locked out.
I have full permissions on the tables and the query itself.

I've decided to create a copy of this query, with the same tables, the same fields (I copy pasted the fields, to include the WHERE conditions) and the same properties.
Miracle! I can modify the data!

However, this problem seems to have spread to other queries!

Is there a solution to fix this or will I have to recreate all the "bad" queries.

Thanks..

 

[Mile-O]

Even easier would be to create a new database and import all your tables, queries, forms, etc into that - it should work.

 

[evilman]

hi, thanks for replying mile-o-phile

It seems that I have found what the problem was.
Its a bit weird though.

Yesterday afternoon (right before leaving) I added a column to one of the tables of that query.
It seems that this action triggered a built-in bug in Access, or something that prevented me to modify the data in the query... err anyway the fix is to cut (ctrl+x) the columns of the query in the clipboard, delete the "modified" table, then add the same table again and paste the columns back in the query... and it works!!

seems I'll have to do this for all the queries that were reading data from this table...