Non-editable query issue

[bill66man]

Hello,

I have an Ms-Access db that I use daily. It's not very big (4 mgs), and I have run into a problem. Every week or so I run a parameter query and once it returns the results, someone goes in and modifies some of the data. However, today it was discovered that the results are not modifiable. I run the query but can no longer make changes to the data (I get the standard Windows 'beep' when trying to make a change). I'm fairly proficient at Access, but I'm a novice when it comes to security and setting permissions. Or does it have something to do with the .ldb file? Can someone point me in the right direction to fix this? Thanks.

 

[boblarson]

Perhaps this will help:
http://allenbrowne.com/ser-61.html

 

[bill66man]

Hmmm...my query doesn't have a 'group by' or 'transform' clause, nor does it have 'distinct' in it , and it isn't a union query. I checked the permissions and it doesn't appear to be read-only. Recordset type is set to DynaSet. It is not a subquery. Any other suggestions?

 

[bill66man]

Nevermind. I got it fixed. I had added an additional table to the parameter query several days ago and even though none of the columns from that additional table had been added to the query, it still went read only on me. Removed the table and all is well.