M
Matt Fragale via AccessMonster.com
For some reason which is currently outside of my knowledge, one of my
databases is exhibiting an unusual behavior. The database has no data of
it's own and is linked to a couple other databases as back ends. Certain
of the tables suddenly tell me that their recordsets are not updateable
when I try to edit them. I noticed this when running an update process that
copies data from a text file into the tables. At first I thought the
import process had broken somehow. But when I go directly to the linked
table I cannot change anything there either.
When I go to the back end of the database and open it, Access says that the
database itself is Read Only. However, when I check the properties of the
database it is not listed as Read Only. Ahhhhh, permissions! I thought.
But alas, I have read/write/execute/delete permissions to the application
and the folder that it resides in. Interestingly, this is an intermittent
problem. It happened to me two days ago, but then worked later in the day.
It worked fine yesterday as well. Now this morning, it is not updateable
again.
We have relatively recently switched to Active Directory and Windows Server
2k3. I'm not sure if this has anything to do with it, but it has odd
effects on several things so I was thinking it might.
Has anyone ever run into a similar situation? Any ideas how to fix it??
It's frustrating because I have stuff that's due kind of early in the
morning and when this occurs, everything is late.
Thanks!!
databases is exhibiting an unusual behavior. The database has no data of
it's own and is linked to a couple other databases as back ends. Certain
of the tables suddenly tell me that their recordsets are not updateable
when I try to edit them. I noticed this when running an update process that
copies data from a text file into the tables. At first I thought the
import process had broken somehow. But when I go directly to the linked
table I cannot change anything there either.
When I go to the back end of the database and open it, Access says that the
database itself is Read Only. However, when I check the properties of the
database it is not listed as Read Only. Ahhhhh, permissions! I thought.
But alas, I have read/write/execute/delete permissions to the application
and the folder that it resides in. Interestingly, this is an intermittent
problem. It happened to me two days ago, but then worked later in the day.
It worked fine yesterday as well. Now this morning, it is not updateable
again.
We have relatively recently switched to Active Directory and Windows Server
2k3. I'm not sure if this has anything to do with it, but it has odd
effects on several things so I was thinking it might.
Has anyone ever run into a similar situation? Any ideas how to fix it??
It's frustrating because I have stuff that's due kind of early in the
morning and when this occurs, everything is late.
Thanks!!