Thanks for this Stefan. I have simplified the table to only two fields
with
no duplicates:
Subject Fileref
Tindall C:\Documents and Settings\Bob Darby\My Documents\My
Webs\Merline-Demo7/002.pdf
Thurgood C:\Documents and Settings\Bob Darby\My Documents\My
Webs\Merline-Demo7/003.pdf
Thompson C:\Documents and Settings\Bob Darby\My Documents\My
Webs\Merline-Demo7/004.pdf
Selinger C:\Documents and Settings\Bob Darby\My Documents\My
Webs\Merline-Demo7/005.pdf
ICM C:\Documents and Settings\Bob Darby\My Documents\My
Webs\Merline-Demo7/006.pdf
Hock C:\Documents and Settings\Bob Darby\My Documents\My
Webs\Merline-Demo7/007.pdf
Bagley C:\Documents and Settings\Bob Darby\My Documents\My
Webs\Merline-Demo7/008.pdf
Both fields are defined as text with:
Field Size: 255
Format: Blank
Input Mask: Blank
Caption: Blank
Default Value: Blank
Validation Rule: Blank
Validation Text: Blank
Required: No
Allow Zero Length: Yes
Indexed: No
Unicode Commression: Yes
IME Mode: No Control
IME Sentence Mode: None
Smart Tags: Blank
I am still getting the same message when I publish. Any ideas please?
--
BobD
Stefan B Rusynko said:
The error message is very clear on what you problem is
(one of the fields you have as required is not being sent to the DB or is
empty or is trying to create a duplicate value in a field
that is set as no duplicates allowed)
Post a list of the field names / types / values you are trying to update
from your site, and a list of your DB field names/types
--
_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________
| First attempt to connect up a database and can't get over first hurdle.
Tried
| first with Access table and then Excel worksheet but got same result
when
| publishing web and displaying results page:
|
| Database Results Error
| The application is using arguments that are of the wrong type, are out
of
| acceptable range, or are in conflict with one another.
| One or more form fields were empty. You should provide default values
for
| all form fields that are used in the query.
|
| Spent ages searching for reference to this without success and cannot
| believe I'm the first to have come up against it.