I am creating a system in access file size roughly 5mb, it is taking 5 minutes to load the complete system, any ideas on why this takes so long?how can i rectify this problem.
I am creating a system in access file size roughly 5mb, it is taking 5 minutes to load the complete system, any ideas on why this takes so long?how can i rectify this problem.
It could be many things. Are you loading over a network?
yes as the system works fine on my home computer however at my college network it does not, havent found any restrictions that would cause this .. thanks for the reply
Go to Tools....Options
Under the General tab, make sure all "Name AutoCorrect" options are turned off.
Make sure front and back end MDB's are compacted.
You could also try changing the "Subdatasheet Name" property for all tables to "[None]"