database error.

A

Adam

Hello, hie enter too soon. I have a website that uses the guestbook from http://www.webwizguide.info/asp/sample_scripts/guestbook_script.asp the problem is that when I set the permissions on the folder that holds my database to modify I recieve the following error when I try to access the database.------- Microsoft JET Database Engine error '80004005'

Could not use ''; file already in use.

/forum/common.asp, line 180
----- the connection works just fine because when I set the permissions to read only it will allow me to login for admin but cannot change the appearance because it is database driven. When the permissions are set to modify It will not even allow me to login in. Any suggestions on what could cause this. THanks Adam
 
T

Thomas A. Rowe

You don't need to set permission directly on the folder or database, let FP place the database into
the fpdb folder where FP will then set the correct permissions.

Never modify the database directly with Access via FP or while it is on the live server, as that
will lock site users out.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================


Adam said:
Hello, hie enter too soon. I have a website that uses the guestbook from
Click to expand...
http://www.webwizguide.info/asp/sample_scripts/guestbook_script.asp the problem is that when I set
the permissions on the folder that holds my database to modify I recieve the following error when I
try to access the database.------- Microsoft JET Database Engine error '80004005'
Could not use ''; file already in use.

/forum/common.asp, line 180
----- the connection works just fine because when I set the permissions to read only it will allow
Click to expand...
me to login for admin but cannot change the appearance because it is database driven. When the
permissions are set to modify It will not even allow me to login in. Any suggestions on what could
cause this. THanks Adam
 
A

Adam

maybye I am not understanding what you are saying but I dowloaded this script from a website FP has nothing to do with the database. The connection to the database is already established in one of the pages I downloaded. It says in the readme file to make sure the permissions on the database are set to read and write for it to work on the server. My server call this access Modify( for read and write).
 
T

Thomas A. Rowe

Move the database to the fpdb folder, then change the path in the config file to point to the
database in the fpdb folder. The fpdb folder by default has the required permissions needed use a
Access based application on the web.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================


Adam said:
maybye I am not understanding what you are saying but I dowloaded this script from a website FP
Click to expand...
has nothing to do with the database. The connection to the database is already established in one of
the pages I downloaded. It says in the readme file to make sure the permissions on the database are
set to read and write for it to work on the server. My server call this access Modify( for read and
write).
 
Top