 |
SoftTree Technologies
Technical Support Forums
|
|
Author |
Message |
sangha
Joined: 19 Dec 2006 Posts: 18
|
|
ODBC Error MS Access |
|
I am getting the following error while trying to join in MS Access :-
 |
 |
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 |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7948
|
|
|
|
The error says "no read permission on 'MSysRelationships'." So, what's you question?
|
|
Sun Oct 19, 2008 12:32 am |
|
 |
sangha
Joined: 19 Dec 2006 Posts: 18
|
|
|
|
My question is how to get read permission to the table. Relationships cannot read because of this.
|
|
Sun Oct 19, 2008 4:32 am |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7948
|
|
|
|
 |
 |
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 |
|
 |
sangha
Joined: 19 Dec 2006 Posts: 18
|
|
|
|
I am logged in as Admin. If I am in the mdb I can open the table.
|
|
Sun Oct 19, 2008 7:44 pm |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7948
|
|
|
|
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 |
|
 |
|
|
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
|
|
|