access or network problem ? Michael 03.03.2006 11:41:27 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

Re: access or network problem ? "Lynn Trapp" <ltrapp_NOSPAM[ at ]ltcomputerdesigns.com> 03.03.2006 13:19:57 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[ at ]discussions.microsoft.com> wrote in message news:8A981F6B-E485-467D-9B81-5F872175F7A0[ at ]microsoft.com... [Quoted Text] >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 >

Re: access or network problem ? Michael 03.03.2006 13:58:31 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: [Quoted Text] > 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[ at ]discussions.microsoft.com> wrote in message > news:8A981F6B-E485-467D-9B81-5F872175F7A0[ at ]microsoft.com... > >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 > > > > >

Re: access or network problem ? "Lynn Trapp" <ltrapp_NOSPAM[ at ]ltcomputerdesigns.com> 03.03.2006 17:58:59 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[ at ]discussions.microsoft.com> wrote in message news:B18CEAF8-E3E9-4B1F-A7A5-2067D3BD99BF[ at ]microsoft.com... [Quoted Text] > 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[ at ]discussions.microsoft.com> wrote in message >> news:8A981F6B-E485-467D-9B81-5F872175F7A0[ at ]microsoft.com... >> >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 >> > >> >> >>

Re: access or network problem ? Michael 06.03.2006 09:33:28 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: [Quoted Text] > 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[ at ]discussions.microsoft.com> wrote in message > news:B18CEAF8-E3E9-4B1F-A7A5-2067D3BD99BF[ at ]microsoft.com... > > 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[ at ]discussions.microsoft.com> wrote in message > >> news:8A981F6B-E485-467D-9B81-5F872175F7A0[ at ]microsoft.com... > >> >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 > >> > > >> > >> > >> > > >

Re: access or network problem ? Michael 27.03.2006 15:40:03 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: [Quoted Text] > 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[ at ]discussions.microsoft.com> wrote in message > > news:B18CEAF8-E3E9-4B1F-A7A5-2067D3BD99BF[ at ]microsoft.com... > > > 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[ at ]discussions.microsoft.com> wrote in message > > >> news:8A981F6B-E485-467D-9B81-5F872175F7A0[ at ]microsoft.com... > > >> >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 > > >> > > > >> > > >> > > >> > > > > > >

Re: access or network problem ? "Lynn Trapp" <ltrapp_NOSPAM[ at ]ltcomputerdesigns.com> 27.03.2006 16:08:50 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[ at ]discussions.microsoft.com> wrote in message news:96E66854-A5E1-443F-8609-79E1EF9C4C19[ at ]microsoft.com... [Quoted Text] > 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[ at ]discussions.microsoft.com> wrote in message >> > news:B18CEAF8-E3E9-4B1F-A7A5-2067D3BD99BF[ at ]microsoft.com... >> > > 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[ at ]discussions.microsoft.com> wrote in message >> > >> news:8A981F6B-E485-467D-9B81-5F872175F7A0[ at ]microsoft.com... >> > >> >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 >> > >> > >> > >> >> > >> >> > >> >> > >> > >> >