I need to run a simple select query in MS Access Database
Select * from <tablename>
The above query fails throwing "Connection does not exist.. Call failed" error.
The problem is that I think there is something wrong with my permissions to access that table. I now want to run the same query acting as a different user who has the permissions.
Can I do that in MS Access? Something like,,
EXECUTE AS USER = 'domain\someuser';