Re: Access won't open

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: One Handed Man \( OHM - Terry Burns \) ("One)
Date: 06/18/04 

Date: Sat, 19 Jun 2004 00:30:07 +0100

Sorry, I meant OledbConnection ( Not Adapter ). You can test the
connection/access to this. Otherwise, you have it open somewhere else,
either on your machine or from someon elses. 

-- 
OHM ( Terry Burns )
 . . .  One-Handed-Man . . .
"Arne Beruldsen" <ArneBeruldsen@discussions.microsoft.com> wrote in message
news:3D913B3F-FEE2-4AE2-BBE1-C41015AF7CAF@microsoft.com...
> I'm confused.  Via the DataAdaptor...I can view the contents of the table.
The error occurs when I run it...it refers to this line:
>
> OleDbDataAdapter1.Fill(DataSet11)
>
> The exact error message is:
>
> The Microsoft Jet database engine cannot open the file 'C:\Arne's
Stuff\Visual Basic Net\OnlineTesting\Tests.mdb'. It is already opened
exclusively by another user, or you need permission to view its data.
>
> Any ideas?
>
> Arne
> "One Handed Man ( OHM - Terry Burns )" wrote:
>
> > Well, you should be able to test the DataAdapter connection by right
> > clicking on it and testing the connection. If this is OK, you may have
the
> > database open in another window ?
> >
> > -- 
> >
> > OHM ( Terry Burns )
> >  . . .  One-Handed-Man . . .
> >
> >
> > "Arne Beruldsen" <ArneBeruldsen@discussions.microsoft.com> wrote in
message
> > news:3CD9E31F-41D4-4C2D-808D-922270E0184F@microsoft.com...
> > > On a web form I'm trying to populate a grid using data in an mdb
database.
> > I've used the controls to setup the connection string, adaptor, dataset.
> > The grid appears to be seeing the data (column heading etc...).  But
when I
> > go to run...I get an error message on this line:
> > > OleDbDataAdapter1.Fill(DataSet11)
> > > The error states the database is either open (it's not) or I don't
have
> > permission to open it (no password necessary).
> > >
> > > Any ideas????
> > >
> > > Thanks
> >
> >
> >

Relevant Pages

  • Re: Access database wont open
    ... >I have created a database connection to an access database in my web ... or you need permission to view its data. ... > System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection, ... >Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior ...
    (microsoft.public.dotnet.faqs)
  • Re: Delphi.net is Beta?
    ... error message come up before you have a chance to do that?) ... I let the wizard build the connection string and after it when it comes to ... I can see the list of tables in the database but if I choose any of them, ... Invalid object name 'SYSINDEXKEYS'. ...
    (borland.public.delphi.non-technical)
  • Re: Accessing mdb file via VB code
    ... but then I encountered the error message "Unable to find ... installable ISAM" when a connection to my database was attempted on another ... Dim strConn As String ... By using UserID and Password in the connection string one is telling Jet ...
    (microsoft.public.vb.general.discussion)
  • Re: Mailmerge using a secure database
    ... Database does not have a long path name. ... When I tried re-opening my mail merge documents I get an error message ... Do you need or want specifically to connect with ODBC? ... likely to run into problems where Word truncates the connection string ...
    (microsoft.public.word.mailmerge.fields)
  • connecting to mysql using jsp
    ... I am trying to connect to database using jsp and mysql.java1.4.0,mysql5.0. ... type Exception report ... //initializing database connection ... //print error message ...
    (comp.lang.java.databases)