problems accessing the SQL Server

[belovedcej]

I have developed an application on a test server. On the test server I am a DB Owner and my application runs just fine.

We have now moved the database to another server and made me a database owner for that one.

But when I change the connection in my adp project to access the new server, I have read permissions but no update permissions. Even if I start from scratch I have the same problem.


Has this ever happened to anyone? The programmers tell me it has to be an access problem because I am an owner on the SQL side. But I don't think so because it simply a connection.

 

[belovedcej]

Got it!! Another thread on this forum pointed out the need to redefine the primary keys. Simple but elusive solution.