Unable to insert record

M

Me

I copied my sql server database onto another server to use with
Access Forms.

I changed the link to point to the new server, I am able to read the data
but I am unable to insert or modify records.

Any ideas what I may be doing wrong?

I am able to insert/modify the data using same user using Query Analyzer.

Therefore, there seems to be something to do with Access database.

Thank you,
-Me
 
Top