Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
MS Access - cannot edit a linked Smartsheet
I have an MS Access databases set up with the Data Connector. I can link to my spreadsheet and read it, but cannot edit nor append to it.
Normally, when linking via odbc to an external data source, MS Access will show a popup stating that the use must select from a list of the linked table's columns to act as a primary key IF MS access cannot determine the primary key before linking.
But when I link to my Smartshee, MS Access will not show that screen, and therefore it must recognize the _rownum_ column as the primary key (and in fact, when viewing the linked table's design inside of MS Access, _rownum_ shows as the primary key.
But I cannot edit nor append to the smartsheet. When an ODBC linked table is locked like this, it happens only whe MS Access cannot recognize a primary key within the linked table, and therefore appropriately locks the table. But in this case, there is a primary key, AND MS Access must be recognizing it as a primary ket because it does not display the "pick-a-primary-key" window before the link acutally takes place.
I am the Owner of mty spreadsheet and should have full rights to to the sheet, and I have looked everywhere in the Smartsheet side of things to see if there is something I can switch on or off to allow the sheet to be edited when it is linked to by ODBC, but I can find nothing, and there is nothing that can be done on the MS Access side.
What is the solution to being to edit an ODBC-linked SmartSheet from an MS Access database?