Hi guys,

I'm fairly new to asp and I'm having a bit of trouble adding records to an
Access db.

The error that is reported is:
--------------------------------------------------------------------
Microsoft OLE DB Provider for ODBC Drivers error '80004005'

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

confirm2.asp, line 93
--------------------------------------------------------------------

At msdn there is a article dedicated to the ODBC Drivers error '80004005'
but not this particular variation, namely [Microsoft][ODBC Microsoft Access
Driver]Error in row.

see http://support.microsoft.com/support.../q183/0/60.asp

The strange thing is I only get this error if I try to create another server
object to add a record ie;

Set objCat = Server.CreateObject ("ADODB.Recordset")

objCat.Open "Categories", strConnect, adOpenStatic, adLockOptimistic,
adCmdTable

objCat.AddNew
objCat("cat_info_cat") = trim(request.form("infocat"))
objCat("cat_web_area") = trim(request.form("webarea"))
objCat("cat_q3_dept") = trim(request.form("c1"))
objCat.Update

objCat.close

Set objCat = Nothing

This code works fine if it is the only asp page performing this kind of operation
but as soon as I create another page that uses the same datasource to carry
out a similar operation it fails.

If anyone can help it would be much appreciated.

thanks in advance

Mike