Re: access or network problem ?

Lynn,
I agree - Friday afternoon, the Server went down !. I'll monitor the
situation, and repost if anything changes. Thanks for your help.

Mike


"Lynn Trapp" wrote:

Then, I'm also leaning in the direction of a network problem. IT folks are
notorious for being unwilling to accept that their network has a problem.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html



"Michael" <Michael@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:B18CEAF8-E3E9-4B1F-A7A5-2067D3BD99BF@xxxxxxxxxxxxxxxx
Yes they do, confirmed by my IT department, they also checked there was
sufficient space on the drive as well - this is why they thought it was an
access problem & not a network one. However, we still have occasional
problems with other applications such as Excel when saving to the network
drive - S drive can't be found ! & this is why I'm not 100% convinced it's
an
application problem

"Lynn Trapp" wrote:

The first thing to check is whether or not ALL users have full
permissions
to the folder where the database resides.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html



"Michael" <Michael@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:8A981F6B-E485-467D-9B81-5F872175F7A0@xxxxxxxxxxxxxxxx
I have a split database with security (all files on network drive) - two
'types' of user - User (with Read Access), and Administrator
(Read/Write/Delete/Create). The database is accessed via icons on
desktop
(7
in total). I'm getting the following intermittant error messages
Double click icon - opens access then displays access error message
'Microsoft Access couldn't find file
'S:\Cervscr\Databases\Secured.mdw'.
This
file is required for startup' where S = network drive.
If I open the mdb file either from the File open menu or via explorer
and
double clicking on the file Access displays error message ' you do not
have
the necessary permissions to use the 'S:\Cervscr\Databases\QARC
Contact.mdb'
object. Have your system administrator or the person who created the
object
establish the appropriate permissions for you'.
However by repeatedly attempting to access via the icon will usually
result
in sucess with a prompt for the password. I have contacted our IT
department
who believes its an access not a network problem - I'm not 100%
convinced
as
there has previously not been any problems. Final piece of info that
may
help. This error message appears on all 7 PC's (different network
accounts),
if an administrator manages to open file, and somebody else enters
their
password (both user & administrator) then the following error message
appears
- The database has been placed in a state by user 'Administrator' on
machine
'HP14562106531' that prevents it from being opened or locked'

Any suggestions ?

Mike







.

Relevant Pages

  • Re: access or network problem ?
    ... "Lynn Trapp" wrote: ... access problem & not a network one. ... 'types' of user - User, and Administrator ... This error message appears on all 7 PC's (different network ...
    (microsoft.public.access.security)
  • Re: access or network problem ?
    ... access problem & not a network one. ... 'types' of user - User, and Administrator ... Double click icon - opens access then displays access error message ...
    (microsoft.public.access.security)
  • Re: P2P networking
    ... You might not have permission to use the ... Contact the administrator of the server to find out if ... Thanks for posting the error message -- it really helps. ... Run XP's Network Setup Wizard on Computer2 -- that's often all that's ...
    (microsoft.public.windowsxp.network_web)
  • Re: access or network problem ?
    ... I'm also leaning in the direction of a network problem. ... "Lynn Trapp" wrote: ... 'types' of user - User, and Administrator ... Double click icon - opens access then displays access error message ...
    (microsoft.public.access.security)
  • Re: P2P networking
    ... You might not have permission to use the ... Thanks for posting the error message -- it really helps. ... Run XP's Network Setup Wizard on Computer2 -- that's often all that's ... consult with the network administrator. ...
    (microsoft.public.windowsxp.network_web)
Loading