> I get this error when trying to insert to the Access database i have over
at
> cfm-resources.com, the access DB is available to view here
> http://www.cfm-resources.com/b/bludhall/data/bludhall.mdb
I take it you will be moving the DB toa non-public area sometime soon? It's
not a very good idea to publish a DB's location...
> [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.
Well as the error explains - the changes you want to make in your query
can't be made because the results of the change already exist. Perhaps post
details of the DB and your query.
Will
www.localbounty.com
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
