Re: Access won't open

From: Arne Beruldsen (ArneBeruldsen_at_discussions.microsoft.com)
Date: 06/18/04


Date: Fri, 18 Jun 2004 15:48:01 -0700

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: 2007 wont open older format database
    ... The database is a 2000 format ... (which is overridden by using that shortcut with the secure workgroup command ... permission if the db is secure. ... Find out what the actual error message is when she tries to open the db.. ...
    (comp.databases.ms-access)
  • Re: Database access on a local machine
    ... Again, the connection string was not provided by me, but taken from the system DSN. ... The following error message comes from the database driver software; it may appear in a different language depending on how the driver is configured. ... >> When I attempt to connect to the SQL Server database on my computer, ...
    (microsoft.public.frontpage.programming)
  • Re: Database access on a local machine
    ... the error message says "The specified procedure could not be found." ... the connection string was not ... > Server error: Unable to connect to a database from the Web server using ...
    (microsoft.public.frontpage.programming)
  • Re: Show execution plan
    ... the developer who wants the permission, ... I don't know how often I see "gets an error message", ... SHOWPLAN permission denied in database 'Northwind'. ...
    (microsoft.public.sqlserver.security)
  • Re: DAP shows in XP, not in windows 2000
    ... Another possibility would be to try installing the latest MDAC: ... What kind of database and connection string are you using and do you say any ... error message on the status bar of IE6? ...
    (microsoft.public.access.dataaccess.pages)