MS Access / SQL redirection problem

Hi, here is a DB development query I'd appreaciate help on.

I have an in-house application which stores data to an Access 97 file locally on the hard disk, accessed via the "Microsoft Access Driver" in ODBC Administrator.

I'd like to replace this access file with a remote SQL Server DB accessed via the Microsoft SQL Server driver in ODBC. Is there any ODBC driver (or other means) which would be capable of redirecting the communications from the Microsoft Access Driver to a SQL server, so that I could centralise these local DBs running on client machines to a single location?

It would clearly need to translate simple SQL store and retrieve operations in a way that could be understood at both ends. Is this even something that I could write myself?

I'm afraid re-writing the client application code is not an option.

Thanks in advance.

Kevin.