Thanks for immediate response,,,! as it is one of those days where I've got to get something going for a client asap. :)

>>In a valid database I have one important stored procedure, getid().
>>
>>If I try to modify it or stored procedures I get:
>>
>>The database item you have selected has been modified or deleted. Do you want to refresh the database now? Yes or No.
>>
>>I can do a USE MYDATABASE.DBC
>>and modify the memo for the source of getid, but then it does not compile the object code. Is there a way to trigger this as a workaround, or is there some solution for this problem?
>>
>>Thanks,
>
>Terry,
>After you modify the memo field, close the table (DBC) and issue a COMPILE DATABASE < MyDDBC > command. That should do it.
>
>HTH.