Access To Access

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.

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_ and IWAM_ 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"

Re: Access To Access

Thank you for your reply.

I only had one Windows account before and only have one now. It is the
'Full Control' Computer administrator account. So what other account is it
that needs to have the permission you describe?

I am sorry I have no idea what "IUSR_ and IWAM_
accounts" are, do you have any reference that might help my understanding,
and better still advise me what to do to rectify my problem.

If it helps, and from what you say this must be related. Sometimes when I
modify a file with my Web editor (FrontPage), when I come to save it, I am
told a new version exists and was modified by another user - Do I wish to
overwrite? I always say yes, and have no issues.



"Bob Barrows [MVP]" wrote in message
news:OIiZSKSGGHA.1424@TK2MSFTNGP12.phx.gbl...
> 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_ and IWAM_ 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"
>

Re: Access To Access

Paul W Smith wrote:
> Thank you for your reply.
>
> I only had one Windows account before and only have one now. It is
> the 'Full Control' Computer administrator account. So what other
> account is it that needs to have the permission you describe?
>
> I am sorry I have no idea what "IUSR_ and
> IWAM_ accounts" are, do you have any reference that
> might help my understanding, and better still advise me what to do to
> rectify my problem.

There are several links in http://www.aspfaq.com/show.asp?id=2009,
including:
http://support.microsoft.com/kb/174811/EN-US/
http://support.microsoft.com/default.aspx/kb/253604

Without knowing what your OS is, I cannot give you specific help. Try
http://www.aspfaq.com/show.asp?id=2205
http://www.microsoft.com/technet/prodtechnol/winxppro/mainta in/filesharing.mspx
http://www.aspfaq.com/show.asp?id=2039
http://support.microsoft.com/?id=325358


--
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"

Re: Access To Access

In the Access database I'd suggest doing Tools | Options | Advanced |
Default Open Mode of Shared

Best regards,
J. Paul Schmidt, Freelance Web and Database Developer
http://www.Bullschmidt.com
Access Database Sample, Web Database Sample, ASP Design Tips

Re: Access To Access

Bob,

Thank for your help.

I have read the references below and tried to understand but as a simple
developer it is all too complicated for me. The principles are not but I am
not confident about making changes to internal accounts.

I am using Windows XP Professional. I cannot find how to change security
through Windows Explorer although references seem to think I should be able
to.


Using Computer Management from Control Panel I can see the users and groups
on my PC. I think I have to add IUSR_ and IWAN_
to a group which given them the required permissions.

Currently IUSR_ is a member of Users - should I make it a
member of Administrators?

IWAN_ is not a member of any group - Which Should I make it a
member of?




"Bob Barrows [MVP]" wrote in message
news:%23YFP6TdGGHA.216@TK2MSFTNGP15.phx.gbl...
> Paul W Smith wrote:
>> Thank you for your reply.
>>
>> I only had one Windows account before and only have one now. It is
>> the 'Full Control' Computer administrator account. So what other
>> account is it that needs to have the permission you describe?
>>
>> I am sorry I have no idea what "IUSR_ and
>> IWAM_ accounts" are, do you have any reference that
>> might help my understanding, and better still advise me what to do to
>> rectify my problem.
>
> There are several links in http://www.aspfaq.com/show.asp?id=2009,
> including:
> http://support.microsoft.com/kb/174811/EN-US/
> http://support.microsoft.com/default.aspx/kb/253604
>
> Without knowing what your OS is, I cannot give you specific help. Try
> http://www.aspfaq.com/show.asp?id=2205
> http://www.microsoft.com/technet/prodtechnol/winxppro/mainta in/filesharing.mspx
> http://www.aspfaq.com/show.asp?id=2039
> http://support.microsoft.com/?id=325358
>
>
> --
> 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"
>

Re: Access To Access

Paul W Smith wrote:
> Bob,
>
> Thank for your help.
>
> I have read the references below and tried to understand but as a
> simple developer it is all too complicated for me. The principles
> are not but I am not confident about making changes to internal
> accounts.
> I am using Windows XP Professional. I cannot find how to change
> security through Windows Explorer although references seem to think I
> should be able to.

You need to shut off "simple file sharing". Form this article,
http://www.aspfaq.com/show.asp?id=2205, this is the relevant paragraph:

Now, what if you don't have a Security tab?

Open up Windows Explorer, open the Tools menu, choose Folder Options, and go
to the View tab. The last item in the list is called "Use simple file
sharing." Uncheck this box, click Apply and OK, and try the above steps
again


>
>
> Using Computer Management from Control Panel I can see the users and
> groups on my PC. I think I have to add IUSR_ and
> IWAN_ to a group which given them the required permissions.

No. After shutting off "simple file sharing", navigate to the folder
containing the database, then, from that same article:

In Windows Explorer, right-click the folder in question, hit Properties, and
select the Security tab. If the Internet Guest Account (IUSR_)
is not listed, click the Add... button and type IUSR_ into the
textbox, and click OK. Now select the Internet Guest Account, and check that
the permissions are adequate. For most web applications, Read and Write is
sufficient. You may have to do this for individual files as well, and for
Access databases specifically, you might also have to open up the temp
folder. You can see Article #2039 for more detailed instructions and setting
up permissions for IUSR.

Bob Barrows

--
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"

Re: Access To Access

Bob,

Thank you very much for your perseverance, using your advice I have solved
my problem.



"Bob Barrows [MVP]" wrote in message
news:uAVpiWwGGHA.3776@TK2MSFTNGP10.phx.gbl...
> Paul W Smith wrote:
>> Bob,
>>
>> Thank for your help.
>>
>> I have read the references below and tried to understand but as a
>> simple developer it is all too complicated for me. The principles
>> are not but I am not confident about making changes to internal
>> accounts.
>> I am using Windows XP Professional. I cannot find how to change
>> security through Windows Explorer although references seem to think I
>> should be able to.
>
> You need to shut off "simple file sharing". Form this article,
> http://www.aspfaq.com/show.asp?id=2205, this is the relevant paragraph:
>
> Now, what if you don't have a Security tab?
>
> Open up Windows Explorer, open the Tools menu, choose Folder Options, and
> go to the View tab. The last item in the list is called "Use simple file
> sharing." Uncheck this box, click Apply and OK, and try the above steps
> again
>
>
>>
>>
>> Using Computer Management from Control Panel I can see the users and
>> groups on my PC. I think I have to add IUSR_ and
>> IWAN_ to a group which given them the required permissions.
>
> No. After shutting off "simple file sharing", navigate to the folder
> containing the database, then, from that same article:
>
> In Windows Explorer, right-click the folder in question, hit Properties,
> and select the Security tab. If the Internet Guest Account
> (IUSR_) is not listed, click the Add... button and type
> IUSR_ into the textbox, and click OK. Now select the
> Internet Guest Account, and check that the permissions are adequate. For
> most web applications, Read and Write is sufficient. You may have to do
> this for individual files as well, and for Access databases specifically,
> you might also have to open up the temp folder. You can see Article #2039
> for more detailed instructions and setting up permissions for IUSR.
>
> Bob Barrows
>
> --
> 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"
>