Linked table permissions in access

[Si]

Hi

I am writing to a linked table in Access, using ADO from VB and I keep
getting the error:

3112 Record(s) cannot be read; no read permission on <table name>

I can access the table without a password directly through access, if i run
the code in VBA it works, but when i run it in VB6 it brings up this error.

Is there any way around this?

Thanks Si