473,554 Members | 2,142 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Linked DB2 table in MSAccess 2000 shows #Deleted on every record

The linked table has a bigint in primary key columns.
I've read that service pack 8 on Jet should solve this but it didn't.
On patch1 options I only found to map timestamp to char(26) entry
for similar problems on timestamp fields but nothing for Bigint.
DB2 is UDB8.1 Fix 6 on Win2000
Are there any other solutions?

Thanks
Klemens

Nov 12 '05 #1
8 8086

"Klemens" <me@privacy.net > wrote in message
news:2n******** ****@uni-berlin.de...
The linked table has a bigint in primary key columns.
I've read that service pack 8 on Jet should solve this but it didn't.
On patch1 options I only found to map timestamp to char(26) entry
for similar problems on timestamp fields but nothing for Bigint.
DB2 is UDB8.1 Fix 6 on Win2000
Are there any other solutions?

I don't understand your problem. What are you trying to do? What error
message are you getting? Are you sure it's a DB2 problem and not a problem
with Jet or MS Access?

Rhino
Nov 12 '05 #2
I'm asking for a solution or workaround for beeing able to to work in
msaccess with linked DB2 tables having bigint column in primary key. Access
shows #Deleted on every column.
The better way would be a solution in access or jet but may be there is a
workaround, like that for timestamp columns, in DB2.

Thanks
Klemens

"Rhino" <rh****@NOSPAM. sympatico.ca> schrieb im Newsbeitrag
news:NG******** ************@ne ws20.bellglobal .com...

"Klemens" <me@privacy.net > wrote in message
news:2n******** ****@uni-berlin.de...
The linked table has a bigint in primary key columns.
I've read that service pack 8 on Jet should solve this but it didn't.
On patch1 options I only found to map timestamp to char(26) entry
for similar problems on timestamp fields but nothing for Bigint.
DB2 is UDB8.1 Fix 6 on Win2000
Are there any other solutions?

I don't understand your problem. What are you trying to do? What error
message are you getting? Are you sure it's a DB2 problem and not a problem
with Jet or MS Access?

Rhino

Nov 12 '05 #3
It sounds like your problem is with MS Access and/or Jet, not DB2, but I
could be wrong. I don't have MS Access myself, otherwise I'd create a little
DB2 table with a bigint primary key and try to do what you are doing to see
what the problem might be.

You could try posting to an MS Access newsgroup or maybe someone else on
this newsgroup will have some DB2/MS Access experience. Sorry I couldn't be
more help.

Rhino

"Klemens" <me@privacy.net > wrote in message
news:2n******** ****@uni-berlin.de...
I'm asking for a solution or workaround for beeing able to to work in
msaccess with linked DB2 tables having bigint column in primary key. Access shows #Deleted on every column.
The better way would be a solution in access or jet but may be there is a
workaround, like that for timestamp columns, in DB2.

Thanks
Klemens

"Rhino" <rh****@NOSPAM. sympatico.ca> schrieb im Newsbeitrag
news:NG******** ************@ne ws20.bellglobal .com...

"Klemens" <me@privacy.net > wrote in message
news:2n******** ****@uni-berlin.de...
The linked table has a bigint in primary key columns.
I've read that service pack 8 on Jet should solve this but it didn't.
On patch1 options I only found to map timestamp to char(26) entry
for similar problems on timestamp fields but nothing for Bigint.
DB2 is UDB8.1 Fix 6 on Win2000
Are there any other solutions?

I don't understand your problem. What are you trying to do? What error
message are you getting? Are you sure it's a DB2 problem and not a problem with Jet or MS Access?

Rhino


Nov 12 '05 #4
This problem happens because Access doesn't have a data type that
corresponds to Bigint. When you display a table, Access will re-read every
row (by the primary key) to see if they are still there (and haven't been
deleted by an external app). Because of the data type problem, Access will
not be able to read the rows correctly so does not find them. It will
therefore think the rows have been deleted and marks them as such. As
mentioned, this problem also happens with timestamp cols. IBM have put a
workaround option so that the DB2 Client returns timestamp cols as
character. Access can handle char strings OK, so is able to display and re-
read them OK. It looks like there is no workaround option for Bigint, so
there is no simple resolution for your problem. What does work however is
to create a view on your table with the bigint col converted to character -
eg. "create view bigintview (bigintcol, col2) as select char(bigintcol) ,
col2 from biginttab". You can display and update this view in Access OK
(and this updates your table).

Phil Castle

On Mon, 9 Aug 2004 18:27:39 +0200, Klemens <me@privacy.net > wrote:
The linked table has a bigint in primary key columns.
I've read that service pack 8 on Jet should solve this but it didn't.
On patch1 options I only found to map timestamp to char(26) entry
for similar problems on timestamp fields but nothing for Bigint.
DB2 is UDB8.1 Fix 6 on Win2000
Are there any other solutions?

Thanks
Klemens


--
Using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/
Nov 12 '05 #5
The workaround works.
I had to do some rework on forms that where linked on each other on these
columns.

Do you know why this problem didnt happen with UDB V7.2?

Thanks
Klemens

"Phil Castle" <ph**@querytool .com> schrieb im Newsbeitrag
news:opscjclwol y8iall@localhos t...
This problem happens because Access doesn't have a data type that
corresponds to Bigint. When you display a table, Access will re-read every
row (by the primary key) to see if they are still there (and haven't been
deleted by an external app). Because of the data type problem, Access will
not be able to read the rows correctly so does not find them. It will
therefore think the rows have been deleted and marks them as such. As
mentioned, this problem also happens with timestamp cols. IBM have put a
workaround option so that the DB2 Client returns timestamp cols as
character. Access can handle char strings OK, so is able to display and re- read them OK. It looks like there is no workaround option for Bigint, so
there is no simple resolution for your problem. What does work however is
to create a view on your table with the bigint col converted to character - eg. "create view bigintview (bigintcol, col2) as select char(bigintcol) ,
col2 from biginttab". You can display and update this view in Access OK
(and this updates your table).

Phil Castle

On Mon, 9 Aug 2004 18:27:39 +0200, Klemens <me@privacy.net > wrote:
The linked table has a bigint in primary key columns.
I've read that service pack 8 on Jet should solve this but it didn't.
On patch1 options I only found to map timestamp to char(26) entry
for similar problems on timestamp fields but nothing for Bigint.
DB2 is UDB8.1 Fix 6 on Win2000
Are there any other solutions?

Thanks
Klemens


--
Using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/

Nov 12 '05 #6
Don't know.... I am running DB2 v7.2 here and the problem happens for me.
There might be a dependency on your actual data values.

Phil Castle.
On Wed, 11 Aug 2004 11:42:11 +0200, Klemens <me@privacy.net > wrote:
The workaround works.
I had to do some rework on forms that where linked on each other on these
columns.

Do you know why this problem didnt happen with UDB V7.2?

Thanks
Klemens

"Phil Castle" <ph**@querytool .com> schrieb im Newsbeitrag
news:opscjclwol y8iall@localhos t...
This problem happens because Access doesn't have a data type that
corresponds to Bigint. When you display a table, Access will re-read
every
row (by the primary key) to see if they are still there (and haven't
been
deleted by an external app). Because of the data type problem, Access
will
not be able to read the rows correctly so does not find them. It will
therefore think the rows have been deleted and marks them as such. As
mentioned, this problem also happens with timestamp cols. IBM have put a
workaround option so that the DB2 Client returns timestamp cols as
character. Access can handle char strings OK, so is able to display and

re-
read them OK. It looks like there is no workaround option for Bigint, so
there is no simple resolution for your problem. What does work however
is
to create a view on your table with the bigint col converted to

character -
eg. "create view bigintview (bigintcol, col2) as select char(bigintcol) ,
col2 from biginttab". You can display and update this view in Access OK
(and this updates your table).

Phil Castle

On Mon, 9 Aug 2004 18:27:39 +0200, Klemens <me@privacy.net > wrote:
> The linked table has a bigint in primary key columns.
> I've read that service pack 8 on Jet should solve this but it didn't.
> On patch1 options I only found to map timestamp to char(26) entry
> for similar problems on timestamp fields but nothing for Bigint.
> DB2 is UDB8.1 Fix 6 on Win2000
> Are there any other solutions?
>
> Thanks
> Klemens
>
>
>
>


--
Using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/



--
Using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/
Nov 12 '05 #7
I have to correkt. It dosn't work. I get SQLCODE 151 on insert. It only
works for update and select.

Klemens

"Klemens" <me@privacy.net > schrieb im Newsbeitrag
news:2n******** ****@uni-berlin.de...
The workaround works.
I had to do some rework on forms that where linked on each other on these
columns.

Do you know why this problem didnt happen with UDB V7.2?

Thanks
Klemens

"Phil Castle" <ph**@querytool .com> schrieb im Newsbeitrag
news:opscjclwol y8iall@localhos t...
This problem happens because Access doesn't have a data type that
corresponds to Bigint. When you display a table, Access will re-read every row (by the primary key) to see if they are still there (and haven't been deleted by an external app). Because of the data type problem, Access will not be able to read the rows correctly so does not find them. It will
therefore think the rows have been deleted and marks them as such. As
mentioned, this problem also happens with timestamp cols. IBM have put a
workaround option so that the DB2 Client returns timestamp cols as
character. Access can handle char strings OK, so is able to display and

re-
read them OK. It looks like there is no workaround option for Bigint, so
there is no simple resolution for your problem. What does work however is to create a view on your table with the bigint col converted to

character -
eg. "create view bigintview (bigintcol, col2) as select char(bigintcol) ,
col2 from biginttab". You can display and update this view in Access OK
(and this updates your table).

Phil Castle

On Mon, 9 Aug 2004 18:27:39 +0200, Klemens <me@privacy.net > wrote:
The linked table has a bigint in primary key columns.
I've read that service pack 8 on Jet should solve this but it didn't.
On patch1 options I only found to map timestamp to char(26) entry
for similar problems on timestamp fields but nothing for Bigint.
DB2 is UDB8.1 Fix 6 on Win2000
Are there any other solutions?

Thanks
Klemens


--
Using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/


Nov 12 '05 #8
Please, refer to this forum (in German):

http://www.ruban.de/cgi-bin/yabb/YaB...num=1107953134

It works for me (DB2 8.1 ODBC client and DB2 7.1 database on z/OS)
In few words:

1. On the client side, add these two lines in db2cli.ini:
[in Database Section]
MapTimestampDes cribe=1
MapTimestampCDe fault=1

2. On DB2 (7 or 8) for z/OS (OS390) side, apply:
APAR/Fix PQ96188 / UQ96410
APAR/Fix PQ83561/ UQ87586

They also say there could be some errors on z/OS side when running INSERT
statements from MS Access that involve timestamps without microseconds or
with minutes less than 10. I didn't test these issues yet. If you only
read timestamps, it should be fine.
Nov 18 '05 #9

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

20
2656
by: Neil | last post by:
I have an Access 2000 MDB file with a SQL 7 back end. I have a main table with 50,000 records; and I have a selections table with 50,000 records for each machine that uses the database (about 25-50). This allows each user to have their own set of selections. The selections table has three fields: ID (int), Sel (bit), MachName (varchar). ID...
2
2209
by: Klemens | last post by:
The linked table has a bigint in primary key columns. I've read that service pack 8 on Jet should solve this but it didn't. Are there any other solutions? Thanks Klemens
1
1933
by: GGerard | last post by:
Hello I am working with Access 2000 I have two tables joined on a one to many relationship between two fields: Table1:FieldID (one) is joined to Table2:FieldMyID (many) Field Properties setting: FieldID : Field Size - Long Integer New Values - Increment
8
9220
by: Bri | last post by:
Greetings, I'm having a very strange problem in an AC97 MDB with ODBC Linked tables to SQL Server 7. The table has an Identity field and a Timestamp field. The problem is that when a new record is entered, either from a form or from the table view of the table, when the record gets saved it immediately displays #DELETED# in all of the...
0
3709
by: Igor | last post by:
An error "ODBC connection to failed" is raised when I am trying to get data from a table in Microsoft Access (97, or 2000) which is actually a linked table to another table in SQL Server 7 . The exception is raised from a Web .Net app while exactly the same code works fine in Windows .Net app. That makes me thinking the issue somehow is...
0
3694
by: Murali | last post by:
In MsAccess project I Create the Link table with Sqlserver 2000. I am facing the multiuser Problem in my application. The problem describes below: If one user is updating one record and at that same time another user try to modify the same record. Now current application is allowing the second user to modify the same record. Before...
2
1593
by: eilob | last post by:
Hi, I have a linked table in Access which is linked to an Inbox Folder in Microsoft Outlook. The table will reflect the emails that come in into the Inbox. I need that every time an email comes in be transferred from the Linked table to a normal table. This is to keep a record of every email that comes into the Inbox. How could I set this up...
0
7605
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
0
8047
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
1
7570
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
0
7893
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
0
6156
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
0
3556
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2022
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
1
1141
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
845
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.