I use an Access-form to write into an external Oracle table via Oracle-ODBC
driver.
It is not a read-only connection, and batch autocommit mode set to "all
successful statements".
I can read all records from table, but update, insert, and delete is allowed
on form level, but I cannot change records and I cannot insert. Whats wrong?
Thanks,
Schroeder 6 1695
M. Schroeder wrote: I use an Access-form to write into an external Oracle table via Oracle-ODBC driver. It is not a read-only connection, and batch autocommit mode set to "all successful statements".
I can read all records from table, but update, insert, and delete is allowed on form level, but I cannot change records and I cannot insert. Whats wrong?
Thanks, Schroeder
Does the Oracle table definition include a Primary Key or a Unique Index? If
not then when creating the link you should be getting prompted for the fields
that can be used to build a local unique index. Without one of these three
things an ODBC link will not be editable.
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
> Does the Oracle table definition include a Primary Key or a Unique Index?
If not then when creating the link you should be getting prompted for the
fields that can be used to build a local unique index. Without one of these
three things an ODBC link will not be editable.
(There was index and PK created, but I got nor prompt on creating the link)
But I took another table, with no primary key and no index.
Now I can insert records, but after closing the form they are not
persistent.
On re-opening the form the records are gone.
Looks to me as if the commit statement in ODBC-DSN does not work?
Schroeder
M. Schroeder wrote: Does the Oracle table definition include a Primary Key or a Unique Index? If not then when creating the link you should be getting prompted for the fields that can be used to build a local unique index. Without one of these three things an ODBC link will not be editable.
(There was index and PK created, but I got nor prompt on creating the link) But I took another table, with no primary key and no index. Now I can insert records, but after closing the form they are not persistent. On re-opening the form the records are gone.
Looks to me as if the commit statement in ODBC-DSN does not work?
Schroeder
Sounds like you set the DatEntry property of the form to Yes. In that mode it
is only intended for doing new insertions and does not display any existing
records. They are still in the table though.
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
"Rick Brandt" <ri*********@ho tmail.com> schrieb im Newsbeitrag
news:35******** *****@individua l.net... M. Schroeder wrote: Does the Oracle table definition include a Primary Key or a Unique Index? If not then when creating the link you should be getting prompted for the fields that can be used to build a local unique index. Without one of these three things an ODBC link will not be editable. (There was index and PK created, but I got nor prompt on creating the link) But I took another table, with no primary key and no index. Now I can insert records, but after closing the form they are not persistent. On re-opening the form the records are gone.
Looks to me as if the commit statement in ODBC-DSN does not work?
Schroeder
Sounds like you set the DatEntry property of the form to Yes. In that
mode it is only intended for doing new insertions and does not display any
existing records. They are still in the table though.
Yes - I had DatEntry on Yes and re-set it (does not sound very logical to
me), and now it works well on my test table. I can do updates and inserts.
But the "real prod-table" does not work with the same properties.
I did not delete the PK on my prod-table, I set it to inactive. Maybe thats
the problem and I have to delete it. But how can I get asked from Access to
build a new table with my key-constraints in Access? It would be nice to
keep the PK, because its not just a data-import where I can drop the Key and
rebuild it after the import.
Thanks,
Schroeder
M. Schroeder wrote: Yes - I had DatEntry on Yes and re-set it (does not sound very logical to me), and now it works well on my test table. I can do updates and inserts.
But the "real prod-table" does not work with the same properties.
I did not delete the PK on my prod-table, I set it to inactive. Maybe thats the problem and I have to delete it. But how can I get asked from Access to build a new table with my key-constraints in Access? It would be nice to keep the PK, because its not just a data-import where I can drop the Key and rebuild it after the import.
Can you edit the linked table directly (without using your form)?
The "normal" process is that when you initially create the link to an ODBC table
Access will either detect a Primary Key or Unique Index on the server and
utilize it. If it does not it will prompt you to choose fields for building a
local index.
Were you so prompted when you created the link? If you were prompted and
selected a field or fields to use as a local index did you ever refresh the link
after that? This will cause the local index to be lost. To get it back you
would need to delete the link and then recreate it.
If you are not prompted to choose fields when creating the link then that should
mean that Access is already picking up an index from the server in which case
the link should be editable. Are you sure your permissions on the server allow
for editing?
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
"Rick Brandt" <ri*********@ho tmail.com> schrieb im Newsbeitrag
news:35******** *****@individua l.net... M. Schroeder wrote:
Yes - I had DatEntry on Yes and re-set it (does not sound very logical to me), and now it works well on my test table. I can do updates and inserts.
But the "real prod-table" does not work with the same properties.
I did not delete the PK on my prod-table, I set it to inactive. Maybe thats the problem and I have to delete it. But how can I get asked from Access to build a new table with my key-constraints in Access? It would be nice to keep the PK, because its not just a data-import where I can drop the Key and rebuild it after the import.
Can you edit the linked table directly (without using your form)?
The "normal" process is that when you initially create the link to an ODBC
table Access will either detect a Primary Key or Unique Index on the server and utilize it. If it does not it will prompt you to choose fields for
building a local index.
Were you so prompted when you created the link? If you were prompted and selected a field or fields to use as a local index did you ever refresh
the link after that? This will cause the local index to be lost. To get it back
you would need to delete the link and then recreate it.
If you are not prompted to choose fields when creating the link then that
should mean that Access is already picking up an index from the server in which
case the link should be editable. Are you sure your permissions on the server
allow for editing?
-- I don't check the Email account attached to this message. Send instead to... RBrandt at Hunter dot com
I just deleted the link, deleted the primary key in Oracle and buildt the
link new - then choosed a composed primary key in Access. (Editing of the
former key was not possible.)
But now it works fine; I think I can shift constraints from Oracle to
Access.
Thanks,
Schroeder This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: ishekar |
last post by:
Hi,
I have an application where i want to write data to a file, the data is
being sent from an external source. I know the total size of the data and
then i retrieve the data in small segments from the source. This data is
written to file in a loop.
My question.
1. Will it be useful to increase the file size initially then seek to 0 and
start writing to file. whether there will be any performance improvements
|
by: Christopher Benson-Manica |
last post by:
I have some markup like the following:
<form>
<table>
<script>
<!-- Write the table markup //-->
</script>
</table>
<form>
|
by: Martin_Hurst |
last post by:
Is it possible to establish a connection from within a postgres database to
another external database on the network, i.e., not a java or scripting
connection, BUT by some type of table definition within the postgres
database of that external database table source - something similar to a
proxy definition.
Examples of external database could be MSAccess, Oracle, Sybase,
MSQLServer, etc.
The idea behind this would to be able to at least...
|
by: Mr. Smith |
last post by:
Hello all,
My code can successfully open, write to, format and save several
worksheets in a workbook then save it by a given name, close and quit excel.
My problem is that if I try and do it again, Excel hangs. OR if I open
Excel again (say from a desktop icon) before I close Access, Excel
hangs. (this has happened for both 97 & 2000 for me)
I of course thought that I mustn't be unloading a variable properly.
|
by: Bruce Dodds |
last post by:
One of my clients is going to move to CD or DVD as a medium to
backup/transfer data. Is it possible for an A2003 application to write
directly to a CD or DVD under Win XP, or will I need to set up an
external script?
TIA,
Bruce
| |
by: AM |
last post by:
What I am trying to do is write raw data to a USB to parallel adapter
to control an external device (as I dont have a parallel port) using
VC++.net or C#
The adapter is not a true parallel port and is hence treated as a USB
device. How would I be able to write raw data or ASCII data to this
adapter? Can I use the WritePort...
|
by: althafexcel |
last post by:
hi everyone
Im trying to include an external js in my aspx page under the head
tag, it doesn't load or it displays an object expected error whenver
the function from the .js is called. Actually for repeated html im
using the external js, i mean the TOP, BOTTOM they are repeated in
every page, so i include them as functions in the external js and call
them. Why it doesn't work?
|
by: debasisdas |
last post by:
This thread contains some useful tips for using External tables.
USING EXTERNAL TABLE
=======================
1.THE TABLE POINTS TO EXTERNAL FILE. IF DATA IS ALTERED IN THE EXTERNAL FILE,DATA IN THE TABLE WILL ALSO CHANGE.
2.EXTERNAL TABLES CAN BE QUERIED IN THE SAME WAY AS STANDARD TABLES IN JOINS,VIEWS.....AND CAN USE ALL TYPES OF FUNCTION ON THE EXTERNAL TABLE.
3.TO GET INFO REGARDING EXTERNAL TABLES QUERY THE "USER_EXTERNAL_TABLES"...
|
by: Cramer |
last post by:
I've finally gotton board with TDD (test driven development) and wow is it
effective! I went from sceptic to True Believer with my first effort.
My question: According to the various books and articles I have read about
TDD, a good unit test does not rely on the database or other such
external/environmental conditions. More generally, a good unit test is
atomic and makes as few assumptions about its runtime environment as
possible. But...
|
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 usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| |
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 most users, this new feature is actually very convenient. If you want to control the update process,...
|
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 choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
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 launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
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
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
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 effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |