I'm not that bothered myself. However, I need a copy of a client's database but he's reluctant to give me a copy, unless its purged of all sensitive information. And...

The UPDATE permissions are denied on the Personnel_Records table. The required UPDATE permissions are granted to the user (via their membership of the 'Team Name Users Group' role)...

OK, a typical UPDATE that fails is:

UPDATE Team_Current_Employees

SET FORENAMES = '',

 SURNAME = '',

 UNIT_SECTION = '',

 CONTRACT_TYPE = '',

 PAY_POINT_NUMBER = '',

 INTERNAL_PHONE = '',

 CONTRACT_TERM...

Login being used is 'jon', who is a member of just the 'SysGroup' and 'Team Name Users Group' roles.

DDL for user, roles, table and view :

if exists...

A little bit more information if it helps.

The view definition lists the columns in no particular order. If I list the columns in alphabetic order then no 'UPDATE PERMISSION...

Do you have the 'auto close' option set for your databases. Try taking this option off, and see if you still get suspsect databases.

Can't you use 'text' or 'ntext' columns? This'll allow you to have all of your large character columns in a single table, but of course reading/writing the data will be...

If you need the current date in a UDF you can also fudge it a little bit by performing the following query in the UDF :

    DECLARE @dtDate datetime

    SELECT...

More information :

• CursorLocation is adUseServer (recordset works fine if opened as a client-side cursor, but I really need it to be server-side)
• SQLOLEDB is the provider for my ADO connection

Thanks

More info - I can open a Keyset recordset okay IF the lockType is ReadOnly. Any other lockType and the cursorType gets automatically set to forwardOnly and the lockType gets...

Still no solution Frank, but thanks for you comments.

I've come across another problem (ADO issue - so I guess its not for this forum) which means I'm going to...

Sachin, I tried you suggestion (including the 'dbo' prefix on the UDF name) and still got an error as follows:

Invalid object name 'dbo.udf_Test'

Thanks for the prompt replies.

Sachin, I tried your suggestion but got the following error:

'udf_Test' is not a recognized function name

kcdunn, I wanted to use the UDF in a view definition,...

Check your version of MDAC.

MDAC 2.6 had an error in it which stopped the error description being returned from SQL. This was fixed in MDAC 2.6 sp1.