Linking two Access databases through ODBC System DSN

  • Thread starter Thread starter Vikas Sahdev
  • Start date Start date
V

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
 
Vikas Sahdev said:
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.
Click to expand...

There is no work-around. Why would you "have to" use ODBC? Perhaps given
that someone can tell you where that notion is mistaken.
 
-----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.
Click to expand...

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
 
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.
Click to expand...

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