Dang!Dang!

[middletree]

I have no idea what's going on. The more I use Access, the more I hate it.
But for this church project, I have to use it. (I'm used to SQL Server)

It was working fine, adding and inserting and all that. Then, I added some
CDONTS code to send an email when the form is submitted. Actually, email
code was already there, just not working. I changed it, which had nothing to
do wiht the database, but started getting errors about duplicate indexes.
I'm lost.

Now, I got this:

Microsoft JET Database Engine (0x80004005)
The Microsoft Jet database engine cannot open the file
'c:\inetpub\wwwroot\grace\shape.mdb'. It is already opened exclusively by
another user, or you need permission to view its data.
/grace/shape.asp, line 8

This is when I load the form page, which retrieves data from the database. I
looked in Task Manager, to see if some remnant of Access is still running,
but can't tell. I definitely closed it beforehand.

And then I logged off the OS, and signed back on. Figured it would clsoe all
open programs. Same error.

Can anyone help?

[middletree]

I should add that that I compacted my database, and that was right before I
saw the error. I did it per the instructions I got on the miscrosoft.access
NG.
"middletree" <mi********@htomail.com> wrote in message
news:#c**************@TK2MSFTNGP09.phx.gbl...

I have no idea what's going on. The more I use Access, the more I hate it.
But for this church project, I have to use it. (I'm used to SQL Server)

It was working fine, adding and inserting and all that. Then, I added some
CDONTS code to send an email when the form is submitted. Actually, email
code was already there, just not working. I changed it, which had nothing to do wiht the database, but started getting errors about duplicate indexes.
I'm lost.

Now, I got this:

Microsoft JET Database Engine (0x80004005)
The Microsoft Jet database engine cannot open the file
'c:\inetpub\wwwroot\grace\shape.mdb'. It is already opened exclusively by
another user, or you need permission to view its data.
/grace/shape.asp, line 8

This is when I load the form page, which retrieves data from the database. I looked in Task Manager, to see if some remnant of Access is still running,
but can't tell. I definitely closed it beforehand.

And then I logged off the OS, and signed back on. Figured it would clsoe all open programs. Same error.

Can anyone help?

[middletree]

I should add that for some reason, it still works on the web. My home
computer is where it gave me errors. Which is why I think the compacting
thing is not a factor.
"middletree" <mi********@htomail.com> wrote in message
news:#c**************@TK2MSFTNGP09.phx.gbl...

I have no idea what's going on. The more I use Access, the more I hate it.
But for this church project, I have to use it. (I'm used to SQL Server)

It was working fine, adding and inserting and all that. Then, I added some
CDONTS code to send an email when the form is submitted. Actually, email
code was already there, just not working. I changed it, which had nothing to do wiht the database, but started getting errors about duplicate indexes.
I'm lost.

Now, I got this:

Microsoft JET Database Engine (0x80004005)
The Microsoft Jet database engine cannot open the file
'c:\inetpub\wwwroot\grace\shape.mdb'. It is already opened exclusively by
another user, or you need permission to view its data.
/grace/shape.asp, line 8

This is when I load the form page, which retrieves data from the database. I looked in Task Manager, to see if some remnant of Access is still running,
but can't tell. I definitely closed it beforehand.

And then I logged off the OS, and signed back on. Figured it would clsoe all open programs. Same error.

Can anyone help?

[Foo Man Chew]

middletree, can you use a sensible subject next time? Dang!Dang! is useless
and tells me nothing about what the message contains. If everyone sent
subjects like this, the newsgroup would be absolutely useless to many of us.

Try to be considerate and say *SOMETHING* about Access or 80004005 or
something in the subject line, so that people don't waste time reading a
message they don't care about, and so the people who are keen on solving
Access problems don't waste time on other crap because they don't think
there are any Access questions to answer today.

You seem to use these groups a lot; have some consideration for those that
give you so much help (Ray, Bob, etc).

Try these results:
http://www.aspfaq.com/search.asp?q=80004005+exclusively

"middletree" <mi********@htomail.com> wrote in message
news:%2****************@TK2MSFTNGP09.phx.gbl...

I have no idea what's going on. The more I use Access, the more I hate it.
But for this church project, I have to use it. (I'm used to SQL Server)

[Bob Barrows]

middletree wrote:

I should add that that I compacted my database, and that was right
before I saw the error. I did it per the instructions I got on the
miscrosoft.access NG.

One of the glitches we've seen is that IUSR permissions are lost when an
Access database is compacted. The compacting process creates a totally new
database that, for some reason, fails to inherit the permissions that the
original had, even when those permissions were granted at the folder level
(which is where they should be set.

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"

[middletree]

If you'll do a search on my posts, you'll see that I do use a descriptive
subject line 99% of the time. This was pure frustration at midnight after
struggling way too long with an incomprehensible problem. I do respect
everyone's time, but considering how often I have been good about trying to
have a descriptive subject line, you need to cut me some slack under the
circumstances, and save your lectures for those who more habitually have
this problem.
"Foo Man Chew" <fo*@man.chew> wrote in message
news:ux**************@TK2MSFTNGP10.phx.gbl...

middletree, can you use a sensible subject next time? Dang!Dang! is useless and tells me nothing about what the message contains. If everyone sent
subjects like this, the newsgroup would be absolutely useless to many of us.
Try to be considerate and say *SOMETHING* about Access or 80004005 or
something in the subject line, so that people don't waste time reading a
message they don't care about, and so the people who are keen on solving
Access problems don't waste time on other crap because they don't think
there are any Access questions to answer today.

You seem to use these groups a lot; have some consideration for those that
give you so much help (Ray, Bob, etc).

Try these results:
http://www.aspfaq.com/search.asp?q=80004005+exclusively

"middletree" <mi********@htomail.com> wrote in message
news:%2****************@TK2MSFTNGP09.phx.gbl...

I have no idea what's going on. The more I use Access, the more I hate it. But for this church project, I have to use it. (I'm used to SQL Server)

[middletree]

Ok, that makes sense. I don't know if you saw my other post in this thread,
but I discovered that the version of this database which I FTP'd to the web
seems to work fine.

So how would I go about restoring permissions? Is this s Windows thing,
where I find the file in Windows Explorer and right click and go to
properties? I did that, and didn't see IUSR anywhere. But I can't be sure
if it was there before.
"Bob Barrows" <re******@NOyahoo.SPAMcom> wrote in message
news:uc*************@TK2MSFTNGP11.phx.gbl...

middletree wrote:

I should add that that I compacted my database, and that was right
before I saw the error. I did it per the instructions I got on the
miscrosoft.access NG.

One of the glitches we've seen is that IUSR permissions are lost when an
Access database is compacted. The compacting process creates a totally new
database that, for some reason, fails to inherit the permissions that the
original had, even when those permissions were granted at the folder level
(which is where they should be set.

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"

[middletree]

BTW, I tried ASPFAQ.com before I made my post. I usually do.

"Foo Man Chew" <fo*@man.chew> wrote in message
news:ux**************@TK2MSFTNGP10.phx.gbl...

Try these results:
http://www.aspfaq.com/search.asp?q=80004005+exclusively

[Bob Barrows]

middletree wrote:

Ok, that makes sense. I don't know if you saw my other post in this
thread, but I discovered that the version of this database which I
FTP'd to the web seems to work fine.

So how would I go about restoring permissions? Is this s Windows
thing, where I find the file in Windows Explorer and right click and
go to properties?
Yes
I did that, and didn't see IUSR anywhere. But I
can't be sure if it was there before.

If IIS is installed, then it is there. What is the OS?

Bob Barrows

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

[middletree]

Win2000 Pro
"Bob Barrows" <re******@NOyahoo.SPAMcom> wrote in message
news:u9**************@TK2MSFTNGP10.phx.gbl...

middletree wrote:

Ok, that makes sense. I don't know if you saw my other post in this
thread, but I discovered that the version of this database which I
FTP'd to the web seems to work fine.

So how would I go about restoring permissions? Is this s Windows
thing, where I find the file in Windows Explorer and right click and
go to properties?

Yes

I did that, and didn't see IUSR anywhere. But I
can't be sure if it was there before.

If IIS is installed, then it is there. What is the OS?

Bob Barrows

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

[Bob Barrows]

middletree wrote:

Win2000 Pro

OK, me too. Let's go through this together.

Bring up the file properties box and click Security.

If IUSR is not listed, then click the Add button.

If you are logged into a domain, then use the dropdown to switch to your
local machine

Scroll down till you see the IUSR_... and IWAM_... accounts. Both should be
added by highlighting them and clicking Add.

Click OK to return to the previous screen and verify that both accounts have
Modify permissions.
While you're at it, you should also verify that these accounts have Modify
permissions on the folder containing the database file.

HTH,
Bob Barrows

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

[middletree]

I'm doing this from memory, as I am at work now, and the problem is on my
home machine. So I'll probably not get to it until late tonight.
But I am sure that:
(1) I'm not on a domain (just a home machine)
(2) IUSR was not a listed user when I looked at that last night.

I'll add it as soon as I can and let you know.

Merry Christmas!

"Bob Barrows" <re******@NOyahoo.SPAMcom> wrote in message
news:eI**************@TK2MSFTNGP12.phx.gbl...

middletree wrote:

Win2000 Pro

OK, me too. Let's go through this together.

Bring up the file properties box and click Security.

If IUSR is not listed, then click the Add button.

If you are logged into a domain, then use the dropdown to switch to your
local machine

Scroll down till you see the IUSR_... and IWAM_... accounts. Both should

be added by highlighting them and clicking Add.

Click OK to return to the previous screen and verify that both accounts have Modify permissions.
While you're at it, you should also verify that these accounts have Modify
permissions on the folder containing the database file.

HTH,
Bob Barrows

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

[Anonymous]

Foo Man Chew,

I notice that you do a lot of critiquing and advising
where and what posts are placed on the NG. In the future
it would be nice if you answered the individuals question
at the same time instead of directing them to another
URL. Most people come here for quick answers from those
that are more experienced and may have encountered the
issue they are having rather than reading though a lot of
white space.

I agree, sensible subject lines are very helpful but
sometimes ones that aren't breaks ups monotony and stands
out to help get their issues answered. Curiosity gets the
best of us and we will want to know what something is just
by reading the title of something whether it's relative to
the subject or not. I don't see too much non-relative
subjects being posted in the NG though.

-----Original Message-----
middletree, can you use a sensible subject next time? Dang!Dang! is uselessand tells me nothing about what the message contains. If everyone sentsubjects like this, the newsgroup would be absolutely useless to many of us.
Try to be considerate and say *SOMETHING* about Access or 80004005 orsomething in the subject line, so that people don't waste time reading amessage they don't care about, and so the people who are keen on solvingAccess problems don't waste time on other crap because they don't thinkthere are any Access questions to answer today.

You seem to use these groups a lot; have some consideration for those thatgive you so much help (Ray, Bob, etc).

Try these results:
http://www.aspfaq.com/search.asp?q=80004005+exclusively

"middletree" <mi********@htomail.com> wrote in message
news:%2****************@TK2MSFTNGP09.phx.gbl...

I have no idea what's going on. The more I use Access, the more I hate it. But for this church project, I have to use it. (I'm

used to SQL Server)

.

[Bob Barrows]

Anonymous wrote:

I agree, sensible subject lines are very helpful but
sometimes ones that aren't breaks ups monotony and stands
out to help get their issues answered. Curiosity gets the
best of us and we will want to know what something is just
by reading the title of something whether it's relative to
the subject or not. I don't see too much non-relative
subjects being posted in the NG though.

I totally disagree. I often skip posts that do not have a meaningful subject
line. If you want to get help, don't give us reasons to ignore your posts.

Bob
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

[Foo Man Chew]

> it would be nice if you answered the individuals question

at the same time instead of directing them to another
URL.

So I should waste time crafting an answer that someone else has already
documented quite succinctly? Why on earth should I do that?

[Anonymous]

Because you're answer could be much clearer to them to
understand, than the URL you direct them to.

It's like buying a book. For example, you may claim
ASP.net by Wrox is a great reference, but I go buy it and
I find it useless, however I may buy an ASP.net book by
Que and find it awesome.

People write things differently than others, which might
not make sense to some, but if someone else writes the
same thing a different way it may make perfect sense.

-----Original Message-----

it would be nice if you answered the individuals question at the same time instead of directing them to another
URL.
So I should waste time crafting an answer that someone

else has alreadydocumented quite succinctly? Why on earth should I do that?

.

[Foo Man Chew]

> People write things differently than others, which might

not make sense to some, but if someone else writes the
same thing a different way it may make perfect sense.

If I have something different to say than a URL I post, I'll say it. If I'm
just going to repeat pretty much what someone said at a URL, I'll post a
URL. But thanks for the suggestions.