Adding Editing thru adp

[JA]

Hi, I can connect to sql server 2005 using an Access 2000 adp, but I don't
seem to be able to add or edit records.

The tables I am trying to do this to do have primary keys, at least in Sql
server they do. Is there something else that needs to be done?

Thanks, JA

 

[Sylvain Lafontaine]

Probably that you have a permission problem on the SQL-Server or have it one
of these little exceptions that render a query or a table read-only. Other
possibilities would be that your ADP forms are read-only or that your
queries are too complexe and that you didn't inactivate the multi-step
procedure by specifying the UniqueTable and the CommandResync properties.

 

[JA]

Sylvain,

Thanks for your help, but I am still kind of lost. How would I check what
permissions I have on the SQL Server, or how would I check to see if the
table is read only? And if it is, how would I change them?

So far, I am just opening a table in the adp, and trying to add a new
record. The cursor won't even go to the new line.

Sorry, I'm not very good with SQL Server. And queries don't look to be
nearly as user-friendly as they are in Access, so I haven't even gone there
yet.

 

[Sylvain Lafontaine]

Hi, I don't want to be rude but if your intent is to work with SQL-Server,
learning some basic knowledge about SQL-Server would be a plus here.

If you have a full access to this sql-server installation, you can try using
with the sa account in order to make sure that you don't have a permission
problem but my best recommendation would be that you learn first some basic
knowledge about SQL-Server.

 

[mark]

Hi, I can connect to sql server 2005 using an Access 2000 adp, but I don't
seem to be able to add or edit records.

The tables I am trying to do this to do have primary keys, at least in Sql
server they do. Is there something else that needs to be done?

Thanks, JA