wallacef
December 9th, 1999, 04:27 AM
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
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