Folder permissions

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am having problems linking to an access database on a web site I am
developing. It is currently on localhost. When I submit logon details I get
the following error:

Database Results Error
[Microsoft][ODBC Microsoft Access Driver]
The Microsoft Jet database engine cannot open the file '(unknown)'. It is
already opened exclusively by another user, or you need permission to view
its data.

I have looked at the Microsoft help details which has a solution that
changes the permissions by adding "Everyone" using the Security tab on the
folder's properties. When I right click my folders I do not have a Security
tab. How can I get the security tab and / or change permissions.

Help would be appreciated
 
Are you working with Windows XP Pro and have IIS installed?

Also Access can not have the database open at the same time you are trying to access it from your
web pages.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================
 
Thanks for the reply.
Yes I am working with XP Pro and the database is not open.

Thomas A. Rowe said:
Are you working with Windows XP Pro and have IIS installed?

Also Access can not have the database open at the same time you are trying to access it from your
web pages.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================

beacon said:
I am having problems linking to an access database on a web site I am
developing. It is currently on localhost. When I submit logon details I get
the following error:

Database Results Error
[Microsoft][ODBC Microsoft Access Driver]
The Microsoft Jet database engine cannot open the file '(unknown)'. It is
already opened exclusively by another user, or you need permission to view
its data.

I have looked at the Microsoft help details which has a solution that
changes the permissions by adding "Everyone" using the Security tab on the
folder's properties. When I right click my folders I do not have a Security
tab. How can I get the security tab and / or change permissions.

Help would be appreciated
Click to expand...
Click to expand...
 
Hi

The part of the coding I have for the connection string is:

Function AddToDb()
dim cnCont
dim constr
dim rsCont
dim sql
dim err
Set cnCont = Server.CreateObject("ADODB.Connection")
constr = "driver={Microsoft Access Driver (*.mdb)};" & _
"dbq=" & Server.MapPath("../fpdb/golfopendb.mdb")
cnCont.Open constr
Set rsCont = Server.CreateObject("ADODB.Recordset")
rsCont.Open "tblcontact", cnCont, adOpenDynamic, adLockOptimistic

It appears not to like the last line that opens the recordset.

MD Websunlimited said:
Hi,

How do you have connection string defined? Are you using a DSN or a direct file connection?

Note, FP creates a global.asa file that contains the connection string.

--
Mike -- FrontPage MVP '97-'02
J-Bots 2004 102 Components For FP
http://www.websunlimited.com
FrontPage Add-ins Since '97 FP 2003 / 2002 / 2000 Compatible
Download the Trial http://www.microsoft.com/frontpage/downloads/addin/launchupdate/download.asp

beacon said:
I am having problems linking to an access database on a web site I am
developing. It is currently on localhost. When I submit logon details I get
the following error:

Database Results Error
[Microsoft][ODBC Microsoft Access Driver]
The Microsoft Jet database engine cannot open the file '(unknown)'. It is
already opened exclusively by another user, or you need permission to view
its data.

I have looked at the Microsoft help details which has a solution that
changes the permissions by adding "Everyone" using the Security tab on the
folder's properties. When I right click my folders I do not have a Security
tab. How can I get the security tab and / or change permissions.

Help would be appreciated
Click to expand...
Click to expand...
 
Also IIS is installed

Thomas A. Rowe said:
Are you working with Windows XP Pro and have IIS installed?

Also Access can not have the database open at the same time you are trying to access it from your
web pages.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================

beacon said:
I am having problems linking to an access database on a web site I am
developing. It is currently on localhost. When I submit logon details I get
the following error:

Database Results Error
[Microsoft][ODBC Microsoft Access Driver]
The Microsoft Jet database engine cannot open the file '(unknown)'. It is
already opened exclusively by another user, or you need permission to view
its data.

I have looked at the Microsoft help details which has a solution that
changes the permissions by adding "Everyone" using the Security tab on the
folder's properties. When I right click my folders I do not have a Security
tab. How can I get the security tab and / or change permissions.

Help would be appreciated
Click to expand...
Click to expand...
 
Are you letting FP create the connection, via Tools | Web / Site Settings | Database?

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================

beacon said:
Thanks for the reply.
Yes I am working with XP Pro and the database is not open.

Thomas A. Rowe said:
Are you working with Windows XP Pro and have IIS installed?

Also Access can not have the database open at the same time you are trying to access it from your
web pages.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================

beacon said:
I am having problems linking to an access database on a web site I am
developing. It is currently on localhost. When I submit logon details I get
the following error:

Database Results Error
[Microsoft][ODBC Microsoft Access Driver]
The Microsoft Jet database engine cannot open the file '(unknown)'. It is
already opened exclusively by another user, or you need permission to view
its data.

I have looked at the Microsoft help details which has a solution that
changes the permissions by adding "Everyone" using the Security tab on the
folder's properties. When I right click my folders I do not have a Security
tab. How can I get the security tab and / or change permissions.

Help would be appreciated
Click to expand...
Click to expand...
Click to expand...
 
Yes. I initially created the connection for the site using FP. I am trying
some other coding for this page I want to use for logging onto the site. The
code has been adapted from the Frontpage Inside Out Bonus section. The code
for the function is below and seems to stop at opening the recordset:

Function AddToDb()
dim cnCont
dim constr
dim rsCont
dim sql
dim err
Set cnCont = Server.CreateObject("ADODB.Connection")
constr = "driver={Microsoft Access Driver (*.mdb)};" & _
"dbq=" & Server.MapPath("../fpdb/golfopendb.mdb")
cnCont.Open constr
Set rsCont = Server.CreateObject("ADODB.Recordset")
rsCont.Open "tblcontact", cnCont, adOpenDynamic, adLockOptimistic
rsCont.addnew
rsCont("cntemail") = qmail
rsCont("passwd") = request("qpswd")
rsCont("cntname") = request("qname")
' rsCont("IDclub") = request("qclub")
rsCont("host") = request.servervariables("REMOTE_HOST")
rsCont("brsr") = request.servervariables("HTTP_USER_AGENT")
rsCont("date") = now()
on error resume next
rsCont.Update
if err then
AddToDb = err.description
rsCont.CancelUpdate
else
AddToDb = ""
end if
rsCont.close
set rsCont = nothing
End Function

Even so, why do I not have a Security tab available for the folder
properties. I do have a Web Sharing tab. Is the the same thing?

Thomas A. Rowe said:
Are you letting FP create the connection, via Tools | Web / Site Settings | Database?

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================

beacon said:
Thanks for the reply.
Yes I am working with XP Pro and the database is not open.

Thomas A. Rowe said:
Are you working with Windows XP Pro and have IIS installed?

Also Access can not have the database open at the same time you are trying to access it from your
web pages.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================

I am having problems linking to an access database on a web site I am
developing. It is currently on localhost. When I submit logon details I get
the following error:

Database Results Error
[Microsoft][ODBC Microsoft Access Driver]
The Microsoft Jet database engine cannot open the file '(unknown)'. It is
already opened exclusively by another user, or you need permission to view
its data.

I have looked at the Microsoft help details which has a solution that
changes the permissions by adding "Everyone" using the Security tab on the
folder's properties. When I right click my folders I do not have a Security
tab. How can I get the security tab and / or change permissions.

Help would be appreciated
Click to expand...
Click to expand...
Click to expand...
 
I appear to have got around my initial problem by changing the code that
connects to the database. I have referred to the global.asa and used:

Set cnCont = Server.CreateObject("ADODB.Connection")
cnCont.Open Application("golfopen_ConnectionString")

in the code.

Thanks for your and MD Websunlimited's help so far

Thomas A. Rowe said:
Are you letting FP create the connection, via Tools | Web / Site Settings | Database?

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================

beacon said:
Thanks for the reply.
Yes I am working with XP Pro and the database is not open.

Thomas A. Rowe said:
Are you working with Windows XP Pro and have IIS installed?

Also Access can not have the database open at the same time you are trying to access it from your
web pages.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================

I am having problems linking to an access database on a web site I am
developing. It is currently on localhost. When I submit logon details I get
the following error:

Database Results Error
[Microsoft][ODBC Microsoft Access Driver]
The Microsoft Jet database engine cannot open the file '(unknown)'. It is
already opened exclusively by another user, or you need permission to view
its data.

I have looked at the Microsoft help details which has a solution that
changes the permissions by adding "Everyone" using the Security tab on the
folder's properties. When I right click my folders I do not have a Security
tab. How can I get the security tab and / or change permissions.

Help would be appreciated
Click to expand...
Click to expand...
Click to expand...
 
What is the error message?


--
Mike -- FrontPage MVP '97-'02
J-Bots 2004 102 Components For FP
http://www.websunlimited.com
FrontPage Add-ins Since '97 FP 2003 / 2002 / 2000 Compatible
Download the Trial http://www.microsoft.com/frontpage/downloads/addin/launchupdate/download.asp

beacon said:
Hi

The part of the coding I have for the connection string is:

Function AddToDb()
dim cnCont
dim constr
dim rsCont
dim sql
dim err
Set cnCont = Server.CreateObject("ADODB.Connection")
constr = "driver={Microsoft Access Driver (*.mdb)};" & _
"dbq=" & Server.MapPath("../fpdb/golfopendb.mdb")
cnCont.Open constr
Set rsCont = Server.CreateObject("ADODB.Recordset")
rsCont.Open "tblcontact", cnCont, adOpenDynamic, adLockOptimistic

It appears not to like the last line that opens the recordset.

MD Websunlimited said:
Hi,

How do you have connection string defined? Are you using a DSN or a direct file connection?

Note, FP creates a global.asa file that contains the connection string.

--
Mike -- FrontPage MVP '97-'02
J-Bots 2004 102 Components For FP
http://www.websunlimited.com
FrontPage Add-ins Since '97 FP 2003 / 2002 / 2000 Compatible
Download the Trial http://www.microsoft.com/frontpage/downloads/addin/launchupdate/download.asp

beacon said:
I am having problems linking to an access database on a web site I am
developing. It is currently on localhost. When I submit logon details I get
the following error:

Database Results Error
[Microsoft][ODBC Microsoft Access Driver]
The Microsoft Jet database engine cannot open the file '(unknown)'. It is
already opened exclusively by another user, or you need permission to view
its data.

I have looked at the Microsoft help details which has a solution that
changes the permissions by adding "Everyone" using the Security tab on the
folder's properties. When I right click my folders I do not have a Security
tab. How can I get the security tab and / or change permissions.

Help would be appreciated
Click to expand...
Click to expand...
Click to expand...
 
I have resolved it now after you pointed me in the direction of the
global.asa. I have changed the relevant part of the code to:

Set cnCont = Server.CreateObject("ADODB.Connection")
cnCont.Open Application("golfopen_ConnectionString")

Thanks for your help

MD Websunlimited said:
What is the error message?


--
Mike -- FrontPage MVP '97-'02
J-Bots 2004 102 Components For FP
http://www.websunlimited.com
FrontPage Add-ins Since '97 FP 2003 / 2002 / 2000 Compatible
Download the Trial http://www.microsoft.com/frontpage/downloads/addin/launchupdate/download.asp

beacon said:
Hi

The part of the coding I have for the connection string is:

Function AddToDb()
dim cnCont
dim constr
dim rsCont
dim sql
dim err
Set cnCont = Server.CreateObject("ADODB.Connection")
constr = "driver={Microsoft Access Driver (*.mdb)};" & _
"dbq=" & Server.MapPath("../fpdb/golfopendb.mdb")
cnCont.Open constr
Set rsCont = Server.CreateObject("ADODB.Recordset")
rsCont.Open "tblcontact", cnCont, adOpenDynamic, adLockOptimistic

It appears not to like the last line that opens the recordset.

MD Websunlimited said:
Hi,

How do you have connection string defined? Are you using a DSN or a direct file connection?

Note, FP creates a global.asa file that contains the connection string.

--
Mike -- FrontPage MVP '97-'02
J-Bots 2004 102 Components For FP
http://www.websunlimited.com
FrontPage Add-ins Since '97 FP 2003 / 2002 / 2000 Compatible
Download the Trial http://www.microsoft.com/frontpage/downloads/addin/launchupdate/download.asp

I am having problems linking to an access database on a web site I am
developing. It is currently on localhost. When I submit logon details I get
the following error:

Database Results Error
[Microsoft][ODBC Microsoft Access Driver]
The Microsoft Jet database engine cannot open the file '(unknown)'. It is
already opened exclusively by another user, or you need permission to view
its data.

I have looked at the Microsoft help details which has a solution that
changes the permissions by adding "Everyone" using the Security tab on the
folder's properties. When I right click my folders I do not have a Security
tab. How can I get the security tab and / or change permissions.

Help would be appreciated
Click to expand...
Click to expand...
Click to expand...
 
Back
Top