Hello all
I use VBA in excel with an ODBC connection but ask for help in an area of the SQL server ID or more correclty the use of it in Excel VBA.

Consider 2 id profiles as
Id 'IOD'
Server Roles : none
Permit in Database Role : public, db_datareader, db_datawriter

Id 'bizinfo'
Server Roles : none
Permit in Database Role : public, db_owner

I want the tool to add and delete records and one area of code is
strSQL = "Delete from Susi_search " & whereclause
rst.Open source:=strSQL, ActiveConnection:=cnn, CursorType:=adOpenKeyset, LockType:=adLockOptimistic

where cnn = "Provider=SQLOLEDB.1;Password=xxxx;User ID=IOD;Initial Catalog=EM2;Data Source=;Network Library=dbmssocn;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=xxx;Use Encryption for Data=False;Tag with column collation when possible=False."


I get an error of "Method of open Object Recordset failed.
the same code WILL work for the more powerful "bizinfo" ID.

I think both should work but .....

is it the.. "CursorType:=adOpenKeyset, LockType:=adLockOptimistic" ?

Ideas why both wont ??

Gerry