[AccessD] ODBC for Access

Stuart McLachlan stuart at lexacorp.com.pg
Fri Mar 18 18:41:40 CDT 2011


Correct. Trying to do so generates a 3423 error:
"You cannot use ODBC to import from, export to, or link an external Microsoft Jet or ISAM 
database table to your database."

-- 
Stuart

On 19 Mar 2011 at 12:19, Steve Schapel wrote:

> Ed,
> 
> As far as I am aware, this is simply not possible.  You can't
> establish an ODBC connection from Access to Access.
> 
> Regards
> Steve
> 
> -----Original Message----- 
> From: Edward Zuris
> Sent: Saturday, March 19, 2011 12:09 PM
> To: accessd at databaseadvisors.com
> Subject: [AccessD] ODBC for Access
> 
> 
> Hello Everyone,
> 
> It has been awhile.
> 
> I am trying to set am Access DB as an ODBC source
> and then link tables into another Access database.
> 
> I did something like that ages ago in Access-97,
> but seem to have forgotten how to do the same for
> Access 2000, or Access 2003.
> 
> Any suggestions on how to do that ?
> 
> Also is there a selection of ODBC drives out there ?
> 
> Thanks.
> 
> Sincerely,
> Ed Zuris.
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 






More information about the AccessD mailing list