Access database performance

My site using an Access DB is running really slowly. How do I check to see if it the DB or should it even be the DB? The data access routines are not that complex (basic insert and select commands not complicated).

Can someone help me?

 

This is difficult to answer because Access was not intended to be a server side database. You cannot remotely connect to it and test out the performance. I suggest you download your Access db and run the scripts your application calls on directly on your Access database. You may need to modify the SQL scripts and make sure it is optimized. If you have long join statements, you may want to rewrite it to be more optimized. If you continue to experience the latency, you may want to consider upgrading to a SQL 2005 database.

 

...one additional note:
I used Access for a Shoutbox on DASP servers for added security.
(Separating attacks from the SQL Server DB on the same site.)

What would kill the Shoutbox performance was more than 10 users on-line.
This is one of the things Raymond is referring to and something to keep in mind.
Access is very useful but it is not a replacement for SQL Server.
All the best,
Mark