some tables are read only

M

Martin

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
 
D

Douglas J. Steele

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

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

Similar Threads

Call stored procedure in SSMS from Access 2016 doesn't work. 0
ADP Error opening tables on SQL SERVER 2005 and Access 2007 5
read-only problem 1
Subdatasheet error on ADP projects in Access 2010 8
how to read RunSQL output 1
Can't create persistent ## tables with ADP call to a stored procedure(!?) 2
Ribbons In Access 2007 Adp 4
SQL Server tables in Access 2007 are read-only via ADP ! 5

Top