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 |
|
holling
Starting Member
4 Posts |
 Posted - 2008-05-09 : 10:45:13
|
| Hi All -Recently I moved a MSSQL DB from one hosted DB server to another (same hosting provider, who was the one, in fact, who performed the move). After changing my datasource to point to the new server, I am able to connect and view the rows in my table, but unable to make any changes or add new rows.Any thoughts would be most appreciated!!Holling - (Access n00b) |
|
|
holling
Starting Member
4 Posts |
Posted - 2008-05-09 : 10:48:05
|
| PS. I AM able to update rows in the DB using a more direct method (tool similar to SQL Enterprise Manager). |
 |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2008-05-09 : 11:48:58
|
| access rights???lack of a primary key?? |
|
|
|
holling
Starting Member
4 Posts |
Posted - 2008-05-09 : 13:13:09
|
| AndrewMurphy -I've checked access rights, and the table does have primary key. The weird thing is that it worked just fine before the move, and we did not change any of the access rights or users. |
|
|
|
holling
Starting Member
4 Posts |
Posted - 2008-05-09 : 13:14:17
|
| Also, it doesn't throw any errors, just does allow input into table view or form view. |
|
|
|
|
|
|
Access Cannot Update a Linked SQL DB