Front Page - Database problems

Author

Database problems

Steve Grosz

2004-02-25, 11:29 pm

I know this has been posted before (maybe by me!). I am having all sorts of
problems getting data into a Access database.

Here's my setup:
W2K Server SP4
FPSE2002
Firewall

I have created the database in the fpdb folder in my web, and verified that
the form fields match up to the data fields I want to store the data. When
I press the submit button on my form, it says its storing the data, but when
I open up the database (remotely, as I don't have access on my server) there
is nothing there. But the date and time that the access file was modified
correspond to when I pressed the submit button.

Thanks,
Steve

Thomas A. Rowe

2004-02-26, 12:28 am

IUSER_Machinename permissions are not set correctly on the folder and the
database file, contact your host to have these set.

--

==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)
http://www.ycoln-resources.com
FrontPage Resources, WebCircle,
MS KB Quick Links, etc.
==============================================
To assist you in getting the best answers for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp

"Steve Grosz" <sgrosz@communications-consultant.com> wrote in message
news:ujJ48dB$DHA.1844@TK2MSFTNGP11.phx.gbl...
> I know this has been posted before (maybe by me!). I am having all sorts
of
> problems getting data into a Access database.
>
> Here's my setup:
> W2K Server SP4
> FPSE2002
> Firewall
>
> I have created the database in the fpdb folder in my web, and verified
that
> the form fields match up to the data fields I want to store the data.
When
> I press the submit button on my form, it says its storing the data, but
when
> I open up the database (remotely, as I don't have access on my server)
there
> is nothing there. But the date and time that the access file was modified
> correspond to when I pressed the submit button.
>
> Thanks,
> Steve
>
>

Steve Grosz

2004-02-26, 2:31 pm

Thomas,

I am actually the host on this system. What changes to
that account would need to be made. I take it your
talking about making them through IIS, correct?

Steve

>-----Original Message-----
>IUSER_Machinename permissions are not set correctly on
the folder and the
>database file, contact your host to have these set.
>
>--
>
>==============================================
>Thomas A. Rowe (Microsoft MVP - FrontPage)
>WEBMASTER Resources(tm)
>http://www.ycoln-resources.com
>FrontPage Resources, WebCircle,
>MS KB Quick Links, etc.
>==============================================
>To assist you in getting the best answers for FrontPage
support see:
>http://www.net-sites.com/sitebuilder/newsgroups.asp
>
>"Steve Grosz" <sgrosz@communications-consultant.com>
wrote in message
>news:ujJ48dB$DHA.1844@TK2MSFTNGP11.phx.gbl...
am having all sorts[color=darkred]
>of
web, and verified[color=darkred]
>that
store the data.[color=darkred]
>When
storing the data, but[color=darkred]
>when
access on my server)[color=darkred]
>there
access file was modified[color=darkred]
>
>
>.
>

Kevin Spencer

2004-02-26, 2:31 pm

The IUSER_<machine name> account on that machine must be granted "Modify"
permission for the folder containing the database.

--
HTH,
Kevin Spencer
..Net Developer
Microsoft MVP
Big things are made up
of lots of little things.

"Steve Grosz" <boise_bound@hotmail.com> wrote in message
news:275401c3fc92$a14f9d40$a501280a@phx.gbl...[color=darkred]
> Thomas,
>
> I am actually the host on this system. What changes to
> that account would need to be made. I take it your
> talking about making them through IIS, correct?
>
> Steve
>
>
> the folder and the
> support see:
> wrote in message
> am having all sorts
> web, and verified
> store the data.
> storing the data, but
> access on my server)
> access file was modified

Steve Grosz

2004-02-26, 4:29 pm

Does the IUSER account just need to allow modify on the
folder itself? Nothing to the database? I don't have
users defined for the database, so I'm thinking I don't
need to. Correct?

Steve

>-----Original Message-----
>The IUSER_<machine name> account on that machine must be
granted "Modify"
>permission for the folder containing the database.
>
>--
>HTH,
>Kevin Spencer
>..Net Developer
>Microsoft MVP
>Big things are made up
>of lots of little things.
>
>"Steve Grosz" <boise_bound@hotmail.com> wrote in message
>news:275401c3fc92$a14f9d40$a501280a@phx.gbl...
FrontPage[color=darkred]
I[color=darkred]
to[color=darkred]
>
>
>.
>

Kevin Spencer

2004-02-26, 5:29 pm

Ther permission setting that I gave you is correct. IUSER_<machine name>.
The folder containing the database.

--
HTH,
Kevin Spencer
..Net Developer
Microsoft MVP
Big things are made up
of lots of little things.

"Steve Grosz" <boise_bound@hotmail.com> wrote in message
news:2c0101c3fca1$ccc3bce0$a101280a@phx.gbl...[color=darkred]
> Does the IUSER account just need to allow modify on the
> folder itself? Nothing to the database? I don't have
> users defined for the database, so I'm thinking I don't
> need to. Correct?
>
> Steve
>
> granted "Modify"
> FrontPage
> I
> to

Steve Grosz

2004-02-27, 1:30 pm

Ok, I went in to the folder properties on the server and added the
permissions for IUSER_Machinename. Still not adding the records to the
database. Actually now its not even showing that the database has been
modified with today's date on the file.

Steve

"Kevin Spencer" <kevin@takempis.com> wrote in message
news:ehOaRfK$DHA.552@TK2MSFTNGP11.phx.gbl...
> Ther permission setting that I gave you is correct. IUSER_<machine name>.
> The folder containing the database.
>
> --
> HTH,
> Kevin Spencer
> .Net Developer
> Microsoft MVP
> Big things are made up
> of lots of little things.
>
> "Steve Grosz" <boise_bound@hotmail.com> wrote in message
> news:2c0101c3fca1$ccc3bce0$a101280a@phx.gbl...
>
>

Kevin Spencer

2004-02-27, 2:29 pm

Unfortunately, I am not a user of the DRW, so I can't help you with problems
of using it (I'm just a programmer). Hopefully, one or more of the other
MVPs are following this thread and will jump in.

Assuming that you granted the IUSER account Modify permission for the folder
containing the database, that is not the problem.

--
HTH,
Kevin Spencer
..Net Developer
Microsoft MVP
Big things are made up
of lots of little things.

"Steve Grosz" <sgrosz@communications-consultant.com> wrote in message
news:OL9J6XV$DHA.1452@TK2MSFTNGP09.phx.gbl...
> Ok, I went in to the folder properties on the server and added the
> permissions for IUSER_Machinename. Still not adding the records to the
> database. Actually now its not even showing that the database has been
> modified with today's date on the file.
>
> Steve
>
> "Kevin Spencer" <kevin@takempis.com> wrote in message
> news:ehOaRfK$DHA.552@TK2MSFTNGP11.phx.gbl...
name>.[color=darkred]
>
>

Thomas A. Rowe

2004-02-27, 9:28 pm

You must set permissions on both the database and the database file.

If you are storing the database in the fpdb folder, then FP will normally
set the correct permission, as long as you have import the database into the
current open web, created a connection name, and then let FP move the
database to the fpdb folder, then run Tools | Web Settings | Database and
select the connect, click verify, then click apply.

--

==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)
http://www.ycoln-resources.com
FrontPage Resources, WebCircle,
MS KB Quick Links, etc.
==============================================
To assist you in getting the best answers for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp

"Steve Grosz" <sgrosz@communications-consultant.com> wrote in message
news:OL9J6XV$DHA.1452@TK2MSFTNGP09.phx.gbl...
> Ok, I went in to the folder properties on the server and added the
> permissions for IUSER_Machinename. Still not adding the records to the
> database. Actually now its not even showing that the database has been
> modified with today's date on the file.
>
> Steve
>
> "Kevin Spencer" <kevin@takempis.com> wrote in message
> news:ehOaRfK$DHA.552@TK2MSFTNGP11.phx.gbl...
name>.[color=darkred]
>
>

Steve Grosz

2004-02-28, 1:28 pm

I actually had FP2003 create the database for me. So it
put it in the fpdb folder, and yes, I created the
connection, verified it, and linked up my form fields
with the fields in the database. It was after that time
I added the new permission for IUSER_machine name to the
folder on the server.

Steve

>-----Original Message-----
>You must set permissions on both the database and the
database file.
>
>If you are storing the database in the fpdb folder, then
FP will normally
>set the correct permission, as long as you have import
the database into the
>current open web, created a connection name, and then
let FP move the
>database to the fpdb folder, then run Tools | Web
Settings | Database and
>select the connect, click verify, then click apply.
>
>--
>
>==============================================
>Thomas A. Rowe (Microsoft MVP - FrontPage)
>WEBMASTER Resources(tm)
>http://www.ycoln-resources.com
>FrontPage Resources, WebCircle,
>MS KB Quick Links, etc.
>==============================================
>To assist you in getting the best answers for FrontPage
support see:
>http://www.net-sites.com/sitebuilder/newsgroups.asp
>
>"Steve Grosz" <sgrosz@communications-consultant.com>
wrote in message
>news:OL9J6XV$DHA.1452@TK2MSFTNGP09.phx.gbl...
and added the[color=darkred]
the records to the[color=darkred]
database has been[color=darkred]
IUSER_<machine[color=darkred]
>name>.
message[color=darkred]
on the[color=darkred]
have[color=darkred]
don't[color=darkred]
must be[color=darkred]
message[color=darkred]
changes to[color=darkred]
your[color=darkred]
correctly on[color=darkred]
set.[color=darkred]
sites.com/sitebuilder/newsgroups.asp[color=darkred]
consultant.com>[color=darkred]
me!).[color=darkred]
folder in my[color=darkred]
I want[color=darkred]
says its[color=darkred]
have[color=darkred]
that the[color=darkred]
button.[color=darkred]
>
>
>.
>