read-only problem

  • Thread starter Thread starter Educo Gent
  • Start date Start date
E

Educo Gent

I have sql server 2000 and a database on it.

I have made an adp-file in Access 2002 that is linked with the database on
the sql server.

All works fine. But I have the following problem: I have imported some
tables from an .mdb database in the .adp database. I can't add/remove
records in these tables in the .adp database because the data are
'read-only'. Can anyone help me?

PS: if I try to add/remove records with the SQL manager on the SQL-server:
no problem. In the .adp database, it's also possible to add/remove fields
(but no records) in the imported tables.

Thanks,
Hugo
 
I think I've found myself a solution: there was no primary key for the
imported tables.
 
Back
Top