UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Cannot Link Odbc Table, Access 2016    
 
   
dg_moore
post Dec 3 2019, 06:13 PM
Post#1



Posts: 362
Joined: 22-April 11



I created a sqlite3 table and linked it to my accdb. In looking at the result I saw that I had neglected to add a particular column to the table, so I deleted the link, added the missing column to the table, saved it, and attempted to re-link it to Access. The table is displayed in the Access Link Tables dialog, but when I select it and click OK the dialog closes but the table fails to link, with no error message displayed. Any ideas how to troubleshoot this?
Go to the top of the page
 
dg_moore
post Dec 3 2019, 07:05 PM
Post#2



Posts: 362
Joined: 22-April 11



I found the problem. An extraneous blank column was somehow inserted into the table. When I deleted it the table linked correctly.
Go to the top of the page
 
« Next Oldest· Access Q and A· Next Newest »
 
Display Mode: Standard · Switch to: · Switch to: Outline

Track this topic ·Email this topic · Print this topic · Subscribe to this forum

Custom Search


RSSSearch   Top   Lo-Fi    11th December 2019 - 10:00 AM