my access db has around 1800+ records and around 20 tables;
there is one table in there that houses all the 1800+ records and their particulars; there are other tables that house bout 3600 records in there..but somehow, this table always seems to take the longest to load;
whenever i open this table, my access DB will take a year and a half to open the next time i try to open the DB (bout 10 mins). once its open, subsequent times, it takes less than 5 secs;
if i dont open this specific table, it opens in <5 secs all the time;
why is it this the case? i hate having to wait for 10 mins;
2. What happens when the backend and frontend on te same computer
hope this help
See clear as mud
the aim is store once, not store multiple times
Remember... Optimize 'til you die!
Progaming environment: Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010 VB based on my own environment: vb6 sp5 ASP based on my own environment: 5.6 VB-NET based on my own environment started 2007 SQL-2005 based on my own environment started 2008 MYLE YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.