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: 7966
|
|
|
|
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: 7966
|
|
|
|
 |
 |
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: 7966
|
|
|
|
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 |
|
 |
|