Hello,

I am getting an error message that i cannot seem to solve.  I can read the 
MS Acesss database fine, but when it comes to writing to it..i get the 
following message:

Microsoft OLE DB Provider for ODBC Drivers error '80004005' 

[Microsoft][ODBC Microsoft Access Driver] Could not use '(unknown)'; file 
already in use. 
-----
I thought it may have been a server NT error so i asked my webhost to 
grant write permissions to the directory.

They wrote back:
"Write permissions should have already been enabled on the file.  If not, 
you will need to set them through FrontPage.  This is not something that 
can be done server side because of the FrontPage extensions."

It works fine when i am running this on pws, but when I upload it to my 
host, it gets the above error message. 

Can anyone help me?
Jennifer

Personally I think your webhost is feeding you a load of rubbish.

They need to check the *NTFS* permissions for:
a) the .mdb file on the server (needs to be RX)
b) the /folder/ that the .mdb file is in - this is so that Access can create
and delete the .ldb lockfile
c) the %systemroot%\temp folder (Access needs to be able to read/write to
this folder to create Jet temporary files

Usually this has nothing to do with FPSE

Cheers
Ken

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "Jenny Yan" <jenjenyan@h...>
Subject: [access_asp] Could not use '(unknown)'; file already in use.


:
: I am getting an error message that i cannot seem to solve.  I can read the
: MS Acesss database fine, but when it comes to writing to it..i get the
: following message:
:
: Microsoft OLE DB Provider for ODBC Drivers error '80004005'
:
: [Microsoft][ODBC Microsoft Access Driver] Could not use '(unknown)'; file
: already in use.
: -----
: I thought it may have been a server NT error so i asked my webhost to
: grant write permissions to the directory.
:
: They wrote back:
: "Write permissions should have already been enabled on the file.  If not,
: you will need to set them through FrontPage.  This is not something that
: can be done server side because of the FrontPage extensions."
:
: It works fine when i am running this on pws, but when I upload it to my
: host, it gets the above error message.
:
: Can anyone help me?
: Jennifer

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~