I manage a website that makes use of several Access databases to generate
dynamic content. I would like to ensure that my code approach does not
produce inefficiencies.
I use the same code in multiple asp pages to open data connections (that
is
the same variable names, although the connection could be to a different
database).
My common code:
Set conn = server.createobject("adodb.connection")
DSNtemp="DRIVER={Microsoft Access Driver (*.mdb)}; "
DSNtemp=dsntemp & "DBQ=" & server.mappath("/database/kassaa.mdb")
conn.mode = 3 ' adModeReadWrite
conn.Open DSNtemp
Could this present a problem?
Thanks in advance.
Bob Mullen
