>When the table resides on the server the odbc works?

ODBC is most often used to access data on a remote DataServer FROM a WebServer or any other machine connected by a network to the DataServer.

I don't know how to open a local dbf from ASP but I'm sure there are others here who do.