SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
ODBC Error MS Access

 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
ODBC Error MS Access
Author Message
sangha



Joined: 19 Dec 2006
Posts: 18

Post ODBC Error MS Access Reply with quote
I am getting the following error while trying to join in MS Access :-
Code:
ODBC Error: SQLExecDirect
Client: 04.00.6305
Server: 04.00.0000
[Microsoft][ODBC Microsoft Access Driver] Record(s) cannot be read; no read permission on 'MSysRelationships'.

select
   szReferencedObject,
   szReferencedColumn,
   szColumn
from
   MSysRelationships
where
   szObject = ?           

union all

select
   szObject,
   szColumn,
   szReferencedColumn
from
   MSysRelationships
where
   szReferencedObject = ?           
order by 1
&steps=&email=&dontask=0

Sat Oct 18, 2008 11:46 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7840

Post Reply with quote
The error says "no read permission on 'MSysRelationships'." So, what's you question?
Sun Oct 19, 2008 12:32 am View user's profile Send private message
sangha



Joined: 19 Dec 2006
Posts: 18

Post Reply with quote
My question is how to get read permission to the table. Relationships cannot read because of this.
Sun Oct 19, 2008 4:32 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7840

Post Reply with quote
Quote:
how to get read permission to the table


Login as a different user who has sufficient permissions for this table. Or alternatively ask a user having admin-level permissions to add you to a user group having permissions for selecting from 'MSysRelationships' table or granting the required permission directly to you.
Sun Oct 19, 2008 11:25 am View user's profile Send private message
sangha



Joined: 19 Dec 2006
Posts: 18

Post Reply with quote
I am logged in as Admin. If I am in the mdb I can open the table.
Sun Oct 19, 2008 7:44 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7840

Post Reply with quote
Check your connection settings entered in SQL Assistant options.. you may different user name entered there, something you have entered earlier and then forgot, and not what you expect now.

I don't think, this is an SQL Assistant issue. There is something wrong with your user permissions and the message you are getting is a clear indication of that. Look for the cause of the problem, not for applications affected by that problem.
Sun Oct 19, 2008 7:50 pm View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.