Re: ODBC link to iSeries tables - Index problem

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Rick Brandt (rickbrandt2_at_hotmail.com)
Date: 12/19/04 

Date: Sun, 19 Dec 2004 09:13:26 -0600

"Daniel Carollo" <danielc@NO_SPAM_PLEASE.computing-tech.com> wrote in message
news:eADzKtb5EHA.2016@TK2MSFTNGP15.phx.gbl.>
> I have the following situation in an application:

> For security reasons, linked tables are created at startup of the
> application [snip]

> In Access 2000 on NT4, this worked fine, and the index fields defined in the
> DB2 tables were reflected in Access.
> We are now migrating to Access 2002 on Windows XP, and the index aren't seen
> by Access.[snip]

> If I link the tables "by hand" (using the wizard), I get prompted to define
> the index in XP (but not in 2000/NT).[snip]

I will definitely need to test to see if I can duplicate your experience. AFAIK
Access should pick up the PK of any ODBC linked table and in my experience
(Access 97) it has always picked up all of the indexes as well. I even have a
few cases where I am forced to link to logical files on our ISeries because the
Physical file has more than 32 indexes on it and Access won't let me link to
those.

I have Access 2000 files that are "using" links to our ISeries under Windows
2003 Server, but those links were created in Access 97 and then the file
converted for distribution to users with A2K installed. We definitely have
power users linking to our ISeries with Access 2002 and Access 2003 under WinXP,
but they are seldom attempting to do edits so perhaps this has been occurring to
them and I just haven't heard about it.

I will attempt to test and post back. 

-- 
I don't check the Email account attached
to this message.     Send instead to...
RBrandt    at       Hunter      dot      com

Relevant Pages

  • Re: How many companies are buying new AS400s
    ... Just like you do in iSeries navigator. ... SAVEPOINTs and ROLLBACKs are easy in any database that supports them, but what about analysis of the actual individual entries? ... Is it as easy to do this in Windows or Linux? ... I know how OS/400 work management lets me tune it so the customer is happy during those three or four minutes and is just as happy during the remaining 23:56 of the day. ...
    (comp.sys.ibm.as400.misc)
  • RE: Problem migrating client computers
    ... from SBS 2000 to SBS 2003? ... Migrating from Small Business Server 2000 or Windows 2000 Server to Windows ...
    (microsoft.public.windows.server.sbs)
  • RE: windows NT to Win2K3 with Exchange 5.5 to Exchang 2K3
    ... Windows XP PC there is not problem. ... converted most of the desktops to XP, but will not be migrating all before ... > Use NetDom or Active Directory Domains and Trusts to verify the trusts. ... > Microsoft is providing this information as a convenience to you. ...
    (microsoft.public.windows.server.migration)
  • RE: migrating WINS
    ... Migrating from Windows NT Server 4.0 to Windows Server 2003 ... Microsoft Online Partner Support ...
    (microsoft.public.windows.server.migration)
  • Re: Migrating files from NT to Windows 2003 from different forests
    ... Thanks Jorge. ... will this utility work for migrating files from a Novell file server? ... The Novell server resides on a Windows 2003 Domain. ...
    (microsoft.public.windows.server.active_directory)