[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

RE: [sqr-users] Linked Tables In access

Thanks Anderson. I had tried to create the unique index from Access side 
and had not realized that it was not saving them.

I create the key on the Oracle table and it worked

Thanks again

-----Original Message-----
From: Anderson, Paul S [mailto:Paul.Anderson@usa.xerox.com]
Sent: 06 April 2004 07:50 PM
To: 'This list is for discussion about the SQR database reporting
languagefrom Hyperion Solutions.'
Subject: RE: [sqr-users] Linked Tables In access


I had bumped into that.. Its probably the accounts Oracle privileges then.

-----Original Message-----
From: sqr-users-bounces+paul.anderson=usa.xerox.com@sqrug.org
[mailto:sqr-users-bounces+paul.anderson=usa.xerox.com@sqrug.org] On Behalf
Of R Gumbo
Sent: Tuesday, April 06, 2004 11:59 AM
To: This list is for discussion about the SQR database reportinglanguage
from Hyperion Solutions.
Subject: RE: [sqr-users] Linked Tables In access


Yes , I created a unique key

-----Original Message-----
From: Anderson, Paul S [mailto:Paul.Anderson@usa.xerox.com]
Sent: 06 April 2004 03:06 PM
To: 'This list is for discussion about the SQR database reporting
languagefrom Hyperion Solutions.'
Subject: RE: [sqr-users] Linked Tables In access


When you created the link did you specify the unique key to the table? Its
not required for read only but I don't think it allows update w/o it.

-----Original Message-----
From: sqr-users-bounces+paul.anderson=usa.xerox.com@sqrug.org
[mailto:sqr-users-bounces+paul.anderson=usa.xerox.com@sqrug.org] On Behalf
Of R Gumbo
Sent: Tuesday, April 06, 2004 1:45 AM
To: sqr-users@sqrug.org
Subject: [sqr-users] Linked Tables In access


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 !!

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

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

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

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

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