linking to DB2 tables (timestamp fields).

K

Kirk Daledovich

I'm trying to link to a DB2 UDB (v8.1.3) table that has
the timestamp field as a primary key. Access converts the
timestamp field to date time, which then returns
(#deleted) becasue it shortens the time field down and the
data is no longer unquie. Is their a way to change how
access converts the DB2 timestamp field? To text instead
of date time.

We replicate this DB2 table from our mainframe down to a
NT box. The customer is linking to the tables on the NT
box for security reasons. When I link the same table on
our mainframe which has DB2 (v7) access converts the
timestamp field to text which is what I want it to do from
the replicated server.

Thank for any help or suggests.
Please email or post with any questions
(e-mail address removed)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top