adding a table adapter problem

[Guest]

hey all,
i'm trying to add a table adapter to my dataset and i get to the very end
where it says it generates all the statements just fine, and i hit the finish
button and i get an Access Denied error and that's all the message says
(nothing more descriptive).

i'm using sqlexpress locally and i'm not sure if that has anything to do
with it?

thanks,
rodchar