[AccessD] Link to back end that has ODBC links

Jim Dettman jimdettman at verizon.net
Mon Mar 17 15:26:51 CDT 2014


Wow, a blast from the past...

Each FE needs to link separately.  I would suggest DSN-less connections if
possible (all required ODBC info is in the tabledefs connect property).

Jim.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Steve Erbach
Sent: Monday, March 17, 2014 03:23 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] Link to back end that has ODBC links

Dear Group,

Long time...

My wife, Janet, is doing Access 2007 work for a company in Manitowoc, WI.
She commutes once or twice a week, but is able to work from home otherwise
(it's about 40-45 miles away).

The company has an AS400 and their Access databases link to the AS400
tables via ODBC. Up to now, their Access apps have all been stored on
servers without being separated into FE/BE. Janet is beginning the process
of splitting the databases.

One big question, though: If an Access database has ODBC links to AS400
tables and she splits that database into front end and back end, will the
new front end be able to use the AS400 tables via the back end? Or does
each front end have to link to the ODBC tables separately and only link to
the Access tables in the back end?

I couldn't remember what was required, so I thought I'd ask y'all.

Regards,

Steve Erbach
Neenah, WI
-- 
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