Database problems

  • Thread starter Thread starter Steve Grosz
  • Start date Start date
S

Steve Grosz

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

FrontPage Resources, WebCircle,
MS KB Quick Links, etc.
==============================================
 
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 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.
 
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
 
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.
 
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
 
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.
 
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)

FrontPage Resources, WebCircle,
MS KB Quick Links, etc.
==============================================
 
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
 
Back
Top