Website slow when Access is Open

[djohnson60610]

I have an ASP.Net website that connects to an Access 2007 database, as well as Access forms and reports that use the Access application as the frontend.

Problem is, although the website runs great with multiple web connections, it slowdowns 10 or 20 times when the Access frontend database is opened in the application. The database is connecting with linked tables to the backend.

It's weird that the problem only happens if a table or form is opened, and it even happens when a table is opened that the website is not even using. If I open the backend database, I don't even have to open a form or table to make the slowdown happen.

The instant I close the form or table in the frontend, the website goes back to its fast nromal speed.

Has anyone ever seen this?

 

[djohnson60610]

Just as an FYI, the problem still exists but I made it a little better...

Instead of the website connecting to a frontend database, I connected it directly to the backend. Now instead of 20 times slower, the site is about 5 times slower when Access is open. (When Access is closed, reaction time is almost instant.)