Capturing an IP addie and adding to a Access DB in Ultradev

[Guest_imported]

ok
I'm trying to capture an IP address
and store it with each record
so I can check for duplicate entries in the future - in effect a spam watcher/ blocker .
I use :
<%= Request.ServerVariables(&quot;REMOTE_ADDR&quot %>
to get the IP address
and I can display it
but when i try to insert it to the DB as text
I get this :

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field or fields that contain duplicate data, remove the index, or redefine the index to permit duplicate entries and try again.


Only problem is that I KNOW i don't have the field indexed
and duplicates should be allowed. I've tried everything ... even capturing the IP address into a variable - and then trying to submit that variable into the DB with the form but no luck!

help

 

[schase]

List off your database field names.

I'm betting you have a reserved name thing happening. &quot;Insert witty remark here&quot;

Stuart

 

[Guest_imported]

thanx
I hadn't seen that Ultradev had tried to set my inseret fields automatically
one was the primary key
hehhehe

thanx again


woo hoo - finally I have IP filtering