Can not add field to table

J

Jason

When trying to add a field to an existing table I get:
Run-time error '3033':
You do not have the necassary permissions to use the 'Task' object. Have
your system administrator or the person who created this object establish
the appropriate permissions for you.

The code is:
db.Execute "ALTER TABLE [" & rst!TableName & "] ADD [" & rst!FieldName & "]
" & rst!FieldType 'add new field to table

I can manuall add the fields fine!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top