Hi All.
I'm running windows XP Home edition, Access 2000 and Simply Accounting (SA) 2004 Basic - aka v8.5
I'm trying to use an ODBC connection to link to the SA tables in Access. There was already a connection in existance that worked no problem from Crystal Reporting - however, this link didn't work from Access.
I always get the response "You can not use ODBC to link to an external Microsoft Jet or ISAM database" (slightly paraphrased).
So I got an ODBC smarty-pants friend of mine to help me set up a new connection. This new connection also works from Crystal Reports but doesn't work from Access...
Anyone ever been successful linking to Simply Accounting from Access?
Thanks in advance for your time.
Alex
I'm running windows XP Home edition, Access 2000 and Simply Accounting (SA) 2004 Basic - aka v8.5
I'm trying to use an ODBC connection to link to the SA tables in Access. There was already a connection in existance that worked no problem from Crystal Reporting - however, this link didn't work from Access.
I always get the response "You can not use ODBC to link to an external Microsoft Jet or ISAM database" (slightly paraphrased).
So I got an ODBC smarty-pants friend of mine to help me set up a new connection. This new connection also works from Crystal Reports but doesn't work from Access...
Anyone ever been successful linking to Simply Accounting from Access?
Thanks in advance for your time.
Alex