Help wanted: 'Recordset not updateable'

  • Thread starter Thread starter ren
  • Start date Start date
R

ren

Hello,

When I open with Access 2000 a .DBF table and try to modify the content of a
(random) record, I get the message 'This recordset is not updateable". And
indeed, I can't change the content nor delete it.

However, when opening the same .DBF tabel with Access 2000, though installed
on another computer, I can change the content or delete the record.
Obviously this Access has other setting(s), but which??? Can anyone help me
out?
The Options are all the same, I've got all the rights.

Thanks in advance,
Paul
 
You must add new field in this table as autonumber field and create primary
key on
that field

regards,
CTaHk0
 
Hello cTaHk0,

I disagree because I don't have to add a new field if I'm operating with the
other Access

Paul
 
Is Access where .dbf recordset is not updateable single .mdb database or it
is Access developer project linked on some external database (SQL etc.)?
If first (.mdb) then you can import any table and modify records, bud if it
is a project (.adp), then you must create a primary key.

CTaHk0
 
Back
Top