I have a table in my Access db set to not accept duplicate records of any kind. When the user tries to insert a duplicate record, they get a generic MS JET Database Engine error "80004005'. Is there any way to:

1. Redirect to a page I create when a records fails to insert
or
2. Create a custom JET error message

Thanks for any input! Lisa

Perhaps this address can give you an idea of what to do:
www.powerasp.com/content/new/on-error-resume-next.asp

Cheers,

Javier

I suggest you redirect a user when a record fails to insert due to the same value/input. it is like you're referring to the PRIMARY/UNIQUE ID of a table that cannot be duplicated.

you can also simply use SESSION variables containg an error message. Then, redirect to the original form attached w/ the session value. or create another file/page (e.g. error.asp) that will display the error.