By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,145 Members | 1,542 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,145 IT Pros & Developers. It's quick & easy.

Access and DB2

P: n/a
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...

Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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...


Nov 12 '05 #2

P: n/a
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...


Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.