Database question, again...:)

[Steve Grosz]

I know this has been asked and answered before. I'm just having a real
problem getting any data into a Access database.

Here are my questions:
1) If I don't want to import the DB into FP2003, I can set up a ODBC system
dsn or user dsn.

2) I should be able to see the DSN in FP2003, correct? But if I create one
on my W2k Server box, it doesn't show up in FP2003.

3) Once I submit my form that should store info to the Access database, and
then I reopen the DB on the server, nothing is stored in it. Any thoughts
as to why this is?

Thanks very much.
Steve

 

[David Berry]

1. You don't have to import it into the web as long as it's on the server.
You can set up a System DSN (ODBC) or use a DSN-Less connection. That's up
to you but if you use a DSN-Less connection FrontPage won't "see" it. If
you use ODBC is must be a System DSN.

2. After creating it, go to Tools, Web Settings, Database, and Add the
connection then "verify" it.

3. Now try your Form

 

[John Jansen \(MSFT\)]

Also make sure your fields are mapped to the database from the form
properties options dialog.

I know I've forgotten to do that in the past...