Unanswered: Problem: ALTER TABLER with Jet as provider
I have this problem where I want to rename a field in a table in my Access
DB and then move it before another field in the same table. This is proving
to be very difficult because the ALTER TABLE command in the Jet engine
doesn't allow you to MOVE or RENAME any of the fields!
here's my code:
'I want to delete the old field date and replace it with the
'move the temporary field before the field I want to remove <-- this
cnn.Execute "ALTER TABLE MyTable MOVE TempField BEFORE OldField"
'delete the field I want to remove
cnn.Execute "ALTER TABLE MyTable DROP COLUMN OldField"
'rename the temporary field to "NewField" <--this doesn't work
cnn.Execute "ALTER TABLE MyTable RENAME TempField TO NewField"
I think the ALTER TABLE command is great in SQL and it would be great if I
could use it with the MSJet engine for everything but it doesn't look like I