Add and update problem Access to sql server 2005

[Gerry Everaert]

I have SQL Server 2005 developer installed on a windows 2003 server. With an
MS Access 2003 adp I can connect to the tables of the database, I can see
the records, but I can not change or add records.
I also installed the same SQL Server on a windows XP profesional computer.
There the problem doesn't arise.
Suggestions?

 

[aaron.kempf]

i update records in ADP __ALLL___ the friggin time without a problem;
i'd need to know a lot more information to be able to help.

 

[gerry]

I misinterpreted the error. I forgot to give a table in the windows 2003
server database an primary key. So the records could not be updated in the
adp.
When I gave the table a primary key the problem was gone.
Thank you for your reaction.



"(e-mail address removed)" schreef: