Adding Editing thru adp


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
 
Ad

Advertisements

S

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.
 
J

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.
 
S

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.
 
Ad

Advertisements

M

mark

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top