Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Can insert but not update
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Starting Member

1 Posts

Posted - 09/05/2013 :  18:54:28  Show Profile  Reply with Quote
I am creating a new website ( ) which is almost identical to my existing website ( To create this new site, I simply copied the entire structure of the old site, The SQL databases of each site have the exact same tables and fields. My problem is this: on the new site, I can successfully create and insert a new record, but after that I cannot update any records.

On both websites, I have compared the forms through which records are updated. The forms are identical. Since one form works and the other one does not, it leads me to conclude that the problem is not erroneous code in newly created form. If Form 1 works, and Form 2 is identical to Form 1, then form 2 must be correct as well.

Both forms use the exact same query.

This leaves me to conclude that there must be some difference in the structure of the two databases, and that perhaps, when I created the second database (manually) I might have entered something that was different from the original database for I have double–checked, and I cannot find any difference, but maybe I am missing something. What do you think? Do you have any advice or possible solution for my problem?

Many thanks.

Aged Yak Warrior

940 Posts

Posted - 09/06/2013 :  01:15:43  Show Profile  Reply with Quote
What error messages are you getting? At a guess I'd say your permissions or service accounts are wrong (you should probably have different accounts for the different sites)
Go to Top of Page
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.03 seconds. Powered By: Snitz Forums 2000