Re: No access to Access files

From: BB (qbernard_at_hotmail.com)
Date: 06/16/03 

Date: Mon, 16 Jun 2003 13:46:37 +0800

Ok. try filemon & regmon from sysinternals.com,
run it on the server, and try to access it again.
then check if any file is using the mdb file.

also do you open the mdb correctly for writting ? 

-- 
Regards,
Bernard Cheah
http://support.microsoft.com/
"Harley" <harleyfeldman@msn.com> wrote in message
news:041001c333c3$bf794160$a101280a@phx.gbl...
> Bernard,
>
> I have permitted IUSR_localmachine full control in the
> folder and file where the data base is located, the Temp
> directory under Local Settings, and C:/Temp. I am still
> getting the message.  There must be something I am
> missing.
>
>   Harley
> >-----Original Message-----
> >Verify settings with this kb
> >http://support.microsoft.com/?id=306269
> >
> >-- 
> >Regards,
> >Bernard Cheah
> >http://support.microsoft.com/
> >
> >
> >"Harley" <harleyfeldman@msn.com> wrote in message
> >news:024101c333ac$a6032000$a401280a@phx.gbl...
> >> When I write a web application with VS 2003 (VB) to
> >> access a local copy of a Microsoft Access file, I
> receive
> >> the following message:
> >>
> >> The Microsoft Jet database engine cannot open the
> >> file 'C:\Documents and Settings\harley\My
> >> Documents\Sage\RadWise Guidelines 2000.mdb'. It is
> >> already opened exclusively by another user, or you need
> >> permission to view its data.
> >>
> >> Since the file is not being used by another user (not
> >> even Access on my local machine), there must be a
> >> permission issue.  I have added full access to the
> >> folder, the Access file and the temp directories to
> >> IUSR_localmachine and IWAM_localmachine.  I can bring
> up
> >> the database in VS, by performing "Preview Data" under
> >> the data adapter.
> >>
> >> What am I missing?
> >> .
> >>
> >>
> >
> >
> >.
> >

Relevant Pages

  • Re: User access on a company intranet
    ... All users need full permission on the folder where the mdb is located. ... You wouldn't need to do this in your copy of the database. ... then the only way to open the secure mdb is by using the mdw you ...
    (microsoft.public.access.security)
  • Re: ASP.NET and Microsoft Access Database
    ... Ensure that your account has permission to create a new file in the folder ... where the .mdb exists. ... > I've set IIS user permissions to modify for the folder and mdb file, ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Mdw file not found
    ... We have seen this often enough to be certain that it is a Windows permission ... It is likely that the first person to open the mdb does not have ... Microsoft Access MVP ... showing the full path to Microsoft Access, the mdb file and the mdw ...
    (microsoft.public.access.security)
  • Re: Worked ok until put on CD
    ... The Microsoft Jet database engine cannot open the file". ... suspect that an error message exists in Access which reads ... The .mdb must exist on a read-write drive where every user has ... Access refuses to accept this fakery. ...
    (comp.databases.ms-access)
  • Re: how to share mdb on LAN
    ... But the shared folderand the MDB file are given Full control permission for ... Now one more complaxity how If I want to protect this MDB file from ... while Full control is there for everyone? ... The folder is given Full control to Everyone permission. ...
    (microsoft.public.access.modulesdaovba)