-----Original Message-----

From: Chris Covert [mailto:ccovert@a...]

Sent: 05 May 2000 13:36

To: support@w...

Subject: support Beginning ASP Databases



Hi



I have been using the Book:



Beginning ASP Databases

ISBN: 1-861002-72-6



I have 3 questions:



1. The DSN ODBC connection we made to the test database using the asp test

on page 75 only allows one connection at a time. When the asp page is 

loaded

it does not allow another reload occur for about 2 minutes. If I try to

reload the asp page before this elapsed timeout period I recieve a an 

error

message.

How can I connect as often as I want and have multiple users connect

simultaneously?





2. I spent the entire day getting the ASP test page on page 75 to work.

I had to completely open up my MS NT 4.0 sharing and NTFS permissions. I 

had

to give my web site users group full access to everything. It worked. I 

then

redid my security permissions and gave access only to appropriate

directories. Thus far I have program files/common files/system/ado with 

full

access.I also had to give web site users group ( this is a user made group 

)

full access to my WinNT folder but not the sub directories.



How do I run ADO ODBC without having to resort to this poorly implemented

security.



I understand that full access needs to be granted so that the .lbl file 

can

be created and destroyed upon database access.



3. When ever the MS access database is accessed a TMP file is created in 

the

WinNT folder.

   How can I change this folder so that they do not appear there? I would

prefer if these files were later deleted automatically so they don't

unecessarily clog up my WINNT folder.



If i could specify were these files are created I could put permissions on

this folder without comprising the integrity of my WINNT folder.





Would you please help, advice, or provide direction(resources, forums,

websites,etc).

Or forward this message to the appropriate address.





thank you



Chris Covert

Auracom

See comments throughout...



> How can I connect as often as I want and have multiple users connect

> simultaneously?



Are you sure that you are closing all your connections and recordsets?



if you open oConn, then you need:



oConn.close

set oConn = nothing



etc



> I understand that full access needs to be granted so that the .lbl file

> can

> be created and destroyed upon database access.



This needs to be given to the folder that your Access database is in, NOT

your WindowsNT folder. However you'll still need to give your web users

group access to necessary .dlls like asp.dll, the MDAC dlls etc - they'll

need read access for those...



> 3. When ever the MS access database is accessed a TMP file is created in

> the

> WinNT folder.

>    How can I change this folder so that they do not appear there? I would

> prefer if these files were later deleted automatically so they don't

> unecessarily clog up my WINNT folder.

> If i could specify were these files are created I could put permissions on

> this folder without comprising the integrity of my WINNT folder.



How about setting your TEMP environment variable for the requisite users?

You can use the System Control Panel to do this...



Cheers

Ken