RE: [sqr-users] Linked Tables In access

["the dragon" <ceprn@hotmail.com>]

It sounds to me like a permissions issue on the Oracle side.

I may be wrong about this, since I don't know much about crappy Micro$haft 
junk like Access, but since the table is linked to Oracle, and you're trying 
to insert into the table, it's trying to carry that insert back to Oracle, 
and the Access user doesn't have permissions to insert (Which is a very good 
thing).

I assume, if you want to insert into that table you'll need to unlink it 
from Oracle.

hope this helps,

peace
clark 'the dragon' willis

PSA: Salary <> Slavery.  If you earn a salary, your employer is renting your 
services for 40 hours a week, not purchasing your soul.  Your time is the 
only real finite asset that you have, and once used it can never be 
recovered, so don't waste it by giving it away.

"Time is the coin of your life. It is the only coin you have, and only you 
can determine how it will be spent.  Be careful lest you let other people 
spend it for you."

Carl Sandburg
(1878 - 1967)

----Original Message Follows----

I have an MS Access Database in which I have a linked table which is linked 
to a table
in Oracle 8 i database

I am unable to go into insert mode, when i open the access database
My access application ca also not insert data into this linked table

What do I need to do to be able to create records in this table or is it a 
question of permissions

Please help !!

_________________________________________________________________
Check out MSN PC Safety & Security to help ensure your PC is protected and 
safe. http://specials.msn.com/msn/security.asp


_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users