Re: access or network problem ?

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: Fresh installation and no access
    ... You're not getting access because you're not an administrator when you log ... In previous OS's you had administrator permissions on the database ... You must create a login (to allow connect to SQL Server) then a user to be ...
    (microsoft.public.sqlserver.security)
  • RE: Error opening database.
    ... desperation to making progress. ... Have your system administrator or the ... person who created this object establish the appropriate permissions for you." ... I have tried to create/open a database in my account ...
    (microsoft.public.access.setupconfig)
  • Re: Probs accessing database for users of newly developed Superuse
    ... Holding down the shiftkey does not bypass any security permissions, so if that succeeds, then you don't have a permissions problem with the database object. ... my Superusers aren't using the database yet. ... administrator and change what I need to change then I log out. ...
    (microsoft.public.access.security)
  • Re: error message
    ... If you re-install Word, you are likely to make this problem ten times worse, ... Then you need to "repair permissions" on your boot volume to straighten out ... The "Entourage Database" is used to link together a heap of things in Mac ... I get this error message. ...
    (microsoft.public.mac.office.word)
  • Re: error message when installing Microsoft Office, 1402
    ... I get an error message: Cannot Open RUN: Error while opening key. ... Mary Sauer MSFT MVP ... I can't get as far as the Permissions folder; I get as far as the RUN folder ... Administrator & password box comes up and there ...
    (microsoft.public.office.setup)