Access and DB2

[Tom]

I'm using Access to work with my data stored in a DB2 database on an
AS/400. One of the things that I would like to do is to create code
that will attach (link to) all the necessary tables. I know this can
be done when attaching other Access tables.

Can this be done for my DB2 database? If so, does anyone know HOW?
Can you point me to a location with this information?

(The code Microsoft has on their web site only works for another
Access db, not for my DB2 db.)

Thanks in advance...

[Tom van Stiphout]

On Thu, 19 Feb 2004 12:48:16 GMT, Tom <tc*****@mindspring.com> wrote:

Attach one table manually. Inspect the Connect property.
Now you can adjust the relink code for another Access db.

-Tom.

I'm using Access to work with my data stored in a DB2 database on an
AS/400. One of the things that I would like to do is to create code
that will attach (link to) all the necessary tables. I know this can
be done when attaching other Access tables.

Can this be done for my DB2 database? If so, does anyone know HOW?
Can you point me to a location with this information?

(The code Microsoft has on their web site only works for another
Access db, not for my DB2 db.)

Thanks in advance...

[Tom]

Thanks.

I'm still rather new to Access. It sounds like you're saying to use
Basic to look at these properties. Would you happen to have, or know
where I might obtain such code? I guess I need a little "jump start"
here, to get me going.
On Thu, 19 Feb 2004 07:13:07 -0700, Tom van Stiphout
<to*****@no.spam.cox.net> wrote:

On Thu, 19 Feb 2004 12:48:16 GMT, Tom <tc*****@mindspring.com> wrote:

Attach one table manually. Inspect the Connect property.
Now you can adjust the relink code for another Access db.

-Tom.

I'm using Access to work with my data stored in a DB2 database on an
AS/400. One of the things that I would like to do is to create code
that will attach (link to) all the necessary tables. I know this can
be done when attaching other Access tables.

Can this be done for my DB2 database? If so, does anyone know HOW?
Can you point me to a location with this information?

(The code Microsoft has on their web site only works for another
Access db, not for my DB2 db.)

Thanks in advance...