Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ColinD
Starting Member
40 Posts |
 Posted - 2007-06-14 : 04:55:20
|
| Hi,I have an Access database Front End which use SQL server as a Back End. The two are connected using ODBC. Occasionally, some of the linked tables in Access go read only. I can't add or edit records. The only way I know to get round the problem is to delete the link and re-create it. Refreshing the link does not work. Can anybody suggest why this would happen, and the best way to fix it when it does occur?Edited 12:10 06/14/07Some extra info. At the same time it goes read only, the link loses it's primary key.ThanksColin |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-06-14 : 13:30:49
|
| Why don't connect to sql table directly with proper connection string? |
 |
|
|
|
|
|
ODBC linked tables go read only