Access database suddenly slow
Posted on 2012-04-06
I am developing an application on vb.net using access as my database.
I have been developing on the access database file for more than 5 months now and it was working very fast until for the past two days, even the simplest sum filter and query takes up to 5 to 8 seconds delay.
I am sure that I did not make any changes to the database or to the connectivity on the vb.net code. i am using the same kind of connectivity code as i was using for the past 5 months.
Also i was using the database file on my local machine and also on my shared computer across the network, and never got a problem.
After the delay started, i even put the database file on the local machine and tried working with it, but still it has got the same delay.
Could you please help me to make it run faster. The size of the database file is around 800kb.
Thanks in advance.