Could anyone point me in the direction of a check list re: MS Access drive websites. I have a site (created by a develope who dissapeared) which is running VERY slow (even localy). It takes the site about 20-25s to load a page.........EVEN localy.
While I know that Access is not meant to be used for a website, this will be the case for a while for this particular site. It's not live yet so there's not much traffic except me testing etc.
The other issue is that the connectionstring is in the dll and as I'm quite new to all of this I'.m not sure as to how I can make changes.
Thanks for your time.
p.s. the connection stirng in the dll looks like this: "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + ConfigurationSettings.AppSettings["Access"] + ";Persist Security Info=False";
and the appSettings Key is <add key="Access" value="D:\Sites\SiteName\db.mdb"/>
Which I can't see how this would create speed issues as it seems fine.
I'm hoping ot change this at some stage to SQL but the dll issues is another stumbling block.