Hello all,

Using SQL server 7.0
Access 2000

I have created a database for one of my users and at the time the database was created I also imported some excel books. The tables which were created as a result have dbo ownership.

I have created an NT login for this user (in EM) and given her database owner permissions on the database. She also has full permissions on all of the user objects in the database.

However when she tries to insert into any of these tables she gets an error indicating there is something wrong with the SQL statement. Trust me there aint .. its a simple insert query. The SQL validates fine but as soon as it is executed it errors.

She has created other database objects (namely tables and views) which have her login as the owner. I have set permissions on these for her aswell. EM lets me set them, but as soon as I view her permissions they have reverted back to unchecked.

So in summary. I can set permissions for anything owned by dbo but not for anything owned by her. In addition it doesnt seem to make any difference as she is not able to do any inserts. I can from EM into both tables owned by dbo and her.

Has anybody got any idea what is going on.

Many thanks in advance,
Simon Rigby
London UK