After DB move to new server cannot write data 1

[EMFSTL]

I have moved my DB to a new SQL 7.0 SP4 server. I restored the DB from the old server backup to the new (I have also tried the import feature). I recreated user logins and set security on DB identical to the old server(Public, DB reader/writer). I am able to read all data but not able to write data. I have tried making user DB Admin - no luck. Please Help!!

 

[Transcend]

How are you entering data? What errors are you getting?

Transcend

 

[tlbroadbent]

It sounds like you may have some orphaned users without proper permissions. Check out this link.

http://support.microsoft.com/default.aspx?kbid=274188

If you want to get the best answer for your question read faq183-874 and thread183-468158.
Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm

 

[EMFSTL]

I get no errors. I am able to click into a field and have the cursor move but when I try to type - it just beeps at me. Nothing else happens.

 

[EMFSTL]

Thank You. I checked this out before my post. I did have orphaned users. I have corrected them and still have issues.

 

[tlbroadbent]

What front-end tool are you using? If SQL Server Enterprise Manager, did you disconnect from the server and reconnect? If you want to get the best answer for your question read faq183-874 and thread183-468158.
Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm

 

[EMFSTL]

I am using MS Access.

 

[tlbroadbent]

Did you relink after moving the database? Does the table have a primary key, unique contraint, or timestamp column. Access requires this before updates are allowed in linked tables. If you want to get the best answer for your question read faq183-874 and thread183-468158.
Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm

 

[EMFSTL]

Thank You "tlbroadbent". That was the problem. A perfect response. Thread finished