Community
Showing results for 
Search instead for 
Do you mean 
Reply

ODBC connection to Access 2013

Astute Commentator
Posts: 45
Country: USA

ODBC connection to Access 2013

Greetings, I was wondering if someone had some experience connecting to the ACT data via ODBC table link in Access (2013 if that makes a difference).

I am currently running: Act! Pro Version 18.1.103.0, Update 3  on a Win10 Pro machine

 

I am looking to do a read-only link to the contacts field. I've tried, and can get as far as linking, but when I try and open the link, I get an error (ODBC call failed, conversion failed when converting from a character string to uniqueidentifier #8169)

Nickel Contributor
Posts: 235
Country: United_Kingdom

Re: ODBC connection to Access 2013

there is already a post like this on the forum  https://community.act.com/t5/Act-Premium/ACT-Premium-ODBC-Access-quot-quot-call-failed-quot-quot/m-p... and it mentions this error message appears when you try to convert an invalid character string to uniqueidentifier.

This might also help from the same post http://blog.glcomputing.com.au/2009/04/getting-table-structure-and-links-from.html

Astute Commentator
Posts: 45
Country: USA

Re: ODBC connection to Access 2013


chrisbunyan wrote:

there is already a post like this on the forum  https://community.act.com/t5/Act-Premium/ACT-Premium-ODBC-Access-quot-quot-call-failed-quot-quot/m-p... and it mentions this error message appears when you try to convert an invalid character string to uniqueidentifier.

This might also help from the same post http://blog.glcomputing.com.au/2009/04/getting-table-structure-and-links-from.html


Yes,  I looked through that prior to posting - the issue is, first off, I don't need to know structure (so the whole visio thing is not important). I know exactly which table I want to pull from and what fields already. Second, My version of ACT doesn't support actreader - so that also is a non-starter.

 

I did, however, develop a work-around. I linked an excel workbook via OLEDB (which works fine), then linked that to ACCESS as a linked table, then utilized VBA to update the excel workbook when Access opens, so the data is fresh. Not as clean as a direct link, but it works.