OK I screwed up Big Time. Tried to upgrade to v7.01 and ended up losing all my old forum stuff (Members, Posts, etc., etc.).

Now I can't even rebuild it and start from scratch as every time I try and log in (with either the default or the one I had changed it to in v6.34(?) I get the following error.

 Microsoft JET Database Engine error '80004005'

Operation must use an updateable query.

/forum/common.asp, line 403

I have gone back a deleted every thing in the forums folder to include the folder itself and tried starting from scratch but still get the same message.

Can anyone PLEASE help me.

~Repeat Jamal's post~

I'd also add that one of the first "rules" of networking is that you are only as good as your last backup. You should always keep an original backup and use a "working copy" until you are absolutely certain everything is fine. Even hen periodically close your board, download your database, zip and store it, and open your board back up. That way if something drastic does happen you can at least go back to x date.

Your problem should be simple to solve as Jamal indicated. However, if you really have upgrade problems, let me know. I've upgraded several already.

I have an autobackup include file, which backs up every 4 hours, and can be adjustable. very simple to use..copy this to a new asp include file, and include it in the bottom of default.asp:

<%
dim filesys, DB, createdate, Cpath, Npath 'Cpath = current path, Npath = new path
Cpath = server.mappath("admin/database/databasename.mdb")
Npath = server.mappath("admin/database/databasenameBAK.mdb")

createdate=now 'set date so there is not mismatch if file not found

Set filesys = CreateObject("Scripting.FileSystemObject")
if  filesys.FileExists(Npath) then
 Set DB = filesys.GetFile(Npath)
 createdate = DB.DateLastModified
end if
%>
<span class="smtext"><br>
<%
if datevalue(createdate) <> datevalue(now) or NOT filesys.fileExists(Npath) _
  OR (datepart("H",now) >= datepart("H", createdate)+4) then
  
 CopyFile Cpath,Npath
 response.write "Database backed up -----"
else
 response.write "Database backed up on " & createdate & " ... "
end if
%>
</span>
<%
set DB = nothing
set filesys = nothing

function CopyFile(strFileSource, strFileDestination)

dim fso

if strFileSource = "" OR strFileDestination = "" then
  'Error - You must supply both a source and a destination
  exit function
end if

set fso = Server.CreateObject("Scripting.FileSystemObject")
if Not fso.FileExists(strFileSource) then
  'Error - Source file does not exist
  set fso = nothing
  exit function
end if

'delete destination if it exists
if fso.FileExists(strfiledestination) then fso.deletefile strfiledestination,true

'copy the file
fso.copyfile strFileSource, strFileDestination, true

'clean up
Set fso = nothing

end function
%>