ODBC linking problem

[Alex Paradi]

Hi there.

I'm using win XP and Access 2000.

I'm trying to create a report that is based on my Simply
Accounting file. I can do this using Crystal Reporting
(that comes with Simply, but Crystal doesn't seem to let
me email my reports automatically).

In Crystal Reporting I can import the tables by selecting
ODBC and then I see a list of a bunch of different files
and I can select my specific Simply Accounting File and
then the specific tables.

In Access when I try to link - I set the file type to ODBC
and I get the Select Database Source pop-up. I click on
the Machine Data Source tab and I get the same list that I
saw in Crystal Reporting. However, when I click on a
simply accounting file I get the "You can't use ODBC to
import external Microsoft Jet or ISAM databases"

Anyone know what I need to do in order to link to a Simply
Accounting file?

Thanks for your time in advance!

Alex

 

[Alex Paradi]

bump - please help if you can!!!

 

[John Nurick]

Hi Alex,

I've kept my head down because I've never used Crystal Reports and never
heard of Simply Accounting, but I guess that the message means more or
less what it says.

If Simply Accounting uses the Microsoft Jet database engine (which is
probably true if its data is in an mdb file, and may be true even if the
file extension is not .mdb), Access won't be able to link to it via ODBC
(see e.g. the links below). Instead, you need to use DAO or ADO or some
such (though custom security and/or encryption in Simply Accounting may
defeat this).

The same is true for other data file formats for which ISAM drivers are
supplied (text, spreadsheet, older dBase and Paradox).


Accessing External Data with Microsoft Access
http://msdn.microsoft.com/archive/d...mAccessingExternalDatawithMicrosoftAccess.asp

Setting Connection String Parameters in DAO
http://msdn.microsoft.com/archive/d...nnectionStringParametersinMicrosoftAccess.asp