Operation not allowed when object closed - corrupts Access db

[Les Juby]

Hi

Could anyone please tell me why the following code could be generating
the error....

--------------------------
INSERT INTO Agent_Area (area_rec_id, agent_rec_id) values (99, 200)
ADODB.Recordset error '800a0e78'
Operation is not allowed when the object is closed.
/area_select_process.asp, line 49
--------------------

(Line 49 is the execute statement )

After the error, the database corrupts. If I replace the INSERT
statement with a SELECT * statement then there are no errors and the
code runs fine.????

<%
dbPath = "d:\accounts\brokerjunction\databases\ciAgent_Area.mdb"
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & dbPath

SQLstmt = "INSERT INTO Agent_Area (area_rec_id, agent_rec_id) values
(99, 200)"

Set RS = Conn.Execute(SQLstmt)

''''RS.Close
''''set RS = Nothing
Conn.Close
%>

I'm certain this is not a permissions error as the <Modify> property
of the Access-2000 database has been checked several times.!

thanks

.les.

o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o
Les Juby les...@anti-spam.iafrica.com
Webpro Internet - - - Prosoft Microsystems
Durban, KwaZulu-Natal, South Africa
P.O.Box 35243, Northway 4065, South Africa
Tel: +27 31 563-8344 Fax: +27 31 564-4928
o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o
(you *do* know to take "anti-spam" out the address....?

[Les Juby]

PLEASE DISREGARD THIS POST

I have since discovered that some directory listing on the server was
incorrect.

After renaming the db and changing the code it worked fine. No
corruptions.

The error message actually came from attemping to close a record set
that was never taken as this was an insert statement.

thanks

.les.