Hi All, check this out. How the heck do i get around this?????<BR><BR><BR>[5/6/1999 12:32:50] Initilising Import Test<BR>[5/6/1999 12:32:50] Locating File : \Ntws1NTWS1<BR>CWINNTProfilesAdministratorDesktopP roduct Catalogue100MB.txt<BR>[5/6/1999 12:32:50] File Permissions Failed.<BR>[5/6/1999 12:32:50] Unsucessful Location! Error: 70; Microsoft VBScript<BR>runtime error; Permission denied<BR>[5/6/1999 12:32:50] Import Test Failed.<BR><BR><BR>i can load the SAME file perfectly, if i hardcode the file and file location<BR>in the asp code, and the path is relative to the IIS server. EG. if i type<BR>the path as :-<BR>"CWINNTProfilesAdministratorDesktopProduct Catalogue100MB.txt" ...<BR><BR>the reason i don&#039t want to hard code this file name, is i want to use the<BR>BROWSE button, available in HTML &#060;input type="file" ... etc...<BR><BR><BR>on the first page that lets you FIND / SELECT the file to open, here is a<BR>snippit from the bottom of the html page.<BR><BR>--- snip 8&#060; ----<BR><BR>&#060;center><BR> &#060;input type="file" name="importFile" size="60"><BR> <BR><BR> <BR><BR> &#060;input type="submit" value=" import new products "><BR>&#060;/center><BR>&#060;/form><BR><BR>-- end snip 8&#060; -----<BR><BR><BR><BR>now, here is the code for trying to OPEN the file to read it&#039s contents...<BR><BR><BR><BR>&#060;!-- #include virtual = "/asp/_common/header.asp" --><BR>&#060;%<BR>&#039 File: productImportTest.asp<BR>&#039 Created: 29th April 1999<BR>&#039 Info: imports the file into the table.<BR><BR>&#039 Variables<BR>&#039 ^^^^^^^^^<BR> DIM importFile : importFile = ConvertToSQL(Request("importFile"))<BR> DIM columnHeader : columnHeader = -1<BR> DIM columnData : columnData = -1<BR> DIM errorRecieved : errorRecieved = False<BR> DIM headerCount : headerCount = 0<BR> DIM dataCount : dataCount = 0<BR> DIM numberRows : numberRows = 0<BR> DIM multiple : multiple = 0<BR><BR> &#039importFile = "c:series28.txt"<BR> importFile = "c:PC75MB.txt"<BR><BR> Set ConnDB = Server.CreateObject("ADODB.Connection")<BR> ConnDB.Open DB_CONNECT_STR<BR>&#039---------------------------------------------------------------------------<BR>--------<BR>&#037;&#062;<BR>&#060;html><BR>&#060;head><B R> &#060;!--#include virtual="/asp/_common/stylesheetsCheck.asp"--><BR> &#060;title>Test Page&#060;/title><BR>&#060;/head><BR>&#060;body><BR><BR><BR><BR><BR>&#060;tabl e align="center" border="0" cellpadding="2" cellspacing="2"<BR>width="700"><BR>&#060;tr>&#060; td>[&#060;% WriteGetDateTime &#037;&#062;] Initilising Import Test&#060;/td>&#060;/tr><BR>&#060;tr>&#060;td>[&#060;% WriteGetDateTime &#037;&#062;] Locating File : &#060;%=importFile&#037;&#062;&#060;/td>&#060;/tr><BR>&#060;%<BR><BR> Set objFilePermissionCheck = Server.CreateObject("MSWC.PermissionChecker")<BR> permissionCheck = objFilePermissionCheck.HasAccess(importFile)<BR><B R> If permissionCheck Then<BR>&#037;&#062;<BR>&#060;tr>&#060;td>[&#060;% WriteGetDateTime &#037;&#062;]&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;File<BR>Permissio ns OK.&#060;/td>&#060;/tr><BR>&#060;% Else &#037;&#062;<BR>&#060;tr>&#060;td>[&#060;% WriteGetDateTime &#037;&#062;]&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;File<BR>Permissio ns Failed.&#060;/td>&#060;/tr><BR>&#060;%<BR> End If<BR><BR> If errorRecieved = False Then<BR><BR> &#039On Error Resume Next<BR><BR> Set objFSO = CreateObject("Scripting.FileSystemObject")<BR> Set objImportFile = objFSO.OpenTextFile (importFile)<BR><BR> Select Case Err.Number<BR> Case 0 &#039OK, do nothing<BR> Case 50, 53 &#039File or path not found.<BR> errorRecieved = True<BR> strErrorDescription = "Import File or Path not found."<BR> strErrorSource = "productImportTest.asp"<BR> Err.Raise Err.number, Err.Source, Err.Description<BR> Case Else<BR> errorRecieved = True<BR> Err.Raise Err.number, Err.Source, Err.Description<BR> End Select<BR><BR> If errorRecieved = False Then<BR>&#037;&#062;<BR>&#060;tr>&#060;td>[&#060;% WriteGetDateTime &#037;&#062;]&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;File Located<BR>Successfully.&#060;/td>&#060;/tr><BR>&#060;% Else &#037;&#062;<BR>&#060;tr>&#060;td>[&#060;% WriteGetDateTime &#037;&#062;]&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Unsucessful<BR>Locat ion! Error: &#060;%=Err.number&#037;&#062;; &#060;%=Err.source&#037;&#062;;<BR>&#060;%=Err.Des cription&#037;&#062;&#060;/td>&#060;/tr><BR>&#060;%<BR> End If<BR><BR> If errorRecieved = False Then<BR>&#037;&#062;<BR>&#060;tr>&#060;td>[&#060;% WriteGetDateTime &#037;&#062;]&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Checking<BR>Heade r Row.&#060;/td>&#060;/tr><BR>&#060;%<BR><BR>&#039 --------------------------------------------------------------------------<BR>--------------------------<BR> row = objImportFile.ReadLine<BR>&#039 Loop thru until the last header item<BR><BR><BR>... etc.....<BR><BR><BR><BR><BR><BR>If you need anything else, ask away again.<BR><BR>- Pure Krome -