I know other people are having problems with this error. But their's involves inc_top.asp. Mine involves inc_function.asp. My forums were working perfectly up untill today. I have yet to touch anything with the server. And it just starts giving this error out. Members can access the main forums page that displays all the forums. But when they click on a forum they get this error. My main OS is linux. And When I try to access it using konquerer or netscape for linux I do not get this error. But when I switch to win98 and use IE or Netscape...I get these errors. Anyone have any ideas? I have checked all file permissions and they are setup properly. Error Type: Microsoft JET Database Engine (0x80004005) Could not use ''; file already in use. /snitz/inc_functions.asp, line 1760
Ok. I have done some more testing. First here is what my inc_functions looks like at around line 1760: (line 1760 is actually the one that says my_Conn2.Open strConnString" <% Response.End end sub
function getNewMemberNumber()
dim my_Conn2
set my_Conn2 = Server.CreateObject("ADODB.Connection") my_Conn2.Open strConnString
'## Forum_SQL strSql = "SELECT " & strMemberTablePrefix & "MEMBERS.MEMBER_ID " strSql = strSql & " FROM " & strMemberTablePrefix & "MEMBERS " strSql = strSql & " WHERE " & strDBNTSQLName & " = '" & strDBNTUserName & "'" set rsGetMemberID = my_Conn2.Execute(strSql) if rsGetMemberID.EOF or rsGetMemberID.BOF then getNewMemberNumber = -1 exit function end if getNewMemberNumber = rsGetMemberID("MEMBER_ID") my_Conn2.Close Set my_Conn2 = nothing end function
Now here is what I have been able to figure out. It appears as If I am the only person allowed to view the forums. Only my member name. I was getting the same error as everyone else when I wasnt logged in. I had another person, who was having the problem everyone else is, log in with my user name and password. He can now view all the forums and their contents. And I tried the same as well...I tried 5 other people's logins and the same thing happens. So from what it looks like is that my login is "locking" everyone else from using the forums. How can this be? I read somewhere before that there is a .ldb file associated with the mdb that locks the database. I have search for a .ldb and found 2 on my server which are in no way related to snitz. Does this shed any more light on what could be my problem? Thx,
Topic Locked
Posted - 11 April 2001 : 20:47:12
