Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - Lost Everything Need HELP
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Lost Everything Need HELP

 Post Reply Post Reply
Author
TimD View Drop Down
Newbie
Newbie


Joined: 26 February 2003
Location: United States
Status: Offline
Points: 12
Post Options Post Options   Thanks (0) Thanks(0)   Quote TimD Quote  Post ReplyReply Direct Link To This Post Topic: Lost Everything Need HELP
    Posted: 12 June 2003 at 12:06pm

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.

< language=>

Edited by TimD
Back to Top
ljamal View Drop Down
Mod Builder Group
Mod Builder Group


Joined: 16 April 2003
Status: Offline
Points: 888
Post Options Post Options   Thanks (0) Thanks(0)   Quote ljamal Quote  Post ReplyReply Direct Link To This Post Posted: 12 June 2003 at 12:43pm
You need write permissions on the Access database
Back to Top
xeerex View Drop Down
Senior Member
Senior Member


Joined: 19 November 2002
Location: United States
Status: Offline
Points: 601
Post Options Post Options   Thanks (0) Thanks(0)   Quote xeerex Quote  Post ReplyReply Direct Link To This Post Posted: 12 June 2003 at 8:32pm

~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.

Back to Top
Stefano View Drop Down
Newbie
Newbie
Avatar

Joined: 28 May 2003
Location: Canada
Status: Offline
Points: 8
Post Options Post Options   Thanks (0) Thanks(0)   Quote Stefano Quote  Post ReplyReply Direct Link To This Post Posted: 13 June 2003 at 1:01am

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
%>



Edited by Stefano
Back to Top
TimD View Drop Down
Newbie
Newbie


Joined: 26 February 2003
Location: United States
Status: Offline
Points: 12
Post Options Post Options   Thanks (0) Thanks(0)   Quote TimD Quote  Post ReplyReply Direct Link To This Post Posted: 13 June 2003 at 12:31pm
Thank you all for your help
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.


Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.