ORACLE Linked Tables not being refreshed

[Pauline]

when logging into MS ACCESS 97, the tables in my application aren't being
refreshed so that when trying to process i receive, an error .... "can't
update a readonly transaction". However, if I then run the process in an
SQL-PLUS session, I can go back to MS ACCESS and my processes will work !!!
any ideas ?

 

[Pieter Wijnen]

Are you talking about tables (definition) or table data?

if table data:
Access cannot update tables with no unique index
either create one in Oracle or a local index in Access

either way the syntax is
CREATE UNIQUE INDEX <IndexName> ON <TableName> (<Field1>[,Field2,..FieldN>)

You can execute Oracle Procedures using a passthrough query

you can refresh the definition of Tables by using a TableDef Object's
Refreshlink method
ie
CurrentDb.TableDefs("TableName").Refreshlink

Pieter

 

[Pauline]

thank you pieter ! it's the data that is readonly. i'm able to re-link but
have to do this every time i start a new MS ACCESS session ! ps ... the
tables all have unique indexes.
--
thanks in advance !

Are you talking about tables (definition) or table data?

if table data:
Access cannot update tables with no unique index
either create one in Oracle or a local index in Access

either way the syntax is
CREATE UNIQUE INDEX <IndexName> ON <TableName> (<Field1>[,Field2,..FieldN>)

You can execute Oracle Procedures using a passthrough query

you can refresh the definition of Tables by using a TableDef Object's
Refreshlink method
ie
CurrentDb.TableDefs("TableName").Refreshlink

Pieter

when logging into MS ACCESS 97, the tables in my application aren't being
refreshed so that when trying to process i receive, an error .... "can't
update a readonly transaction". However, if I then run the process in an
SQL-PLUS session, I can go back to MS ACCESS and my processes will work
!!!
any ideas ?

 

[Pieter Wijnen]

You might have an ODBC driver problem
Are you using Microsoft's driver or Oracle's?
Usually better results with Oracles driver (latest driver can be obtained
from http://otn.oracle.com)
Are other people using the same Db, if so with the same driver?
try to remove the driver Entry from C:\Windows\ODBC.ini

thank you pieter ! it's the data that is readonly. i'm able to re-link
but
have to do this every time i start a new MS ACCESS session ! ps ... the
tables all have unique indexes.
--
thanks in advance !

Are you talking about tables (definition) or table data?

if table data:
Access cannot update tables with no unique index
either create one in Oracle or a local index in Access

either way the syntax is
CREATE UNIQUE INDEX <IndexName> ON <TableName>
(<Field1>[,Field2,..FieldN>)

You can execute Oracle Procedures using a passthrough query

you can refresh the definition of Tables by using a TableDef Object's
Refreshlink method
ie
CurrentDb.TableDefs("TableName").Refreshlink

Pieter

when logging into MS ACCESS 97, the tables in my application aren't
being
refreshed so that when trying to process i receive, an error ....
"can't
update a readonly transaction". However, if I then run the process in
an
SQL-PLUS session, I can go back to MS ACCESS and my processes will work
!!!
any ideas ?

 

[Pauline]

i'm using ORACLE's ODBC (oracle in OraHome92). and yes, other people access
this database ... do they have to be using the same ODBC driver as mine?
getting closer I think ;-)
--
thanks in advance !

You might have an ODBC driver problem
Are you using Microsoft's driver or Oracle's?
Usually better results with Oracles driver (latest driver can be obtained
from http://otn.oracle.com)
Are other people using the same Db, if so with the same driver?
try to remove the driver Entry from C:\Windows\ODBC.ini

thank you pieter ! it's the data that is readonly. i'm able to re-link
but
have to do this every time i start a new MS ACCESS session ! ps ... the
tables all have unique indexes.
--
thanks in advance !

Are you talking about tables (definition) or table data?

if table data:
Access cannot update tables with no unique index
either create one in Oracle or a local index in Access

either way the syntax is
CREATE UNIQUE INDEX <IndexName> ON <TableName>
(<Field1>[,Field2,..FieldN>)

You can execute Oracle Procedures using a passthrough query

you can refresh the definition of Tables by using a TableDef Object's
Refreshlink method
ie
CurrentDb.TableDefs("TableName").Refreshlink

Pieter


when logging into MS ACCESS 97, the tables in my application aren't
being
refreshed so that when trying to process i receive, an error ....
"can't
update a readonly transaction". However, if I then run the process in
an
SQL-PLUS session, I can go back to MS ACCESS and my processes will work
!!!
any ideas ?

 

[Pieter Wijnen]

Yes they do.
The only time I've had this problem was with different ODBC drivers

Pieter

i'm using ORACLE's ODBC (oracle in OraHome92). and yes, other people
access
this database ... do they have to be using the same ODBC driver as mine?
getting closer I think ;-)
--
thanks in advance !

You might have an ODBC driver problem
Are you using Microsoft's driver or Oracle's?
Usually better results with Oracles driver (latest driver can be obtained
from http://otn.oracle.com)
Are other people using the same Db, if so with the same driver?
try to remove the driver Entry from C:\Windows\ODBC.ini

thank you pieter ! it's the data that is readonly. i'm able to
re-link
but
have to do this every time i start a new MS ACCESS session ! ps ...
the
tables all have unique indexes.
--
thanks in advance !


:

Are you talking about tables (definition) or table data?

if table data:
Access cannot update tables with no unique index
either create one in Oracle or a local index in Access

either way the syntax is
CREATE UNIQUE INDEX <IndexName> ON <TableName>
(<Field1>[,Field2,..FieldN>)

You can execute Oracle Procedures using a passthrough query

you can refresh the definition of Tables by using a TableDef Object's
Refreshlink method
ie
CurrentDb.TableDefs("TableName").Refreshlink

Pieter


when logging into MS ACCESS 97, the tables in my application aren't
being
refreshed so that when trying to process i receive, an error ....
"can't
update a readonly transaction". However, if I then run the process
in
an
SQL-PLUS session, I can go back to MS ACCESS and my processes will
work
!!!
any ideas ?

 

[Pauline]

thanks for all your input today, Pieter ! no one else is using the odbc
connections (and they're all using the same drivers as I) ... but i just
logged out of MS ACCESS and logged back in only to find that I'm having the
same problems of readonly transaction ... then i tried to re-run the same
process ... and it worked ! THIS IS AWFUL ;-)
--
thanks in advance !

Yes they do.
The only time I've had this problem was with different ODBC drivers

Pieter

i'm using ORACLE's ODBC (oracle in OraHome92). and yes, other people
access
this database ... do they have to be using the same ODBC driver as mine?
getting closer I think ;-)
--
thanks in advance !

You might have an ODBC driver problem
Are you using Microsoft's driver or Oracle's?
Usually better results with Oracles driver (latest driver can be obtained
from http://otn.oracle.com)
Are other people using the same Db, if so with the same driver?
try to remove the driver Entry from C:\Windows\ODBC.ini


thank you pieter ! it's the data that is readonly. i'm able to
re-link
but
have to do this every time i start a new MS ACCESS session ! ps ...
the
tables all have unique indexes.
--
thanks in advance !


:

Are you talking about tables (definition) or table data?

if table data:
Access cannot update tables with no unique index
either create one in Oracle or a local index in Access

either way the syntax is
CREATE UNIQUE INDEX <IndexName> ON <TableName>
(<Field1>[,Field2,..FieldN>)

You can execute Oracle Procedures using a passthrough query

you can refresh the definition of Tables by using a TableDef Object's
Refreshlink method
ie
CurrentDb.TableDefs("TableName").Refreshlink

Pieter


when logging into MS ACCESS 97, the tables in my application aren't
being
refreshed so that when trying to process i receive, an error ....
"can't
update a readonly transaction". However, if I then run the process
in
an
SQL-PLUS session, I can go back to MS ACCESS and my processes will
work
!!!
any ideas ?

 

[Ron Hinds]

What is the data type of the unique index in Oracle? If it is a data type
that Access doesn't understand (e.g, bigint [64-bit integer]), then it will
not work correctly. Also, is there a timestamp column in the Oracle tables?
Access will use that column to determine if a record is dirty and update
accordingly.

You also might want to try posting your question in the
microsoft.public.access.odbcclientsvr group.

thanks for all your input today, Pieter ! no one else is using the odbc
connections (and they're all using the same drivers as I) ... but i just
logged out of MS ACCESS and logged back in only to find that I'm having
the
same problems of readonly transaction ... then i tried to re-run the same
process ... and it worked ! THIS IS AWFUL ;-)
--
thanks in advance !

Yes they do.
The only time I've had this problem was with different ODBC drivers

Pieter

i'm using ORACLE's ODBC (oracle in OraHome92). and yes, other people
access
this database ... do they have to be using the same ODBC driver as
mine?
getting closer I think ;-)
--
thanks in advance !


:

You might have an ODBC driver problem
Are you using Microsoft's driver or Oracle's?
Usually better results with Oracles driver (latest driver can be
obtained
from http://otn.oracle.com)
Are other people using the same Db, if so with the same driver?
try to remove the driver Entry from C:\Windows\ODBC.ini


thank you pieter ! it's the data that is readonly. i'm able to
re-link
but
have to do this every time i start a new MS ACCESS session ! ps
...
the
tables all have unique indexes.
--
thanks in advance !


:

Are you talking about tables (definition) or table data?

if table data:
Access cannot update tables with no unique index
either create one in Oracle or a local index in Access

either way the syntax is
CREATE UNIQUE INDEX <IndexName> ON <TableName>
(<Field1>[,Field2,..FieldN>)

You can execute Oracle Procedures using a passthrough query

you can refresh the definition of Tables by using a TableDef
Object's
Refreshlink method
ie
CurrentDb.TableDefs("TableName").Refreshlink

Pieter


when logging into MS ACCESS 97, the tables in my application
aren't
being
refreshed so that when trying to process i receive, an error ....
"can't
update a readonly transaction". However, if I then run the
process
in
an
SQL-PLUS session, I can go back to MS ACCESS and my processes
will
work
!!!
any ideas ?