I want to use Access ODBC to link t

[johnnygeo]

I want to use Access ODBC to link to a table on an AS400 database. I can use Client Access ODBC to query these tables, but I want to link to them. I think the trouble is that the table name format is too complex for the link table dialog to handle.

For example:
the table I want to link to is in library ARDTA.139A and the table name is AR#ROTKT. I can query this using an ODBC passthrough query as long as I use

select * from "ARDTA.139A"."AR#ROTKT"

When I use the link table dialog, I can see the table listed as

ARDTA.139A.AR#ROTKT

i.e. no quotes to delimit the library from the table name.

When I select the table and try to link it, I get an error that the MS Access DB Engine cannot find the object 'ARDTA.139A.AR#ROTKT'

Is there a way to create a link where I can experiment with typing in my own table name, so I can punctuate it how I want? Maybe using VBA?


Thanks,
Johnny Geo

 

[dhookom]

Is there a reason you can't just use the pass-through? Do you need to edit the data in the table?

Duane
Hook'D on Access
MS Access MVP