Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: Database: MS Access
 -2147467259|Operation must use an updateable query
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

hejsan
Starting Member

37 Posts

Posted - 14 June 2001 :  08:27:03  Show Profile
No.... It canīt be no write/read permission...

Since I had my working forum up for months! Yesterday it started to complain about this. Any idea someone?

It still working for members to register.
So it must write to the db then... :-)

Edited by - hejsan on 14 June 2001 08:29:59

RaiderUK
Average Member

United Kingdom
577 Posts

Posted - 14 June 2001 :  09:12:17  Show Profile  Send RaiderUK a Yahoo! Message
it is a permissions problem, and i bet it is only occuring on pages with 2 or more ADODB actions on, it is to do with the creating and moding the .ldb file, give the folder with the database full permissions.

Go to Top of Page

rik
Starting Member

Italy
6 Posts

Posted - 16 June 2001 :  10:21:47  Show Profile  Visit rik's Homepage
I have the same problem. Write permissions are OK since I got some other DB and application working in the same Forlder.

I've tried any kind of string connection: NONE!

I'm now striving to find a solution. Any Help or suggestions are very well accepted!!!

Bye, Rik
Italy

Update
Now it works!
I resolve simply deleting the entire forum fron the server, replacing with my local copy (even if the same). Previously I check for permissions on the server and on the DB (they were right). We'll never known why.

Try the same, It's free!
Don't forget to delete the forum before upload again.

http://www.riksoft.com

Edited by - rik on 16 June 2001 11:04:11
Go to Top of Page

hejsan
Starting Member

37 Posts

Posted - 16 June 2001 :  12:55:31  Show Profile
Well... on the page where new members can register, it said Op mu us an up qu...
Refistration did worked fine though.

My problem just disapperaed by itsef. Didnīt do anything to solve it.

Go to Top of Page

rik
Starting Member

Italy
6 Posts

Posted - 22 June 2001 :  05:28:51  Show Profile  Visit rik's Homepage
Hi Hejsan,
so, you had better solution than me !
Something similar happens to me just now: today, when I try to simulate a new registration, in the page where you gotta insert name, email and so on, I have a refresh every 2 seconds. Same thing in the page where I'm asked for administration password. I Haven't made any change to the code, and examining the code, it doesn't seem to be influenced by variables (unless no URL for refresh be the same as "no refresh"...)
This application is autocoding itself?!

Bye

Rik http://www.riksoft.com
Go to Top of Page

rik
Starting Member

Italy
6 Posts

Posted - 22 June 2001 :  11:43:28  Show Profile  Visit rik's Homepage
Got it!!! Pay attention!!!
Obviously the application is not autocoding... so, looking for the problem I discovered the real problem: FrontPage!
Every line Meta Command is moved in head of the page, so happens that a line like:
<% If strAutoLogon = 1 then
Response.Redirect "default.asp"
Else %>
<meta http-equiv="Refresh" content="2; URL=<% =Request.Form("refer")%>">
<% End if %>

be tranformed into:
<% If strAutoLogon = 1 then
Response.Redirect "default.asp"
Else %>

<% End if %>
with a real panic of mine!!!

I was using FP for its usefull Find/Substitute on web basis.
The lesson is: Never use FP for traslating or simply touching the forum!

Bye

Rik http://www.riksoft.com
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.23 seconds. Powered By: Snitz Forums 2000 Version 3.4.07