>You're right, it's a problem with dbfs. I'm confused because it's happening when I am trying to connect to an SQL backend using remote views. The app shouldn't be trying to open the local dbfs, so why do I still get the error?

I'm not sure why it's choking here. My guess is that it's not the dbf, but the primary key record in the DBC. Have you tried dropping and readding the table, or at least dropping and readding the primary index?

>I haven't tried the DTS wizard. Does it port over all the indexes, default values and so on as well as the data?

No, just the columns and the data. You have to build the tag information and everything else yourself.