Thread: Error messages
View Single Post
  #1 (permalink)  
Old June 4th, 2005, 12:57 PM
ldoodle ldoodle is offline
Authorized User
Join Date: Jun 2005
Location: , , .
Posts: 21
Thanks: 0
Thanked 0 Times in 0 Posts
Default Error messages

Hi there,

I've created an Access database to hold 2 fields... 'UserName' and 'UserStyle'. I've made 'UserName' the Primary key as I don't want the same record, but i'm getting this error message;

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

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

/default.asp, line 18

Any ideas?


Also, how set data in the 'UserStyle' as a variable?