Looking for resources with Access interfacing with DB2

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I'm getting tired of hunting around for answers and so far haven't come up
with a good site that deals specifically with Access and DB2. Any
recommendations out there? I can find plenty on Access using just about
anything else, but DB2 seems to be a rare combination.

Thanks
Mark
 
If you have the latest version of Client Access installed on your
workstation then you will be able to connect to DB2 via ODBC.

Dan
 
Dan,

Thanks for replying. I was looking for information on the the
incompatibilities and bugs between Access and DB2. There is plenty of
documentation on issues of using Access with SQL Server but so far I'm not
finding a lot of information on using Access with DB2. What I'm looking for
is a good book, website(s), newsgroups, etc.

I have the most recent version of CCA on my machine and am having no
problems connecting. But I am experiencing some issues with data type
conversions and cases where a VBA query using VBA functions does not
translate through the connection.

My latest issue where I concatenate the values in two text fields and only
the value in the first field saves. I've checked the value in recordset field
object and both are present but the second one gets lost in the update. And
it loses the second value when I concatenate the two values into a string
first and then assign the string to the field. This problem persists after a
compact and repair. I have not had the time to test if it happens in another
mdb pointed at another table.

I'm getting tired of the learn by experience approach, it's fun to figure
out problems but after a while and particularly with a looming deadline it
gets old. So I'm looking for places I can start learning from others
experience. So far it's looking like I should bang my head on some more
issues, find a publisher and write the book. :-)

~Mark
 
Mark,

It appears that you have done quite a bit more work then I have when it
comes to DB2. My project (years ago) I had similar problems as you are
experiencing as well as performance issues. My solution to the problem was
to copy the data from DB2 to Access do any query and reporting within
access. I did not have to do any updates thank god! Those multivalue field
in DB2 are fairly unique.

Good Luck,
Dan
 
Back
Top