Re: access or network problem ?

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: ... 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: File lock problem
    ... Files on network shares open slowly, opens as read-only, or you receive an error message: ... Windows XP Shell/User ... A customer has a very small network of PCs with WinXP Home. ...
    (microsoft.public.windowsxp.general)
  • Re: Sharing a Folder Across The Network
    ... I understand ipconfig and did that already. ... >>The error message, from my computer just says that I don't have ... >>shared across the network) ... And the "no permissions...see administrator" message has so ...
    (microsoft.public.win2000.general)
  • 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)