Here are my fields a how they are defined in access, I have them all set to same data types in the “insert record” behavior in ultradev, and even have the date set the Access Date. I have my connection available through DSN, it works. Tables are all there. It gives me the following error, my fields are below. Please help.
My site address is: 170.140.143.11/pdata/default.asp
Use temp/temp as the login.
Thanks.

Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement.
/pdata/insert.asp, line 78

ID – autonumber (not used in the ultradev insertion form)
Provider – text
preceptor – text
new patients – number
old patients – number
additional patients – number
not seen – number
amount billed – number
date – date/time
shift – text
total seen – number (not in the “insert record” server behavior)
total patients – number (not in the “insert record” server behavior)

I belive your problem lies in the use of "Date" for a column name... it's a SQL keyword... try:
1. change the name of the column
2. place [] around the name - [date]

If you still get errors, make sure you put brackets around the column names with spaces... it's generally best practice to avoid spaces in column names, but you can work around that by putting [brackets] around them.

hope that helps

Joel Martinez [ ]
----------
E-Commerce Concepts with Ultradev...pre-order yours at
www.basic-ultradev.com/ecomm_concepts/

Nevermind I figured it out, apparantely Access has keywords. I was using "date" as my field name, which is a reserved word for access. I changed it to data date.
thanks