Save form results to Access db...

[MikeS]

Newbie to db's. I'm trying to write a form whose results are saved to a db
that resides on the server in my fp2002 web. Win hosted, db is imported to
the fpdb folder as requested, a connection is made. I'm following all the MS
and third party instructions to the letter. The problem is that the db on
the server is not updated when I open it with Access. The results appear on
the results page fine, but I'd like it to update the db that resides on the
server. Is this possible? I tried an SQL connection from within Access as
well...no joy.
TIA,
Mike

 

[Thomas A. Rowe]

Have your web host run a server health check and let FP correct the permissions.

--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage

http://www.Ecom-Data.com
==============================================

 

[Tom Miller]

Newbie to db's. I'm trying to write a form whose results are saved to a db

that resides on the server in my fp2002 web. ------------snip---------------------
Is this possible?

Yes, I have even taken a small ASP script that ran a guest book using the
access db I knew practically nothing but it worked. But you do have to the
files permissions set correctly.

Hopefully Thomas's instructions will work..... Otherwise your going to have
to start looking into things like the configuration file that was created
for the website when you set this up..... as well as making sure the db
folder as well as the file have r/w permission.

Tom