Connection to Access 2000 DB from FP 2002

[JVKAdmin]

hi,

I am trying to do a new user registration form on our corporate website and have the registrations entered into an Access database on the website (for me to go into later and use the data). I have manually created the Access database with the fields for use in the form with all of the fields matching the names of the Text boxes i've used in the form. I am having difficulty when configuring the options for Send to Database in that i keep getting the error that " the Database column Address1 is not in the currently selected database. You should modify the form field Address1 ". Now I can link to the database in the tools menu and it verifys okay, also when I added the connection everything appears okay. When i go and try to modify the fields to map to the database fields the drop down list is blank and I can't select anything. Does anyone know where I'm making my mistake here ?

Thanks

------------------------------------------------
Kevin Karr
Network Administrator / WebMaster
CNE, MCP, A+
Jack Van Klaveren Ltd.
1894 Seventh St.
St. Catharines ON
Canada
(905) 641-5599 ext. 2328
Sales Service: 1-800-665-1642
Fax: (905) 684-6260

http://www.jvk.net

kkarr@jvk.net

 

[AndeA]

Do you have a DSN created for the database on your Web Host Server? If not, then you will not be able to access it for the form. Ande
John 17:15 My prayer is not that you take them out of the world but that you protect them from the evil one. (NIV)

 

[JVKAdmin]

I have been trying to create the database locally on my own computer running IIS. I have tried using the Frontpage 2002's database wizards however I am not getting the result I want. I am fairly new to ASP and web database technologies. My idea was that I would get the database connection working on my local machine first and then publish to the web provider. Also, does the DSN have to be a System or User DSN and does it have to be named the same as the form ?