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

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

--
David Berry - MCP
Microsoft MVP - FrontPage
FrontPage Support: http://www.net-sites.com/sitebuilder/
-----------------------------------
To assist you in getting the best answers for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp
-----------------------------------
"Steve Grosz" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> 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
>
>

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

--
Thanks!
John Jansen
Microsoft Office FrontPage
This posting is provided "AS IS" with no warranties, and confers no rights.
"David Berry" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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
>
> --
> David Berry - MCP
> Microsoft MVP - FrontPage
> FrontPage Support: http://www.net-sites.com/sitebuilder/
> -----------------------------------
> To assist you in getting the best answers for FrontPage support see:
> http://www.net-sites.com/sitebuilder/newsgroups.asp
> -----------------------------------
> "Steve Grosz" <(E-Mail Removed)> wrote in message
> news:%(E-Mail Removed)...
> > 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
> >
> >
>
>