Linking two Access databases through ODBC System DSN

[Vikas Sahdev]

Hi,

I'm trying to connect two MS Access Databeses ,stored on
my C-drive, using ODBC and I get the error "You cannot use
ODBC to import from, export to, or link an external
Microsoft Jet or ISAM database table to your database".

Why not? Is there a way to work around? How?

I have to use the ODBC, it is necessary in this case.

Thanks, VS

 

[Rick Brandt]

Hi,

I'm trying to connect two MS Access Databeses ,stored on
my C-drive, using ODBC and I get the error "You cannot use
ODBC to import from, export to, or link an external
Microsoft Jet or ISAM database table to your database".

Why not? Is there a way to work around? How?

I have to use the ODBC, it is necessary in this case.

There is no work-around. Why would you "have to" use ODBC? Perhaps given
that someone can tell you where that notion is mistaken.

 

[Guest]

-----Original Message-----


There is no work-around. Why would you "have to" use ODBC? Perhaps given
that someone can tell you where that notion is mistaken.

The problem is that all the end-clients don't have a
network connection. The ones that connect to the SQL
server are OK using the ODBC connection but the ones that
don't have a network connection have a Access database
that simulates the SQL server. I want to use ODBC in both
cases for the end-users to follow similar steps while
accessing data through Access. I am setting this up for
someone who is teaching a data-mining course and he wants
a similar setup for all users.

Thanks, VS

 

[Douglas J. Steele]

The problem is that all the end-clients don't have a
network connection. The ones that connect to the SQL
server are OK using the ODBC connection but the ones that
don't have a network connection have a Access database
that simulates the SQL server. I want to use ODBC in both
cases for the end-users to follow similar steps while
accessing data through Access. I am setting this up for
someone who is teaching a data-mining course and he wants
a similar setup for all users.

Why not install MSDE (Microsoft Data Engine)? It's "SQL Server Lite", and
you use ODBC to connect to it as well.