Connected to a database using the following code:

Set dbase = Workspaces(0).OpenDatabase(globaldir + "diary")

This connects fine. I can then select some values from this database and one of the tables by doing the following:

sqlstring = "SELECT * FROM tbldescrip"
Set rs = dbase.OpenRecordset(sqlstring, dbOpenDynaset)

and this works fine. The problem occurs when I try to use the insert into sql function.
I'm currently doing the following:

sqlstring = "INSERT INTO tbldescrip VALUES ('1st value', '2nd value', '3rd value', '4th value')"
Set rs = dbase.OpenRecordset(sqlstring, dbOpenDynaset)

and I'm told that it's an invalid operation. I've tested all my rights, and columns in my database, and they are fine.


Please help.