Re: Opening a connection to an 'Access' database

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Val Mazur (group51a_at_hotmail.com)
Date: 05/28/04 

Date: Thu, 27 May 2004 22:12:54 -0400

Hi Sagi,

Most likely you do not have permissions to access database. See next KB
about it

http://support.microsoft.com/default.aspx?scid=kb;en-us;316675&Product=adonet 

-- 
Val Mazur
Microsoft MVP
"Sagi" <sagi_dror@hotmail.com> wrote in message 
news:F63405BE-694D-4A99-8534-C65E1649BBEC@microsoft.com...
>I use a Jet 4.0  OleDbConnection with all the default values plus the 
>location of the database(on my computer),all set in the data link 
>properties dialog ,to connect to an 'Access' database.
> When I try to open the connection I get the eror :
> ' It is already opened exclusively by another user, or you need permission 
> to view its data.'
>
> The file was not opened earlier by another program.
>
> What could I do wrong?
>
>

Relevant Pages

  • Re: Location for shared Access database
    ... Can anyone tell me where I should put a simple Access database file in order to be accessible for every computer in the network? ... I don't think that the "Programs" folder is the right place. ... For a network-shared database, use SQL Server instead: ... This will work on Vista as well, although you'll need to adjust the local folder permissions since users don't have write permissions on c:\ by default. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Securing A Folder On A Server
    ... i've never used Acess's user-level security, so i can't answer any questions ... Access database. ... I understand the concept of user groups ... > with appropriate permissions. ...
    (microsoft.public.access.gettingstarted)
  • Re: Access db accessibility (permissions??)
    ... The application requires no permissions of it's own. ... It's a vb app, the sole purpose of which is to ... enter and modify data into an initialized Access database. ... when people take the installation cd home and install it on their ...
    (microsoft.public.access.security)
  • Re: Connect to database on other computer
    ... I had a similar problem accessing data on a remote server. ... password) and give basic permissions to the ASP.NET application folder. ... Then edit the Account used for anonymous ... I can directly open the MS Access database, ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: Error:Operation must use an updateable query
    ... settings) having read/write permissions to the folder where access database ... I have checked for the permissions, all the permissions are ok, at the same ... sConn += "Persist Security Info=False" ...
    (microsoft.public.dotnet.framework.adonet)