Re: Beginner: How do I link via ODBC from a PC into an AS400?

I've fixed it. Norton AntiVirus, Settings, Virus and Spyware Protection
Options, Miscellaneous, How to keep Microsoft Office Documents Protected,
un-check Turn on scanning for Microsoft Office Documents.

John
--
John Whyte


"JohnW" wrote:

Rick,

In Access when I select File, Get External Data, Link Tables, the Link
dialogue box opens. The moment I select ODBC Databases from Files of Type,
the Link dialogue box disappears/closes. Am I doing this correctly, or have
I missed something out?

Thanks,

John
--
John Whyte


"Rick Brandt" wrote:

JohnW wrote:
Hi, Rick.

Feeling a little stupid here. I have installed IBM AS400 Client
Access Express to my PC. (It has installed an add-in in Excel and
through the Excel Data menu I can transfer csv files from the AS400
into Excel, so there is a connection).

Through the Windows\Start\Programs menu I can view the ODBC data
source administrator dialogue window using the IBM AS400 Client
Access Express software. The ODBC Data source administrator has
tabs: User DSN, System DNS, File DNS, Drivers, Tracing, Connection,
About. I have added a User DSN based on the Client Access Driver,
but I do not really know the significance of each of these tabs.

User DSN is usable by the PC user who created it only
System DSN is usable by any user logged into the PC
File DSN is a DSN stored as a file on disk rather than in the registry

I would use User DSN for this.

At this stage, when I go into MSAccess, nothing happens after I
select the type = ODBC. I am not sure what to do to next. I guess
that the ODBC driver is installed but I have not correctly added the
DSN. When you said 'Control Panel' did you mean the ODBC
administrator or the WinXP control panel from the Start Menu? I would
appreciate a bit more hand-holding through this.

When you select ODBC the ODBC manager dialog should appear and then you would
select the DSN you previously created. That should be followed by a list of
tables to which you can connect.


--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com



.

Relevant Pages

  • Re: Beginner: How do I link via ODBC from a PC into an AS400?
    ... through the Excel Data menu I can transfer csv files from the AS400 ... The ODBC Data source administrator has ... I have added a User DSN based on the Client Access Driver, ...
    (microsoft.public.access.externaldata)
  • Re: Word 2000/2002 - Proper Mail Merge steps for ODBC?
    ... > Document to connect to a Secured Access Database, ... using the ODBC provider for OLEDB. ... they have a .dsn extension. ... directly (in the Open/Select Data Source dialog box). ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Silly ODBC Connection problem
    ... it seems to me this must be done interactively on each client--either that or use the magical "DSN-less" connection. ... It's been 11 or years or so since I wrote about ODBC so it's getting kinda fuzzy. ... 556-9205 (Pacific time) ... > created a System DSN named "MyDSN" in the ODBC Administrator tool. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Word 2000/2002 - Proper Mail Merge steps for ODBC?
    ... you have to use ODBC (or the old DDE ... but then you go onto say that an "ODBC connection set up ... >> Document to connect to a Secured Access Database, ... >they have a .dsn extension. ...
    (microsoft.public.word.mailmerge.fields)
  • Re: ODBC System configuration fails
    ... Did that and also whist they were deleted and prior to restart reinstalled ... Can see but not edit existing user dsn, can not create system dsn, appear to ... (one for each string found in ODBC Data Sources) ...
    (microsoft.public.windows.server.general)