|
-
December 9th, 1999, 05:27 AM
#1
Create Table permissions
I am trying to use ADO to CREATE a table in an MSAccess97 database. My ADO connection object logs on as the Admin user.
I have given all the permissions I can see to the Admin user in the database.
When I run the code cnConnection.Execute "Create table NewTable (Field1 string, Field2 string)" I get the following error:
[Microsoft][ODBC Microsoft Access Driver] You do not have the necessary permissions to use the 'NewTable' object. Have your system administrator or the person who created this object establish the appropriate permissions for you. -2147217911
Any ideas where I might be going wrong?
Thanks
Fiona Wallace
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|