Recent content by Eric Penfold

The problem is I am taking Data from another person`s Access Database and he is not keen on any interference with his work. I have created a linked Access Database to his but can I add an ID column with Primary Key to Linked Database?

This is a linked Access database does that mean you can`t have a primary Column? I think a primary Column is what I need is that right?

I have knowledge of VBA coding I am Based in Bristol UK I am new to Smart Sheet but I can see its potential.

I am trying to access smartsheet from Access Database through ODBC connection. It says ODBC-call failed.[1055]One and only one column must be primary. (#-1) can anyone say why and how to solve this issue, please? Look forward to an answer.