September 11, 2001 at 12:28 am
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
Dave
Ps. Thanks for your help Andy. Much appreciated.
September 11, 2001 at 1:17 am
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.
September 11, 2001 at 4:56 am
Makes you appreciate the work EM does behind the scenes on items like this doesnt it?
Andy
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply