Columns.Remove Dependancy Problem

  • Hi folks,

    I am using the following:

    sqlTbl.Columns.Remove ColName

    and getting the error:

    [Microsoft][ODBC SQL Server Driver][SQL Server]The object 'DF_Answers_test_1__64' is dependent on column 'test'.

    [Microsoft][ODBC SQL Server Driver][SQL Server]ALTER TABLE DROP COLUMN test failed because one or more objects access this column.

    There is no object I can find of this name. There are no locks on related database objects in current activity.

    Could an open recordset be the problem. All recordset that could be open are disconnected ADO batch-updatable recordsets (at worst). I would not have thought that this would impact column removal.

    Any tips or tricks to avoid this prob would be appreciated.

    Thanks in advance


    Ps. Thanks for your help Andy. Much appreciated.

  • Ignore my problem above -

    I found that it was the DRIDefault that I had set for the column. This must be removed before the column is removed.

  • Makes you appreciate the work EM does behind the scenes on items like this doesnt it?


Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply