Re: access or network problem ?

Michael,
I, and most others here, recommend always giving each user his/her own copy
of the frontend on their PC.

--
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:96E66854-A5E1-443F-8609-79E1EF9C4C19@xxxxxxxxxxxxxxxx
Supplementary question/observation. In my original post I stated that all
files were on the shared drive - the individual users access them via an
icon
on their PC - could the problem be due to multiple users accessing the FE
database at the same time - do I need to put seperate copes of the FE
database onto individual drives ? Note out of all the users only 2
accounts
have read/write level , the remainder have read only


"Michael" wrote:

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 ?
    ... 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: access or network problem ?
    ... "Lynn Trapp" wrote: ... notorious for being unwilling to accept that their network has a problem. ... '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