| re: The Microsoft Jet database engine cannot open the file
Nevermind :P
If you look closely, the Data Source={0} which was supposed to be set using
String.Format before opening the connection.
"Morten Wennevik" <MortenWennevik@hotmail.com> wrote in message
news:%23RuzOjg3FHA.3880@TK2MSFTNGP12.phx.gbl...[color=blue]
> I'm transferring an Excel file from a client computer to a web-page on a
> server, then trying to open the file on the server causes this exception
> message to occur.
>
> The Microsoft Jet database engine cannot open the file ''. It is already
> opened exclusively by another user, or you need permission to view its
> data.
>
> I open the file using this connection string
>
> Dim connString As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data
> Source={0};Extended Properties=" & Convert.ToChar(34).ToString() & "Excel
> 8.0;HDR=No" & Convert.ToChar(34).ToString()
>
> The file is put into the ASPNET temp folder and the ASPNET account has
> full control over that folder, but no matter where I put the file, or even
> if I set Everyone to full control on the file, the jet engine still fails.
>
> The Microsofts KB article on the error refers to the web guest account,
> but I am unable to set user permissions for this user (IUSR_<machine>) as
> it does not seem to exist.
>
> Any suggestions?
>
>
> Morten
>[/color]
| 
