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

DAP problem

P: n/a
I am relatively new to the world of Access databases and have been
working on creating a Data Access Page for our intranet. The DAP is
based on a parameter query that consists of a static table and a linked
table to an Oracle Database. I only have read-only access to the
Oracle Database. When I try to change fields in my DAP(that consist of
a combo box with Yes/No) I get the message that a Value couldn't be
saved into the Data source's field. Operation was cancelled. Discard
changed value?

When I originally setup the query I selected the static table to be the
updated table- that is where I want any changes to reside- so the
linked table should only be pulling information. I have created
another DAP using just the static table and it works like a charm- all
changes are updated in that table. It is just when I use this linked
table in conjunction with the static table that I receive this error.

I have read other posts and made sure that all properties were set
properly... it seems. I'm thinking the fact that I don't have
sufficient rights for the Oracle database (linked table) isn't helping
my cause. Please advise. Any help would be appreciated.

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Without seeing your query, here's a guess.

You can change the format of the query to use Standard SQL syntax
instead of JET SQL syntax. E.g.:

Standard SQL UPDATE syntax:

UPDATE JET_table
SET column_a = (SELECT column_a FROM oracle_table
WHERE some_column = JET_table.some_column
WHERE column_b = (SELECT column_b FROM oracle_table
WHERE some_column = JET_table.some_column)

Usually some_column is an ID column common to both tables (the related
column).
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQlw+/YechKqOuFEgEQJtygCcDGweiHI+mUGk9cJKEb6hq+3kADAAniI H
odmUoj267p6tAlnGRtE8D3Xw
=2mu6
-----END PGP SIGNATURE-----
gi********@yahoo.com wrote:
I am relatively new to the world of Access databases and have been
working on creating a Data Access Page for our intranet. The DAP is
based on a parameter query that consists of a static table and a linked
table to an Oracle Database. I only have read-only access to the
Oracle Database. When I try to change fields in my DAP(that consist of
a combo box with Yes/No) I get the message that a Value couldn't be
saved into the Data source's field. Operation was cancelled. Discard
changed value?

When I originally setup the query I selected the static table to be the
updated table- that is where I want any changes to reside- so the
linked table should only be pulling information. I have created
another DAP using just the static table and it works like a charm- all
changes are updated in that table. It is just when I use this linked
table in conjunction with the static table that I receive this error.

I have read other posts and made sure that all properties were set
properly... it seems. I'm thinking the fact that I don't have
sufficient rights for the Oracle database (linked table) isn't helping
my cause. Please advise. Any help would be appreciated.

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.