>No, that won't work. I'm creating a Class that will be used to generically work with free tables. All I will know is the path to the DBF.

Okay, so it's not really that the tables are free, but that you can't create stored procedures.

FWIW, my first thought was that in your command you weren't setting Exclusive On. So, I tried a quick test to do that, and that didn't help. The hiccup comes on the index command. I don't see anything in the help file for the Fox OLEdb provider that indicates INDEX ON isn't supported. The only meager suggestion I have is to break up the commands so you can at least see what each step is returning.

For example, you're probably going to be trapping the fact that the tag already exists or that you can't get exclusive use?