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

Problem with updates via MS Access

P: n/a
I have attached some DB2 tables into an ACCESS database going through the
following menu "file\get external\link tables\odbc database."
there is no problem to access and read the records into these tables.
But I can only update tables without a column of type TIMESTAMP.

The message
"no current record"
is returned when I try to change a column .

Note that all tables contains a primary key which is moreover
well displayed using the table structure property in ACCESS.
I've already used the optimization for MS access and tried the following
CLI-Parameters for timestamps without success:
PATCH1: 131200 (= 128 + 131072)
PATCH2: 24,33

System:
MS Office XP on Windows XP, SP2
DB2Connect 8.2 (Fixpak 8)
DB2 Version 7 on OS/390
all in german version.

Any ideas, what's going wrong?

Thanks in advance,
Ulrike
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
"Ulrike Klusik" <kl****@mathematik.uni-marburg.de> wrote in message
news:d7**********@news.sdm.de...
I have attached some DB2 tables into an ACCESS database going through the
following menu "file\get external\link tables\odbc database."
there is no problem to access and read the records into these tables.
But I can only update tables without a column of type TIMESTAMP.

The message
"no current record"
is returned when I try to change a column .

Note that all tables contains a primary key which is moreover
well displayed using the table structure property in ACCESS.
I've already used the optimization for MS access and tried the following
CLI-Parameters for timestamps without success:
PATCH1: 131200 (= 128 + 131072)
PATCH2: 24,33

System:
MS Office XP on Windows XP, SP2
DB2Connect 8.2 (Fixpak 8)
DB2 Version 7 on OS/390
all in german version.

Any ideas, what's going wrong?

Thanks in advance,
Ulrike

If you are using ODBC, try using the IBM ODBC driver instead of the MS one.
It comes with the DB2 runtime client (free) if you don't already have it
installed.
Nov 12 '05 #2

P: n/a
I'm already using the IBM ODBC driver, Version 8.01.07.447.
I even don't have an MS DB2 driver installed.

"Mark A" <no****@nowhere.com> schrieb im Newsbeitrag
news:Yv********************@comcast.com...
"Ulrike Klusik" <kl****@mathematik.uni-marburg.de> wrote in message
news:d7**********@news.sdm.de...
I have attached some DB2 tables into an ACCESS database going through the
following menu "file\get external\link tables\odbc database."
there is no problem to access and read the records into these tables.
But I can only update tables without a column of type TIMESTAMP.

The message
"no current record"
is returned when I try to change a column .

Note that all tables contains a primary key which is moreover
well displayed using the table structure property in ACCESS.
I've already used the optimization for MS access and tried the following
CLI-Parameters for timestamps without success:
PATCH1: 131200 (= 128 + 131072)
PATCH2: 24,33

System:
MS Office XP on Windows XP, SP2
DB2Connect 8.2 (Fixpak 8)
DB2 Version 7 on OS/390
all in german version.

Any ideas, what's going wrong?

Thanks in advance,
Ulrike

If you are using ODBC, try using the IBM ODBC driver instead of the MS
one. It comes with the DB2 runtime client (free) if you don't already have
it installed.

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.