Need help creating wrokgroup information file for Access database

[Terry Murray]

Hi everybody, I am trying to create a workgroup information file for Access
but having problems determining how do I set up a username and password for
it. The reason that I am doing this is so that I can avoid receiving this
error when running an asp application that accesses a MS Access Database.
The error message:

Error type:
Microsoft JET Database Engine (0x80040E4D)
Cannot start your application. The workgroup information file
is missing or opened exclusively by another user.
/wcg/games.asp, line 560

I thought that I should also mention that the application is able to get to
the database on its first try but it
is at other points within the application that the database has to be
accessed where I would get the error message.

Thanks in advance
Terry

[Bob Barrows]

Something is not right. If you are using workgroup security in this database
then you should already have a workgroup file.If you are not using workgroup
security, then a workgroup info file is NOT needed. So, the question is: are
you using workgroup security in this database? Have you, or anyone else set
up work groups and user names and passwords in this database? If not, do not
create a workgroup info file!

You showed your error message, but you failed to show the connection string
that produces this error. Oh wait. Is this it?
cst= "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & _
Server.MapPath(".") & "\shopping500.mdb;" & _
"User Id=admin;" & _
"Password="

I suggest you remove the User ID and password portions.
Next, I suggest that you do this:
Response.write cst
Response.end

Run the page and look at the string written to the browser window. Verify
that the path shown is the actual file-system path to the database.

If so, next step is to navigate to that folder using Windows NT Explorer.
Right-click the folder and choose Properties. Go to the Security tab and
verify that the IUSR_machinename and IWAM_machinename accounts have Change
(read and write) permissions in this folder.

Get back to us if this does not fix the problem.

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.

"Terry Murray" <tgmurray@rogers.com> wrote in message
news:pAIBb.35567$r%u1.32993@twister01.bloor.is.net .cable.rogers.com...

> Hi everybody, I am trying to create a workgroup information file for

Access

> but having problems determining how do I set up a username and password

for

> it. The reason that I am doing this is so that I can avoid receiving this
> error when running an asp application that accesses a MS Access Database.
> The error message:
>
> Error type:
> Microsoft JET Database Engine (0x80040E4D)
> Cannot start your application. The workgroup information file
> is missing or opened exclusively by another user.
> /wcg/games.asp, line 560
>
> I thought that I should also mention that the application is able to get

to

> the database on its first try but it
> is at other points within the application that the database has to be
> accessed where I would get the error message.
>
> Thanks in advance
> Terry
>
>

[Terry Murray]

"Bob Barrows" <reb01501@NOyahoo.SPAMcom> wrote in message
news:Oetsu10vDHA.2076@TK2MSFTNGP09.phx.gbl...

> Something is not right. If you are using workgroup security in this

database

> then you should already have a workgroup file.If you are not using

workgroup

> security, then a workgroup info file is NOT needed. So, the question is:

are

> you using workgroup security in this database? Have you, or anyone else

set

> up work groups and user names and passwords in this database? If not, do

not

> create a workgroup info file!
>
> You showed your error message, but you failed to show the connection

string

> that produces this error. Oh wait. Is this it?
> cst= "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & _
> Server.MapPath(".") & "\shopping500.mdb;" & _
> "User Id=admin;" & _
> "Password="
>
> I suggest you remove the User ID and password portions.
> Next, I suggest that you do this:
> Response.write cst
> Response.end
>
> Run the page and look at the string written to the browser window. Verify
> that the path shown is the actual file-system path to the database.

I verified that the path is correct.

>
> If so, next step is to navigate to that folder using Windows NT Explorer.
> Right-click the folder and choose Properties. Go to the Security tab and
> verify that the IUSR_machinename and IWAM_machinename accounts have Change
> (read and write) permissions in this folder.

I am using Windows XP Professional therefore I do not have access to Windows
NT Explorer I only have Windows Explorer. I don't think that I am able to
continue on with verifying that I have Change permissions for the folder
containing the database.

>
> Get back to us if this does not fix the problem.
>
> 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.
>
> "Terry Murray" <tgmurray@rogers.com> wrote in message
> news:pAIBb.35567$r%u1.32993@twister01.bloor.is.net .cable.rogers.com...

> > Hi everybody, I am trying to create a workgroup information file for

> Access

> > but having problems determining how do I set up a username and password

> for

> > it. The reason that I am doing this is so that I can avoid receiving

this

> > error when running an asp application that accesses a MS Access

Database.

> > The error message:
> >
> > Error type:
> > Microsoft JET Database Engine (0x80040E4D)
> > Cannot start your application. The workgroup information file
> > is missing or opened exclusively by another user.
> > /wcg/games.asp, line 560
> >
> > I thought that I should also mention that the application is able to get

> to

> > the database on its first try but it
> > is at other points within the application that the database has to be
> > accessed where I would get the error message.
> >
> > Thanks in advance
> > Terry
> >
> >

>
>

[Bob Barrows]

Terry Murray wrote:

>>
>> If so, next step is to navigate to that folder using Windows NT
>> Explorer. Right-click the folder and choose Properties. Go to the
>> Security tab and verify that the IUSR_machinename and
>> IWAM_machinename accounts have Change (read and write) permissions
>> in this folder.

>
> I am using Windows XP Professional therefore I do not have access to
> Windows NT Explorer I only have Windows Explorer. I don't think that
> I am able to continue on with verifying that I have Change
> permissions for the folder containing the database.
>

[url]http://www.microsoft.com/windowsxp/pro/using/howto/security/accesscontrol.asp[/url]

IIRC, in XP, the IUSR account shows up as the Internet Guest account

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.

[Terry Murray]

Hi Bob. I followed the instructions provided in the link that you sent me.
I can now see the "Security" tab. Unfortunately, I do not know how to
proceed, as I do not see the Internet Guest account. What does show up is:
Administrators
CREATOR OWNER
SYSTEM
Terry [SHIBA\Terry]
Users [SHIBA\Users]


Thanks
Terry

"Bob Barrows" <reb01501@NOyahoo.SPAMcom> wrote in message
news:OFXOorBwDHA.3416@tk2msftngp13.phx.gbl...

> Terry Murray wrote:

> >>
> >> If so, next step is to navigate to that folder using Windows NT
> >> Explorer. Right-click the folder and choose Properties. Go to the
> >> Security tab and verify that the IUSR_machinename and
> >> IWAM_machinename accounts have Change (read and write) permissions
> >> in this folder.

> >
> > I am using Windows XP Professional therefore I do not have access to
> > Windows NT Explorer I only have Windows Explorer. I don't think that
> > I am able to continue on with verifying that I have Change
> > permissions for the folder containing the database.
> >

>

[url]http://www.microsoft.com/windowsxp/pro/using/howto/security/accesscontrol.asp[/url]

>
> IIRC, in XP, the IUSR account shows up as the Internet Guest account
>
> 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]

?
Isn't IIS installed on this machine?
Did you click the Add button?

Bob Barrows

Terry Murray wrote:

> Hi Bob. I followed the instructions provided in the link that you
> sent me.
> I can now see the "Security" tab. Unfortunately, I do not know how to
> proceed, as I do not see the Internet Guest account. What does show
> up is: Administrators
> CREATOR OWNER
> SYSTEM
> Terry [SHIBA\Terry]
> Users [SHIBA\Users]
>
>

[Terry Murray]

No, I am sorry Bob. I did not click the Add button. I was not aware of the
fact that I needed to create another user. I do indeed have IIS installed
on the machine. Pardon me for being a bit lacking in knowledge when it
comes to this area.

I do appreciate your help.

Thanks
Terry

"Bob Barrows" <reb01501@NOyahoo.SPAMcom> wrote in message
news:Ox23TOCwDHA.2460@TK2MSFTNGP10.phx.gbl...

> ?
> Isn't IIS installed on this machine?
> Did you click the Add button?
>
> Bob Barrows
>
> Terry Murray wrote:

> > Hi Bob. I followed the instructions provided in the link that you
> > sent me.
> > I can now see the "Security" tab. Unfortunately, I do not know how to
> > proceed, as I do not see the Internet Guest account. What does show
> > up is: Administrators
> > CREATOR OWNER
> > SYSTEM
> > Terry [SHIBA\Terry]
> > Users [SHIBA\Users]
> >
> >

>
>

[Bob Barrows]

Terry Murray wrote:

> No, I am sorry Bob. I did not click the Add button. I was not aware
> of the fact that I needed to create another user. I do indeed have
> IIS installed on the machine. Pardon me for being a bit lacking in
> knowledge when it comes to this area.
>

By clicking Add, you are not creating another user. You are adding an
already-created user/group to the list of users and groups that already have
permissions in that folder.

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.

[Terry Murray]

Hi again Bob. Still no luck, that is, I am unable to connect to my database
more than once within the asp application.

From the list of Group or user names:

Administrators
Creator Owner
System
Terry [Shiba\Terry]
Users [Shiba\Users]

I selected the ones that did not have modify permissions set to "allow".
That means that I changed modify permission to "allow" for Terry
[Shiba\Terry] and Users [Shiba\Users].

Could there be something else that I am doing incorrectly. Up to this point
I have still not encountered the Internet Guest account.

Thanks once more,
Terry



"Bob Barrows" <reb01501@NOyahoo.SPAMcom> wrote in message
news:u1nkEkCwDHA.536@tk2msftngp13.phx.gbl...

> Terry Murray wrote:

> > No, I am sorry Bob. I did not click the Add button. I was not aware
> > of the fact that I needed to create another user. I do indeed have
> > IIS installed on the machine. Pardon me for being a bit lacking in
> > knowledge when it comes to this area.
> >

> By clicking Add, you are not creating another user. You are adding an
> already-created user/group to the list of users and groups that already

have

> permissions in that folder.
>
> 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]

Terry Murray wrote:

> Hi again Bob. Still no luck, that is, I am unable to connect to my
> database more than once within the asp application.
>
> From the list of Group or user names:
>
> Administrators
> Creator Owner
> System
> Terry [Shiba\Terry]
> Users [Shiba\Users]
>
> I selected the ones that did not have modify permissions set to
> "allow". That means that I changed modify permission to "allow" for
> Terry [Shiba\Terry] and Users [Shiba\Users].
>
> Could there be something else that I am doing incorrectly. Up to
> this point I have still not encountered the Internet Guest account.
>
> Thanks once more,
> Terry

OK. On my home machine, here is what I did:
right-click the folder
click into the Security tab
click the Add button which brought up a dialog entitled Select Users or
Groups

At this point I expected to see the IUSR and IWAM accounts in this dialog
but they were not there! I clicked the Advanced button and up popped a
different dialog, which had the same title as the previous. I wasn't sure
what to do at this point, but I clicked the Find Now button. Bam! A bunch of
names showed up in the listbox. Among them were the IUSR and IWAM accounts I
was looking for. I selected them both and clicked OK, which caused this
dialog to close, and the two names I selected to appear in the first Select
Users ... dialog. I clicked OK, and the two names now appeared in the Group
or user name listbox in the original dialog. At this point I was able to set
permissions and click OK.

HTH,
Bob Barrows







"

[Terry Murray]

Hi Bob. I have since been able to locate the IUSR_Machinename and
IWAM_Machinename accounts (thank you). After setting the permission
properties of these
accounts to "Modify" I was not successful. What happens is that I can hit
the database once but after any other attempts I get the error message. As
Chris, pointed out in another post, I may have the mode property for the
connection object set to the wrong value.
I went back to trying to connect via a dsn and have been able to with no
problems. Perhaps, there is a default that I am
not aware of the mode property.
..
I would still like to know how to connect the dsn-less way and would
appreciate any other help you can provide me with.

Perhaps you can show what the connection string and code for the mode that I
open with should look like.

Thanks in advance
Terry

"Bob Barrows" <reb01501@NOyahoo.SPAMcom> wrote in message
news:Os1%237SEwDHA.3536@tk2msftngp13.phx.gbl...

> Terry Murray wrote:

> > Hi again Bob. Still no luck, that is, I am unable to connect to my
> > database more than once within the asp application.
> >
> > From the list of Group or user names:
> >
> > Administrators
> > Creator Owner
> > System
> > Terry [Shiba\Terry]
> > Users [Shiba\Users]
> >
> > I selected the ones that did not have modify permissions set to
> > "allow". That means that I changed modify permission to "allow" for
> > Terry [Shiba\Terry] and Users [Shiba\Users].
> >
> > Could there be something else that I am doing incorrectly. Up to
> > this point I have still not encountered the Internet Guest account.
> >
> > Thanks once more,
> > Terry

>
> OK. On my home machine, here is what I did:
> right-click the folder
> click into the Security tab
> click the Add button which brought up a dialog entitled Select Users or
> Groups
>
> At this point I expected to see the IUSR and IWAM accounts in this dialog
> but they were not there! I clicked the Advanced button and up popped a
> different dialog, which had the same title as the previous. I wasn't sure
> what to do at this point, but I clicked the Find Now button. Bam! A bunch

of

> names showed up in the listbox. Among them were the IUSR and IWAM accounts

I

> was looking for. I selected them both and clicked OK, which caused this
> dialog to close, and the two names I selected to appear in the first

Select

> Users ... dialog. I clicked OK, and the two names now appeared in the

Group

> or user name listbox in the original dialog. At this point I was able to

set

> permissions and click OK.
>
> HTH,
> Bob Barrows
>
>
>
>
>
>
>
> "
>
>

[Bob Barrows]

Terry Murray wrote:

> Hi Bob. I have since been able to locate the IUSR_Machinename and
> IWAM_Machinename accounts (thank you). After setting the permission
> properties of these
> accounts to "Modify" I was not successful. What happens is that I
> can hit the database once but after any other attempts I get the
> error message.

Let's continue this in the original thread.

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"