Hello Gentlemen,

Hope you're ready for a good new year!

I'm doing some work with Enterprise again and I have a small problem.

I have written another page to display. It uses the same table as several other pages that I have already done, but this one takes a looooooooooong time to load (30 plus seconds sometimes). These are new fields that I have added to an old table. The other pages still load quickly.

Here is the code... Any ideas?

Set MyDb1=Server.CreateObject("ASPdb.ep&#34
MyDb1.dbMDB = Server.MapPath("../Level1/_database/logs2.mdb&#34
MyDb1.dbColor = "4,auto"
MyDb1.dbMode = "both"
MyDb1.dbSQL = "select TechNo,TechNm,MTech,SMTech,FSupv,MDoc,SMain,AMain, AFDemo,ASupp,PntAud,Calib,LeakTrac,DTProt,ATProt,S SForm,NCCklst,ADVFRL FROM [Techs] where Term='NO'"
MyDb1.dbImageDir="../level1/images/"
myDb1.dbNavigation="top"
myDb1.dbNavigationIcon="std"
myDb1.dbStatusBar="false"
MyDb1.dbNavigationItem="filter, resetfilter,update, add, delete"
MyDb1.dbUnit="4000"
MyDb1.dbGridInc=150
MyDb1.dbGridTableTag = "BORDER=1"
MyDb1.dbGridDisplayFlds="TechNo,TechNm,MTech,S MTech,FSupv,MDoc,SMain,AMain,AFDemo,ASupp,PntAud,C alib,LeakTrac,DTProt,ATProt,SSForm,NCCklst,ADVFRL& #34;
MyDb1.dbFormTableTag="Border=1"
MyDb1.dbFormDisplayFlds="TechNo,TechNm,MTech,S MTech,FSupv,MDoc,SMain,AMain,AFDemo,ASupp,PntAud,C alib,LeakTrac,DTProt,ATProt,SSForm,NCCklst,ADVFRL& #34;

MyDb1.dbEditParams="TableName=Techs, BookMarkFlds=TechNo, tabletag=border=2"
MyDb1.dbEditFlds="TechNo,TechNm,MTech,SMTech,F Supv,MDoc,SMain,AMain,AFDemo,ASupp,PntAud,Calib,Le akTrac,DTProt,ATProt,SSForm,NCCklst,ADVFRL"
MyDb1.dbEditDropFlds="MT,,Droplists,Certs"
MyDb1.dbEditUpdateROFlds="TechNo,TechNm"

nmap = &#34;TechNo, <font FACE=&#39;Arial&#39; SIZE=1>Tech Code</font>,;&#34;
nmap = nmap & &#34;TechNm, <font FACE=&#39;Arial&#39; SIZE=1>Technician</font>,;&#34;
nmap = nmap & &#34;MTech, <font FACE=&#39;Arial&#39; SIZE=1>MT</font>,;&#34;
nmap = nmap & &#34;SMTech, <font FACE=&#39;Arial&#39; SIZE=1>SMT</font>,;&#34;
nmap = nmap & &#34;FSupv, <font FACE=&#39;Arial&#39; SIZE=1>FS</font>,;&#34;
nmap = nmap & &#34;MDoc, <font FACE=&#39;Arial&#39; SIZE=1>MD</font>,;&#34;
nmap = nmap & &#34;SMain, <font FACE=&#39;Arial&#39; SIZE=1>SM</font>,;&#34;
nmap = nmap & &#34;AMain, <font FACE=&#39;Arial&#39; SIZE=1>AM</font>,;&#34;
nmap = nmap & &#34;AFDemo, <font FACE=&#39;Arial&#39; SIZE=1>AFD</font>,;&#34;
nmap = nmap & &#34;ASupp, <font FACE=&#39;Arial&#39; SIZE=1>ASP</font>,;&#34;
nmap = nmap & &#34;PntAud, <font FACE=&#39;Arial&#39; SIZE=1>15P</font>,;&#34;
nmap = nmap & &#34;Calib, <font FACE=&#39;Arial&#39; SIZE=1>CAL</font>,;&#34;
nmap = nmap & &#34;LeakTrac,<font FACE=&#39;Arial&#39; SIZE=1>LT</font>,;&#34;
nmap = nmap & &#34;DTProt, <font FACE=&#39;Arial&#39; SIZE=1>DTP</font>,;&#34;
nmap = nmap & &#34;ATProt, <font FACE=&#39;Arial&#39; SIZE=1>ATP</font>,;&#34;
nmap = nmap & &#34;SSForm, <font FACE=&#39;Arial&#39; SIZE=1>SSF</font>,;&#34;
nmap = nmap & &#34;NCCklst, <font FACE=&#39;Arial&#39; SIZE=1>NCC</font>,;&#34;
nmap = nmap & &#34;ADVFRL, <font FACE=&#39;Arial&#39; SIZE=1>ADV</font>,;&#34;
MyDb1.dbNameMap = nmap

mcell = &#34;TechNo, Align=left, <font FACE=&#39;Arial&#39; SIZE=1 COLOR=Blue>#TechNo#</font>;&#34;
mcell = mcell & &#34;TechNm, Align=left, <font FACE=&#39;Arial&#39; SIZE=1 COLOR=Blue>#TechNm#</font>;&#34;
mcell = mcell & &#34;MTech, Align=left, <font FACE=&#39;Arial&#39; SIZE=1 COLOR=Blue>#MTech#</font>;&#34;
mcell = mcell & &#34;SMTech, Align=left, <font FACE=&#39;Arial&#39; SIZE=1 COLOR=Blue>#SMTech#</font>;&#34;
mcell = mcell & &#34;FSupv, Align=left, <font FACE=&#39;Arial&#39; SIZE=1 COLOR=Blue>#FSupv#</font>;&#34;
mcell = mcell & &#34;MDoc, Align=left, <font FACE=&#39;Arial&#39; SIZE=1 COLOR=Blue>#MDoc#</font>;&#34;
mcell = mcell & &#34;SMain, Align=left, <font FACE=&#39;Arial&#39; SIZE=1 COLOR=Blue>#SMain#</font>;&#34;
mcell = mcell & &#34;AMain, Align=left, <font FACE=&#39;Arial&#39; SIZE=1 COLOR=Blue>#AMain#</font>;&#34;
mcell = mcell & &#34;AFDemo, Align=left, <font FACE=&#39;Arial&#39; SIZE=1 COLOR=Blue>#AFDemo#</font>;&#34;
mcell = mcell & &#34;ASupp, Align=left, <font FACE=&#39;Arial&#39; SIZE=1 COLOR=Blue>#ASupp#</font>;&#34;
mcell = mcell & &#34;PntAud, Align=left, <font FACE=&#39;Arial&#39; SIZE=1 COLOR=Blue>#PntAud#</font>;&#34;
mcell = mcell & &#34;Calib, Align=left, <font FACE=&#39;Arial&#39; SIZE=1 COLOR=Blue>#Calib#</font>;&#34;
mcell = mcell & &#34;LeakTrac, Align=left, <font FACE=&#39;Arial&#39; SIZE=1 COLOR=Blue>#LeakTrac#</font>;&#34;
mcell = mcell & &#34;DTProt, Align=left, <font FACE=&#39;Arial&#39; SIZE=1 COLOR=Blue>#DTProt#</font>;&#34;
mcell = mcell & &#34;ATProt, Align=left, <font FACE=&#39;Arial&#39; SIZE=1 COLOR=Blue>#ATProt#</font>;&#34;
mcell = mcell & &#34;SSForm, Align=left, <font FACE=&#39;Arial&#39; SIZE=1 COLOR=Blue>#SSForm#</font>;&#34;
mcell = mcell & &#34;NCCklst, Align=left, <font FACE=&#39;Arial&#39; SIZE=1 COLOR=Blue>#NCCklst#</font>;&#34;
mcell = mcell & &#34;ADVFRL, Align=left, <font FACE=&#39;Arial&#39; SIZE=1 COLOR=Blue>#ADVFRL#</font>;&#34;
MyDb1.dbMagicCell = mcell

MyDb1.ASPdbEP

Thanks,

Kim