can read DB results, but can't write to DB

  • Thread starter Thread starter John Ruthroff
  • Start date Start date
J

John Ruthroff

Publishing with FP2K. I have an Access DB on a web site
that's on a server with ASP. I can browse and search the
DB fine via the web, but when I use a form to attempt to
add records to the DB I get "cannot open record set" after
submitting the info by hitting the SUBMIT button on the
form. The form I'm using I've saved as an .asp, which to
my (mistaken?) understanding should not need FP extensions
on the server for this to work.

When I save the form as a .htm page and load it on the
server, I get the usual 'FP run time component error' page
that tells me that the form will work properly when FP
extensions are installed. That would be the simple
solution except for the extra money the server people want
for FP extensions.

My questions are:

1. Are these results consistent with the problem being no
FP extensions? I'm surprised I can read the DB but not
write to it, but maybe this is the way it's supposed to
work.

2. Is my understanding incorrect that the .asp form should
successfully send the info to the database without the FP
extensions?

Thanks!

John
 
When using ASP, you don't need the FP extensions, however the extensions do
take care of setting the required permissions and connection to the
database.

Without the extensions, you host has to manually set permissions on the
folder holding the database, and the database to allow writing by the
<IUSER_Machinename> account.

--

==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, Forums, WebCircle,
MS KB Quick Links, etc.
==============================================
 
Thanks for the quick reply.

I logged into the server and altered the permissions on
the 'fpdb' folder and the DB files, even tried 'Full'
access, and I still can't add records via the web. I still
get 'can't open record set'.

What else could be going on?

Thanks,

John
 
Do you have direct access to the server OS?
Did you give the IUSER_Machinename account access?

--

==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, Forums, WebCircle,
MS KB Quick Links, etc.
==============================================
 
I can view/change file and folder permissions on the
hosting company's website. It's a W2K server. If it
actually adjusts the IUSER account I don't know, but I'm
trying to imagine why it would have two different ways of
altering permissions...maybe it does.

John
 
Back
Top