Adding Editing thru adp

  • Thread starter Thread starter JA
  • Start date Start date
J

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
 
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.
 
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.
 
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.
 
JA said:
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
Click to expand...
 
Back
Top