External data sources

[Guest]

Hi All,

I have a problem with a linked table form ODBC source.
In practice I can't change data in table and can't add any new row.
Access says that the table is read only, but it is a linked table and
so far I know it should reflect changes without any obstacles. (Am I
wrong?)

Does anyone know how to fix it?
Any help with solving this problem is appreciated

Some Tech details:
- Access 2007,
- admin privileges
- External DB: PostgreSQL,
- ODBC doesn't work in mode 'read only'

Kind Regards
Peter

 

[Guest]

solved - lack of an index in the source table


Kind Regards
Peter