Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
HomeAnnouncementsFree MagazinesWhite PapersSubmit Content
Discussion GroupsASP.NETWindows FormsLanguages.NET FrameworkVisual Studio.NET
Articles.NET FrameworkASP.NETToolsWindows Forms
.NET DirectoryOpen Source ProjectsUser GroupsWeb Resources
Related Topics
Visual Basic 6SQL ServerMS AccessOther DB ProductsMS Server ProductsMore Topics ...

.NET Forum / ASP.NET / General / October 2005

Tip: Looking for answers? Try searching our database.

The Microsoft Jet database engine cannot open the file

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Morten Wennevik - 31 Oct 2005 11:49 GMT
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
Morten Wennevik - 31 Oct 2005 12:18 GMT
Nevermind :P

If you look closely, the Data Source={0} which was supposed to be set using
String.Format before opening the connection.

> 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
[quoted text clipped - 21 lines]
>
> Morten

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...

Oracle MagazineNetwork ComputingComputer WorldBio-IT WorldeWeekInformation WeekInfosecurity
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.