Links changing to Read-Only

[CharlieT302]

Hello,

The company I work for has a dbase that uses table links to connect to data on their SQL server. Using Access forms, data on the server is updated. It works fine.

A week ago, however, the forms would not update the data. When we opened the links directly, the data was suddently read-only. The problem was with the links since the data could still be edited directly on the server.

Links in a backup copy of the dbase still worked correctly. We then copied the links from the backup into the current dbase. Once completed, they too reverted to read-only.

Finally, we decided to use a copy of the backup and import all new data into it. This worked.

My questions: why would the links convert to read-only? Why would copying link convert it to read-only? The links had been working for over a year before this happened.

Any thoughts?

 

[jadams0173]

My guess would be the properties/permissions of the database. I think they changed. With the old backup copy the changes weren't implimented therefore it worked as expected.

 

[CharlieT302]

That's very logical. I checked it out and no changes in permissions were made.

Is there anything else you can think of? We are drawing a blank on this.

 

[dhookom]

I wonder if Access could identify the primary key field(s) from the tables on the SQL Server. If you look at the tables in design view, these should be identified. If Access can't detect the key fields, then the data will be read only.

Duane
Hook'D on Access
MS Access MVP