MSSQL, Access 2000, and ODBC Interplay

To date I've used nothing but MySQL and have loved it.
The company I work for uses MSSQL and Access for their
product database. Here is the situation:
Product Manager has created a product database Products.DBF
This file is saved on the same server as the SQL server.
The goal is to have the SQL server use this DBF file so
that she can update the DB via access.
More info: The purpose of this is such that, when people
visit a certain ASP page, that page queries the SQL server
and pulls the data from the DBF file. I'm assuming this
has to be done via ODBC some how, with which I have some
experience, and I'm sure I'm missing something obvious but
any help would be greatly appreciated."Philip" <phil@.fizur.net> wrote in message news:<021101c33f43$fefd55c0$a501280a@.phx.gbl>...
<<>>
> More info: The purpose of this is such that, when people
> visit a certain ASP page, that page queries the SQL server
> and pulls the data from the DBF file. I'm assuming this
> has to be done via ODBC some how, with which I have some
> experience, and I'm sure I'm missing something obvious but
> any help would be greatly appreciated.
Well.. to my mind there is something obvious...
Store the data in sql server.
Forget my mysql.
Or.
Obtain some odbc driver allows access to connect to mysql and forget sql server.