RE: Server Error in '/Access' Application



Hey Dennist,

Thanks for your reply. After some further testing in an IIS based web
project ( thought I don't think this is the cause...), I was able to
reproduce the problem you met in some certain condition... And seems
the cause of the problem is VS.NET IDE. I'm not sure whether you've ever
view the access database through the VS.NET IDE's Server Explorer? Based
on my test, if we ever view the data in access mdb file through VS.NET
IDE's server explorer, but didn't close the connection, then at runtime,
the page using that access database will throw the exception indicate that
the mdb file is used by other process. So please have a check in your
VS.NET's server explorer to see whether there is connection to that mdb
file. If so, please select it and choose close the connection or just
delete the connetion and test again to see whether this helps.

Thanks,

Steven Cheng
Microsoft Online Support

Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)

--------------------
| Thread-Topic: Server Error in '/Access' Application
| thread-index: AcXw9bzcNW84Q8jSQzKfOq1Z+ojcng==
| X-WBNR-Posting-Host: 85.64.135.196
| From: "=?Utf-8?B?ZGVubmlzdDY4NQ==?=" <dennist685@xxxxxxxxxxxxxxxx>
| References: <C33B5093-7B02-4F0C-88FD-0B7903FAB51F@xxxxxxxxxxxxx>
<BvpTWeL8FHA.1240@xxxxxxxxxxxxxxxxxxxxx>
<5BD333AE-5B96-4C14-952F-D5A76929B8F3@xxxxxxxxxxxxx>
<BXMbbgN8FHA.4000@xxxxxxxxxxxxxxxxxxxxx>
<2A25A63B-4DCF-4ADB-91A3-D2DFCF6EC0DC@xxxxxxxxxxxxx>
<L8MwnGP8FHA.1240@xxxxxxxxxxxxxxxxxxxxx>
| Subject: RE: Server Error in '/Access' Application
| Date: Thu, 24 Nov 2005 04:51:07 -0800
| Lines: 6
| Message-ID: <59638A65-3369-4B09-842B-135833874094@xxxxxxxxxxxxx>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.dotnet.framework.aspnet
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
| Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: TK2MSFTNGXA02.phx.gbl
microsoft.public.dotnet.framework.aspnet:360712
| X-Tomcat-NG: microsoft.public.dotnet.framework.aspnet
|
| Steven,
|
| If I open the same project in, say, c:\vs2005web\Access, then it shows.
| It's only when I put it in inetpub that I get the error.
|
| dennist685
|

.



Relevant Pages

  • RE: How to: List a table in Tables holder of Server Explorer
    ... 1.Click Connect to Database icon in Server Explorer. ... button in Add Connection window. ... 3.Select "Microsoft ODBC Data Source" from Data source list in Change Data ... 5.Select MS Access Database from Computer Data source. ...
    (microsoft.public.vsnet.general)
  • Re: Need help in VB.NET connecting to Access database
    ... >provier to MS Jet 4.0 OLE DB PRovider, then back to the Connection tab. ... create the data connection using Server Explorer no problem. ... Private Sub Button1_Click(ByVal sender As System.Object, ... perhaps as part of a Custom installation that may be missing? ...
    (microsoft.public.dotnet.languages.vb)
  • Re: ComboBox Row Source = Result of DB Query?
    ... The easiest way would be to drag the table from server explorer (you ... will need to create a new DB connection to the access table in the ... required connections and adapters get automatically setup, ... > I have an access database and I want to populate a combo box with the ...
    (microsoft.public.dotnet.framework.windowsforms)
  • Drag/Drop SQL Connection Fails
    ... I've been working on using "Server Explorer" to ease the creation of my ... The problem occurs when I drag/drop the connection into a new page, ... try to adjust the connection string in the Properties window of the ...
    (microsoft.public.vsnet.ide)