Having a problem with getting my 'registration form' to function, i.e. to enter data to .mdb.

I keep getting this error message:-

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.

/jeremy/TMPtajfh4rue6.asp, line 115

Have checked perms on all associated folders and files on my client etc. Wondering if it might be something else...such as my host server?

Any clues would be helpful to me...

Check Line 115 and make sure it is coded correctly. The error prompt is stating there is an error in your coding. Check again.

Irene Eddy
Eddy Designs & Media

I have checked that line..

If (Not MM_abortEdit) Then
' execute the insert
Set MM_editCmd = Server.CreateObject("ADODB.Command"
MM_editCmd.ActiveConnection = MM_editConnection
MM_editCmd.CommandText = MM_editQuery
MM_editCmd.Execute
MM_editCmd.ActiveConnection.Close

115 is edit command execute (2nd from last line here) - but I can't see why its a prob.

'Dim MM_editQuery' is declared asa variable on line 8....I wonder if it's something to do with ADOB or Connection??

The query is incorrect or you don't have permissions to update the access database file. Does your host support databases? Best is to contact them, they probably can help you setup the connection correctly.

--------------------------------------------------
Patrick Woldberg
Web Developer at Dynamic Zones
Administrator at DMXzone.com, FLzone.net, FWzone.net and DNzone.com
--------------------------------------------------