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 |
|
acornkit
Starting Member
1 Post |
 Posted - 2013-09-05 : 18:54:28
|
| I am creating a new website ( http://www.pumpitupman.com/index.php ) which is almost identical to my existing website (www.SchoolShows.com). To create this new site, I simply copied the entire structure of the old site, SchoolShows.com. 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 SchoolShows.com. 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. |
|
|
LoztInSpace
Aged Yak Warrior
940 Posts |
Posted - 2013-09-06 : 01:15:43
|
| 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) |
 |
|
|
|
|
|
Can insert but not update