Access duplicates

Webforumz Staff · #1 Oct 8th, 2003, 21:00

Has anyone had problems with access adding new records twice (creating a duplicate) when using INSERT INTO from ASP?

D3mon · #2 Oct 8th, 2003, 22:11

Its not a problem with refreshing the page and re-executing the code is it?

Webforumz Staff · #3 Oct 9th, 2003, 07:12

I thought about that, especially as it's not consistent. Sometimes a single entry, sometimes 2. Still trying to test that.

I know Access has some funky quirks and thought maybe this was just one of those.

u2orange · #4 Oct 9th, 2003, 12:55

Stab in the dark.. Not anything to do with a double click on the submit button? I.e., code being executed before any document output, nothing happens, person clicks again?

u2o

Webforumz Staff · #5 Oct 9th, 2003, 20:00

OK, checked for double submit/refresh being the cause and that's not what's causing it. Switched from a DSN to DSN-less connection, didn't affect it.

Code's pretty standard:

Code: Select all

set con = server.CreateObject("ADODB.Connection")

	con.Open "Driver={Microsoft Access Driver (*.mdb)};" & _ 
                   "Dbq=" & server.mappath("data/xxxx.mdb") & ";" & _
                   "Uid=Admin;" & _
                   "Pwd=;"


SQL= "INSERT INTO tblMailingList(Name,Email,Address,City,ClosestCity,State,Zip,Phone,Status,Age,Sex,entryDate) VALUES ('" & Name & "','" & Email & "','" & Address & "','" & City & "','" & ClosestCity & "','" & State & "','" & Zip & "','" & Phone & "','" & Status & "','" & Age & "','" & Sex & "','" & date & " " & time & "')"
set rs = con.Execute(SQL,,1)

jakyra · #6 Oct 9th, 2003, 20:36

I don't know if this has anything to do with your dual entry problem, but when I do an action query I don't set rs=conn.execute SQL

I just type conn.execute SQL

other than that, I don't know.

jakyra

Webforumz Staff · #7 Oct 9th, 2003, 21:04

Yeah, I saw that he'd put it in that way and changed it to just con.execute. Still making doubles. I'm wondering if the hosting company (never use DellHost btw, they suck) has an old version of the Jet Engine installed.

Webforumz Staff · #8 Oct 10th, 2003, 04:24

Well, I gave up . I ended up adding some code to an admin page to remove all the duplicates when they pull up the table contents.

Now I remember why I like SQL Server better.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Portfolio Site Trouble! Duplicates of One Image	taaaylor	Flash & Multimedia Forum	5	Jun 26th, 2007 23:50
ASP Multi users Access to Microsoft Access	ish	Classic ASP	0	Apr 26th, 2007 20:05
Access	cheataweb	Databases	4	Mar 21st, 2007 18:42
ASP to ACCESS	ntgcmlfu	Classic ASP	16	Apr 18th, 2006 03:33
Need help please...ASP and Access DB	newbie44	Classic ASP	13	Sep 19th, 2005 22:02

		Webforumz.com > Main Forums > Program Your Website > Databases
Access duplicates