Add and update problem Access to sql server 2005

  • Thread starter Thread starter Gerry Everaert
  • Start date Start date
G

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?
 
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.
 
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:
 
Back
Top