Suggestions please...

[AcceSs-AbLe]

Hello,

I currenly have an access database which holds about 60 queries and is about 1.8 GB. The main problem I am having is the slower response times while running queries. I try to compact/repair the database frequently but the size does not change nor the peformance. Therefore, I was thinking about migrating to SQL server, I heard it can significantly speed up query completion times as well as result in reduced disk space. I would appreciate if anyone can provide some suggestions on this topic or any other options that can increase the performance of Access.

Thanks.

 

[bat17]

Having the tables indexed properly can speed things up.
Have you tried Tools>Anaylze>Performace for tips?

HTH

Peter

 

[AcceSs-AbLe]

I have tried that as well. Would it be difficult to convert to SQL Server? or Is it worth it?