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
 

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

Back
Top