Steve Erbach
erbachs at gmail.com
Wed Mar 19 08:20:54 CDT 2014
John, The task was small (only three workstations). During the conversion my wife discovered that one of the AS400 tables had more than 32 indexes, which is the Access limit. As I wrote to Jim, these AS400 tables often come in sets with the same data in each of several tables, just in different sort orders. I believe that they picked one of those sort tables and were able to change the Access code in just a couple of places to reference the different table name...though now that I think about it, they could probably have simply renamed the linked table in the Access front-end, n'est-ce pas? No biggie; I'm not terribly involved other than to offer her instant messaging advice during the day. Thanks for your reply. On Mon, Mar 17, 2014 at 4:27 PM, John W Colby <jwcolby at gmail.com> wrote: > AFAIK the FE will split off with the old links to the AS400 intact, and > new links to any native Access tables stored in the new BE. > > John W. Colby > > Reality is what refuses to go away > when you do not believe in it > > > On 3/17/2014 3:22 PM, Steve Erbach wrote: > >> 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 >> > > > --- > This email is free from viruses and malware because avast! Antivirus > protection is active. > http://www.avast.com > > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > -- Regards, Steve Erbach Neenah, WI http://www.NeenahPolitics.com http://www.TheTownCrank.com