Re: Jet Database Won't Open

From: Cor Ligthert (notfirstname_at_planet.nl)
Date: 06/23/04 

Date: Wed, 23 Jun 2004 10:48:58 +0200

Hi Arne,

I thought I did give you the answer in your previous thread and than you
stopped with it, keep your questions in the same thread. Paul did in
addition to my message give you a link to a page which describes the problem
as I told. When that is not the problem you have to look inside the Access
database, however that is almost never the problem.

This question has been so often in this dotNet newsgroups.

See here the answers.

http://tinyurl.com/3bhvp

And again please stay in the same thread, now others could start looking for
an answer and giving you again the same.

Cor

> Well apparently...it didn't work. I have tried to detail my problem as
best I can.
>
> "Paul Clement" wrote:
>
> > On Tue, 22 Jun 2004 09:57:03 -0700, "Arne Beruldsen"
<ArneBeruldsen@discussions.microsoft.com>
> > wrote:
> >
> > ¤ I have a Webform with a Datagrid. I've used the DataAdaptor control
(Ole...) to create the connection string and to create a Dataset. The data
is stored in an Access database. When I use the DataAdaptor to preview the
data (ie...fill dataset) everything appears to be working normally. The
connection seems fine.
> > ¤
> > ¤ However, when I go to run the app (in browser) I get the following
Server error:
> > ¤
> > ¤ The Microsoft Jet database engine cannot open the file
'C:\Inetpub\wwwroot\OnlineTesting\Tests.mdb'. It is already opened
exclusively by another user, or you need permission to view its data.
> > ¤
> > ¤ Obviously...I don't have it open...and I have no permissions set (that
I know of). The only lines of code I have are:
> > ¤
> > ¤ Imports System.Data
> > ¤ Imports System.Data.OleDb
> > ¤ ...
> > ¤ TestsAdapter.Fill(TestsDataSet)
> > ¤ DataList1.DataBind()
> > ¤
> > ¤ I'm new to VBNet and creating Web apps...though I should add...these
steps work fine in a Windows Form.
> > ¤
> > ¤ Is some permission required that I am not aware of?
> > ¤
> > ¤ Any help would be appreciated...
> >
> > I believe that I replied to this in your previous thread.
> >
> >
> > Paul ~~~ pclement@ameritech.net
> > Microsoft MVP (Visual Basic)
> >

Relevant Pages

  • Re: Failed to acces the SQL Server table from MS Access by ODBC Li
    ... How can I provide the user name and password in the connection string? ... My link table is stored in the access database, I have checked the save password check box when I set up the odbc link table. ... because your asp code is running under the context of the ... This email account is my spam trap so I ...
    (microsoft.public.inetserver.asp.db)
  • Re: Hide a cell so that users cant see the contents
    ... thank you Paul for the inspiration. ... a cell equal to the name and that dropped the quotes. ... to use it to build your connection string. ...
    (microsoft.public.excel.programming)
  • Re: Problem accessing Access/Jet databse: Could not lock file
    ... not lock file" when opening a connection to an Access database on a network ... shared folder. ... Since the .mdb file can be opened using Access and everything can be done, ...
    (microsoft.public.dotnet.framework.adonet)
  • Exception Error
    ... The application will be installed in a local computer and the access database will be placed in another drive. ... It uses a text file to contain the connection string that will be used by the program. ... Windows closes the program. ... "The Exception Floating point in exact result occured in location 0x7c59ba9d." ...
    (microsoft.public.vb.database.ado)
  • Re: ASP.NET with Access: concurrent users?
    ... My ASP.NET application connects to an Access database using OleDb. ... my connection string: ... this seems to be a read/write security thing. ... I'm suspecting it has something to do with concurrent users. ...
    (microsoft.public.dotnet.framework.adonet)