| Author |
Topic |
|
mcordewener
Starting Member
19 Posts |
 Posted - 2005-12-06 : 10:59:13
|
| Hey there,I am trying to acces an SQL server instance. I can connect to the database and I can read the data. However in the same connection one table can be updated and another not. Does anybody know where I can look to fix the problem.Greetz,Marcel |
|
|
binggeli
Starting Member
20 Posts |
Posted - 2005-12-06 : 12:09:33
|
| More details, please.Could you provide the table code, too, for both tables? |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-12-07 : 01:44:49
|
| Did you mean Connection Strings?www.ConnectionStrings.comMadhivananFailing to plan is Planning to fail |
|
|
|
mcordewener
Starting Member
19 Posts |
Posted - 2005-12-07 : 02:58:37
|
| Yes, I am connection via MS Access to a SQL Server instance. Herefor I use the linked table function of MS Access. However when I use the same odbc connection, a system dsn, I can update one table and onther table is a read only table. The tables that can be updated do have a unique key and the other ones don't. I don't think this can be the issue. I think it is in the connection string. Does anybody know's how to modify the connection string created by MS Access in a linked table?greetz,Marcel |
|
|
|
mcordewener
Starting Member
19 Posts |
Posted - 2005-12-07 : 03:52:19
|
| Hi There,I have tried connecting to the tables when I updated these with a key. And then it works...Strange.Greetz,Marcel |
|
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2005-12-07 : 04:43:28
|
quote:
Originally posted by mcordewener
Yes, I am connection via MS Access to a SQL Server instance. Herefor I use the linked table function of MS Access. However when I use the same odbc connection, a system dsn, I can update one table and onther table is a read only table. The tables that can be updated do have a unique key and the other ones don't. I don't think this can be the issue. I think it is in the connection string. Does anybody know's how to modify the connection string created by MS Access in a linked table?greetz,Marcel
it definitely is the reason, add a PK and it woudl work. Also why are using access to connect? why not query analyzer. Works betterafrika |
|
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2005-12-07 : 04:46:45
|
dont understand this statement ?what works ?quote:
Originally posted by mcordewener
Hi There,I have tried connecting to the tables when I updated these with a key. And then it works...Strange.Greetz,Marcel
|
|
|
|
mcordewener
Starting Member
19 Posts |
Posted - 2005-12-07 : 04:58:58
|
| The reason why I could not update a linked table in MS Access is because there was no key defined in the table in SQl server. When I defined the key, I could update the content of the table.The reason I need to connect to SQL server is because I need to connect 6 MS-Access tools to sourcedata that is stored in SQL server.Greetz,Marcel |
|
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2005-12-07 : 12:46:45
|
| sorry i meant to say thats why its read only.have you tried to update the table in QA ? |
|
|
|
mcordewener
Starting Member
19 Posts |
Posted - 2005-12-08 : 03:54:06
|
| When I edit the table in SQL server or in the Query anakyser it works.But somehowe MS-Access needs a key in a MS-SQLserver table to make this table updateble. |
|
|
|
|
Connecting to SQL server using ODBC