access or network problem ?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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,
I agree - Friday afternoon, the Server went down !. I'll monitor the
situation, and repost if anything changes. Thanks for your help.

Mike
 
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
 
Back
Top