Table Update

[Dan @BCBS]

The MS ACCESS data base tables are linked to SQL db's.

I need to add a record to a table, the table is not allowing updates, the
table is linked to a View in SQL. Could you please tell me how to allow
updates...

Thanks

 

[Ofer Cohen]

Is it a table or view?

If it's a view, you can't update it. You need to update the tables directly.

If it a table that you can't update, check the permissions on that table,
also check if a Key defined in that table, if there is no key defined in it,
when it's linked to the MDB you won't be able to add new records to it.