non-ODBC connection for Access/SQL Server link

[wbfoto]

I am grasping for straws here (legacy system). I have an access database that links to a SQL Server 2000 database. For obvious security reasons, I need to scratch the ODBC connection, but the Access interface is so user-friendly (forms, reports, etc.). Is there a method to get around the ODBC connection - like a hybrid link to an asp page with the appropriate connection string. I know that it would require internet access, but that is not a problem.

Thanks,
William

 

[PNC]

William -

You can try converting your MDB file into an ADP (Access Data Project), it uses a direct connection to SQL Server via OLE DB.

- PNC.