some tables are read only

Martin · Feb 23, 2004

Hi,

I've got an adp database that I created from Access. Some tables I created
with the Access UI, and some with a SQL script executed via JDBC.

Some of the tables created via JDBC are read only in access, but some are
read-write. ie I can or cannot add/edit records in these tables.

What's going on?

Thanks
Martin

Douglas J. Steele · Feb 23, 2004

Do they have a primary key defined? If not, that's why they're read-only.

Martin · Feb 24, 2004

Thanks
Martin

Douglas J. Steele said:
Do they have a primary key defined? If not, that's why they're read-only.