CREATE TABLE problems: Insufficient privileges.

CREATE TABLE problems: Insufficient privileges.

schema:scott

The user account must be set up to permit tables to be created. Usually the database administrator must grant such permissions.

GRANT CREATE ON d_db TO scott

GRANT RESOURCE TO scott

Users must be granted CREATE on the database.

Make sure that the mdb file is not read only. You also may need write permission on the directory containing the mdb, this is because Access needs to create and ldb file.

Users must be granted RESOURCE to create tables.

CREATE and DROP Operations

CREATE a new table

DROP a table

Composite primary key

CREATE a foreign key

CREATE a VIEW

Autonumber fields

ALTER TABLE ... ADD COLUMN

ALTER TABLE ... DROP COLUMN

ALTER TABLE ... ADD constraint

CREATE TABLE problems: Invalid column name.

CREATE TABLE problems: Insufficient privileges.

CREATE TABLE problems: Table already exists.

DROP TABLE problems: Foreign key references.

CREATE TABLE problems: Foreign key references.

Rename column