Hi Guys

I'm hoping for some advice on the following:

I have an ASP web application that calls a VB6 COM object. The VB6 class uses ADO to interact with the back-end Access database.

The Access database has now been upsized to SQL Server.

Due to time & cost constraints, the VB class cannot be amended to connect directly to the new SQL Server database. This means that Access is going to continue to be used but with linked tables via ODBC...

The problem we're experiencing is that the performance of certain queries has deteriorated causing timeouts. I realise we have essentially introduced another layer but are there any suggestions on how to progress this with the continued use of Access?

Thanks in advance.