ODBC link to Oracle database to create front end

  • Thread starter Thread starter MELINDA Fleming
  • Start date Start date
M

MELINDA Fleming

We need to create a front end application in Access that
puts data into an Oracle table. We need an auto number
scenerio but the table is a linked table to oracle.
Secondary problem is ODBC seems to be read only. How do
you change the properties of the data source to read-
write. machine is Win 98 and Access is 97. Oracle
database is 8.17.

Any discussion would be great.
 
Melinda;
Tha autonumber issue can be fixed by creating a sequence
inside of the Oracle database. This may be the hardest
thing to implement.
The read only issue, did you create a file dsn or a
machine dsn. If you created a file dns, just re-create it
and use a username/password that has the desired
permissions, or change the permissions of the current user
that is being used in the dsn.

Hope that helps.

Sal
 
The read only problem could also be that Access didn't find the primary key.

Try this:

You can create a "Fake" index in Access that tells Access which columns make
a Unique record in the linked table. The index is only used by Access is
completely unknown to the Server.

The following example creates an index on an ODBC linked table. The table's
remote database is unaware of and unaffected by the new index. The following
example won't work if you simply paste it into Microsoft Access; you first
need to create an ODBC linked table called OrderDetailsODBC.

(CREATE INDEX Statement in Help has some examples)

CREATE UNIQUE INDEX OrderID ON OrderDetailsODBC (OrderID);
 
Back
Top