Are all of the tables visible in the DB's main window (with the tabs)? If they're hidden, that may be the cause of this problem. Check that all of the tables are visible when you try to do the linking. Hope this helps!
Alienwebmaster --- In [email protected], "bitschon" <[EMAIL PROTECTED]> wrote: > > I'm trying to link to an informix table called > loy_customer_events. > > > When I try to link to it, I can not find it. > > If I use a freehand query tool, I can query against it, but when I > look in the 'catalog' of tables it does not show there either. > > > If I query systables: > > select trim(owner)||'.'||trim(tabname) owner_table, > tabname, > substr(tabname,1,15)||substr(tabname,16) cattablenames > from systables where tabname like "l%s" > I get this back: > > > owner_table tabname cattablenames > > informix.loy_customer_event loy_customer_event loy_customer_events > > > > It looks to me like both access & my query tool are looking at > systables to get the table names. I can't undertand why the query > truncates the tabname and ou can only get the full name if you > substring and then concatenate, which does me no good in Access > > > Any ideas? > ------------------------ Yahoo! Groups Sponsor --------------------~--> Most low income households are not online. Help bridge the digital divide today! http://us.click.yahoo.com/I258zB/QnQLAA/TtwFAA/q7folB/TM --------------------------------------------------------------------~-> Please zip all files prior to uploading to Files section. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessDevelopers/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
