Re: access or network problem ?

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: 3 error causes displayed while using Remote Desktop
    ... I updated the remote desktop software from the link you had suggested before ... Now i get a different error message but i guess it ... Mapping drives ... Error: Drive Q: cannot be connected to \\EMALONFNP01\DEPTAPPS The network ...
    (microsoft.public.windowsxp.work_remotely)
  • Re: cannot find the specified file in company network drive
    ... i go to my own personal section of the network drive and try to delete ... it deletes the first file, i have to OK the error message, then i have ... to hit the delete button AGAIN, and ok the error message, hit the ... departmental shared drives, ...
    (microsoft.public.windowsxp.help_and_support)
  • Delayed Write Failed - which drive?
    ... My computer gave me the following error message: ... The computer has two local HDD's as well as several mapped network ... drives and was unattended at the time of the error. ... is \Device\Harddisk\Volume4\ a local HDD or a network drive? ...
    (microsoft.public.windowsxp.general)
  • RE: hide/remove locations in save as and open
    ... really i just want to hide or get rid of the my network places icon that is ... places icon in the left hand pane is no problem as it takes them straight to ... > use the GPO to 'hide' any and all drive letters. ... > that the user will not be able to see those drives under any circumstances. ...
    (microsoft.public.windows.server.active_directory)
  • Re: More fbreseal strange behavior
    ... cmiRemoveAutoLogon, cmiUnjoinDomain, cmiRemoveNetSettings, ... Clicking on it did not show any network connections (The ... Drives C & D are swapped. ... and icon is default "Unassociated" icon. ...
    (microsoft.public.windowsxp.embedded)