Hi

I'm converting an embedded database application to MSSQL and I'm getting a consistent error on converting a couple of tables. (DataFlex 19.1, Driver DLL version 6.3.0.15)

Example:
Code:
Converting Recnum table: 15, PRICES, Product Prices
Start time: 25/03/2021 15:53:43.484
Starting restructure transaction.
Creating new table.
Creating primary key Prices001_PK.
Creating index Prices002.
Creating index Prices003.
Creating index Prices004.
Creating index Prices005.
Creating index Prices006.
Creating index Prices007.
Creating index Prices008.
Creating index Prices000.
Creating intermediate file.
Commit restructure transaction.
Temporary delete of all indices of table Prices.
Dropping primary key Prices001_PK.
Dropping index Prices000.
Dropping index Prices002.
Dropping index Prices003.
Dropping index Prices004.
Dropping index Prices005.
Dropping index Prices006.
Dropping index Prices007.
Dropping index Prices008.
All records copied.
Re-creating temporary deleted indices of table Prices.
Creating primary key Prices001_PK.
Creating index Prices000.
Creating index Prices002.
Creating index Prices003.
Creating index Prices004.
Creating index Prices005.
Failed to create index Prices005 of table Prices.
Creating index Prices006.
Creating index Prices007.
Creating index Prices008.
Failed to recreate 1 indices.
ERROR 4118: Cannot delete file
End time: 25/03/2021 15:53:46.434
Total time to convert table: 0:0:0:2.95
In this case Index.5 is a single segment - an ASCII 18 column.

I've tried Reindexing the embedded table - no problems.

I've tried removing that Index and then converting the table again (after deleting it in the SQL Server Management Studio - as you can see from the above, the Wizard couldn't seem to delete the table itself), which works, but when I go to recreate the index I get:
Click image for larger version. 

Name:	Screenshot 2021-03-26 at 16.00.08.jpg 
Views:	46 
Size:	89.4 KB 
ID:	14452

Now I can't find the stupid thing in the Managment Studio to get rid of it:
Click image for larger version. 

Name:	Screenshot 2021-03-26 at 16.10.20.jpg 
Views:	24 
Size:	86.0 KB 
ID:	14453

So... what to do? Where is it hiding?

Mike