Link Table

i have a link table in access which is linked to SQL Server, by opening the linked table itself, i could see the records etc, but if i try to access the link table through vb coding, it is saying that i dont have permission to SQLServer. How to overcome this issue.

Many Thanks

Syed