Hi,
  As per your script i feel that the problem is in this line 
   objRSAdd.Open "SELECT * FROM email", objConnAdd, 3, 3
Just coment out the lock type and make use the following code

strsql="SELECT * FROM email"
objRSAdd.Open strsql, objConnAdd

and see if this works

regards 
shabbir moiyed




> I've been working on a newsletter application. I have used this script 
m> any times, but it's not working on this page for some unknown reason, 
r> eturning:

> --------------------
M> icrosoft OLE DB Provider for ODBC Drivers error '80004005' 

> [Microsoft][ODBC Microsoft Access Driver]Error in row 

> /lf_newsletter/lf_nl_send.asp, line 29 
-> -------------------

> The script i'm using is:

> --------------------
c> onnLF_NL = "DSN=LF_Newsletter"
'> Add newsletter to database
'> Open connection	
S> et objConnAdd = Server.CreateObject("ADODB.Connection")
S> et objRSAdd = Server.CreateObject("ADODB.RecordSet")
o> bjConnAdd.Open connLF_NL
'> Add to database
o> bjRSAdd.Open "SELECT * FROM email", objConnAdd, 3, 3
o> bjRSAdd.AddNew 
o> bjRSAdd.Fields("strTitle") = strTitle
o> bjRSAdd.Fields("strContent") = strContent
o> bjRSAdd.Fields("datDate") = Date()
o> bjRSAdd.Fields("datTime") = Time()
o> bjRSAdd.Fields("strUser") = strUser
o> bjRSAdd.Update
-> -------------------

> I've spent ages searching for answers but can't find anything.

> Thanks in advance!

> Mark MacInnes