odbc -> oracle allowing duplicate entries?
- From: "billb" <billbealey@xxxxxxx>
- Date: 26 Mar 2007 09:10:00 -0700
Hi
I am using Access as a front-end to an Oracle database so have
therefore got linked tables using ODBC.
One of my data tables has a joint primary key....i.e. 2 primary keys
(siteID, Month).
I would have expected oracle to complain when trying to add an
identical record with the same siteID and month but it allows it?
If I have a table with one primary key, as I do on another table,
oracle won't let me add a duplicate record...as I would expect.
The design view in Access shows 2 primary keys. Why is Oracle happy to
let me add an identical row. Is this an ODBC issue and Access?
I want to get users to upload data through an excel spread*** and
can't have duplicate records being accepted....
any ideas?
bib
.
- Prev by Date: odbc joint primary keys - allowing duplicate data?
- Next by Date: microsoft text driver produce non-delimited csv file
- Previous by thread: odbc joint primary keys - allowing duplicate data?
- Next by thread: microsoft text driver produce non-delimited csv file
- Index(es):