ALTER foxpro 2.6 table without auto-upgrading -> foxpro xxx using oledb

I've got a foxpro 2.6 database. I've tried using the ALTER TABLE command but it upgrades the table format to a new one. (probably 9.0).

Is there any way to add a column without having the provider do that?
anything I can add to the connection string?

It has to stay in 2.6 because of other requirements. I'm using the latest FoxPro Oledb Provider within a vb.net app that i wrote to write queries.

0 answers