Re: Access To Access

Paul W Smith wrote:
> I hope this is the right forum for this question.
>
> Until a couple of days ago, when I was developing on my local host I
> was able to test my asp pages with the access database, which they
> query, open. Now I am getting a error:
>
> "Microsoft JET Database Engine (0x80004005)
> Could not use ''; file already in use."
>
> If I close Access everything works fine. So what has changed and how
> do I put things back as they were as this is so much more convenient
> for developing.
>
>
> I am sure this is relevant, but not sure how. Three days ago I
> installed the latest version of Norton security (2006). Everything
> went smoothly and everything else on my system is fine.

This is usually a filesystem permissions problem. All users of an Access mdb
file require Modify (Change) permissions for the folder containing the file.
This is to allow them to create, modify and delete the ldb (lock) file that
controls/allows multiuser access. By "all users" I mean both the
IUSR_<machinename> and IWAM_<machinename> accounts. If your site does not
allow anonymous access (as on an intranet) then all users must be granted
Modify access to that folder, usually by adding them to a group that has
that level of permission.

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"


.

Relevant Pages

  • Re: Deny User permissions upon moving files within shared folder
    ... set permissions on the shared folder in question so the targeted users ... users who should have more elevated permissions (to modify). ... permissions group (likely Modify perms). ...
    (microsoft.public.backoffice.smallbiz2000)
  • Re: How to restrict access to just Files, not Folders
    ... permissions with the least frustration and re-attempts. ... set a grant of Modify for Users ... >> permitted to traverse any subfolders. ... Traverse Folder / List access - This folder, ...
    (microsoft.public.win2000.security)
  • Re: Permissions Question
    ... Give the users read/list/write permissions to the folder and not modify. ... You can change creator owner to be read/list/write ...
    (microsoft.public.windowsxp.security_admin)
  • Re: Public Folders Permissions Granting Issue
    ... Publishing Author | Create, read items and files, modify, and delete items ... > I'm having problems granting appropriate public folder permissions in> Exchange Server 2003 Enterprise Edition ... I would like to grant some of our users the ability to edit items> in the folder and create new items (Publishing Editor role, essentially.)> The only problem is when I grant this role, no matter what I do, I always> get the message: ...
    (microsoft.public.exchange.admin)
  • Re: URGENT !!! Operation must use an updateable quary
    ... permissions on the folder containing the database file. ... I've check but there is no security on the folder as well as the file ... This email account is my spam trap so I ...
    (microsoft.public.data.ado)