Read Only?

looking for SQL Guru who can tell me what I'm doing wrong with the following VB executable which runs on the server, I'm getting the error,
"cannot delete record database is read only."
Seems straight forward but I can delete records from this table remotely via an active server page (asp) no problem.


Thank in Advance

Regards


Bob Cheeseman
King Kommunications <http://www.kingkom.com>
bob@kingkom.com <mailto:bob@kingkom.com>


Public Sub Main()

On Error GoTo skip

Dim stDocName As String
Dim stQuoteName As String
Dim objAccess As Object
Dim myDoCmd As Object
Dim dbs As Database
Dim PrimaryRS As Recordset
Dim location As String

Set dbs = OpenDatabase("NVO", dbDriverNoPrompt, False, "ODBC;DATABASE=NVO2000;DSN=NVO")

Set PrimaryRS = dbs.OpenRecordset("SELECT * FROM quotation_files_temp", dbOpenDynaset)
stQuoteName = PrimaryRS!QuoteNum

Set objAccess = GetObject("C:NVO2000fpdbNVO_FRONTEND.mdb")
objAccess.Application.Visible = False
Set myDoCmd = objAccess.DoCmd
stDocName = "quote"
stQuoteName = stQuoteName & "Q.SNP"
myDoCmd.OutputTo acReport, stDocName, acFormatSNP, "c:
vo2000Documents" & stQuoteName

' dbs.Execute ("delete from quotation_files_temp") ' help needed here!!!!

dbs.Close
PrimaryRS.Close
Set dbs = Nothing
Set PrimaryRS = Nothing
objAccess.Application.Quit
Set objAccess = Nothing

Exit Sub
skip:

End Sub