Network Security multiple users, Getting rid of the warning messag Daniel Lees 12.07.2006 11:01:02 Hi I am implementing a database that is to be shared on a network. I was wondering with the access security when a user is logged on and some1 else tries to log on with the same correct details what happens? Are they allowed on or does it say already logged on and not let u on? Another question is to do with the annoying security messages, is there a way to get rid of these for a particular database but keep them for all other files that are oppened. I don't want to put everybodies settings on low but i dont' want the annoying message to come up everytime they open my database. Cheers Danny

RE: Network Security multiple users, Getting rid of the warning messag Vanessa Jennings 12.07.2006 15:14:01 if they are using the same system.mdw they can login as many times as they like from different locations, there is no lock (that I have found). not sure about the message - must admit I have switched it to low to get rid of it! "Daniel Lees" wrote: [Quoted Text] > Hi > > I am implementing a database that is to be shared on a network. I was > wondering with the access security when a user is logged on and some1 else > tries to log on with the same correct details what happens? Are they allowed > on or does it say already logged on and not let u on? > > Another question is to do with the annoying security messages, is there a > way to get rid of these for a particular database but keep them for all other > files that are oppened. I don't want to put everybodies settings on low but i > dont' want the annoying message to come up everytime they open my database. > > Cheers > > Danny

RE: Network Security multiple users, Getting rid of the warning messag Vanessa Jennings 12.07.2006 15:16:02 I have been running a shared database for quite a while and havent found a block, if people are attached to the same system.mdw. must admit I have switched mine to low for users to get rid of the message so sorry I cant help on that one. "Daniel Lees" wrote: [Quoted Text] > Hi > > I am implementing a database that is to be shared on a network. I was > wondering with the access security when a user is logged on and some1 else > tries to log on with the same correct details what happens? Are they allowed > on or does it say already logged on and not let u on? > > Another question is to do with the annoying security messages, is there a > way to get rid of these for a particular database but keep them for all other > files that are oppened. I don't want to put everybodies settings on low but i > dont' want the annoying message to come up everytime they open my database. > > Cheers > > Danny

RE: Network Security multiple users, Getting rid of the warning messag Vanessa Jennings 12.07.2006 15:17:01 I have been running a shared database for quite a while and havent found a block, if people are attached to the same system.mdw. must admit I have switched mine to low for users to get rid of the message so sorry I cant help on that one. "Daniel Lees" wrote: [Quoted Text] > Hi > > I am implementing a database that is to be shared on a network. I was > wondering with the access security when a user is logged on and some1 else > tries to log on with the same correct details what happens? Are they allowed > on or does it say already logged on and not let u on? > > Another question is to do with the annoying security messages, is there a > way to get rid of these for a particular database but keep them for all other > files that are oppened. I don't want to put everybodies settings on low but i > dont' want the annoying message to come up everytime they open my database. > > Cheers > > Danny

RE: Network Security multiple users, Getting rid of the warning me Daniel Lees 12.07.2006 15:31:02 Yeh just been able to test it, it worked thanks alot :D Still got them messages grrrr, will have to put every1 down to low. Cheers Danny "Vanessa Jennings" wrote: [Quoted Text] > if they are using the same system.mdw they can login as many times as they > like from different locations, there is no lock (that I have found). > not sure about the message - must admit I have switched it to low to get rid > of it! > > "Daniel Lees" wrote: > > > Hi > > > > I am implementing a database that is to be shared on a network. I was > > wondering with the access security when a user is logged on and some1 else > > tries to log on with the same correct details what happens? Are they allowed > > on or does it say already logged on and not let u on? > > > > Another question is to do with the annoying security messages, is there a > > way to get rid of these for a particular database but keep them for all other > > files that are oppened. I don't want to put everybodies settings on low but i > > dont' want the annoying message to come up everytime they open my database. > > > > Cheers > > > > Danny

RE: Network Security multiple users, Getting rid of the warning messag '69 Camaro 12.07.2006 15:59:02 Hi, Danny. [Quoted Text] > I was > wondering with the access security when a user is logged on and some1 else > tries to log on with the same correct details what happens? First, for security purposes, it's not a good idea to have multiple people sharing the same User ID and password. A user can log on multiple times, as long as only 255 total log ons (connections) are made to the Access database file. After that, the users trying to connect will receive an error message that there are already 255 connections. > Another question is to do with the annoying security messages, is there a > way to get rid of these for a particular database but keep them for all other > files that are oppened. If you're referring to Access 2003 Macro Security, then you can do one of the following: 1.) Set Macro Security level to low; or 2.) Digitally sign the database file and have all users who will be opening this database "trust" this digital signature; or 3.) Use Automation Security to open an instance of Access and the database file with Access Macro Security set to low, regardless of the workstation's current setting. This won't work with Access databases where User-level Security has been implemented, but it will work in other circumstances, as long as scripts are enabled on the workstation. Please see the following Web page for the script: http://home.bendbroadband.com/conradsystems/accessjunkie/macrosecurity.html HTH. Gunny See http://www.QBuilt.com for all your database needs. See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials. http://www.Access.QBuilt.com/html/expert_contributors2.html for contact info. "Daniel Lees" wrote: > Hi > > I am implementing a database that is to be shared on a network. I was > wondering with the access security when a user is logged on and some1 else > tries to log on with the same correct details what happens? Are they allowed > on or does it say already logged on and not let u on? > > Another question is to do with the annoying security messages, is there a > way to get rid of these for a particular database but keep them for all other > files that are oppened. I don't want to put everybodies settings on low but i > dont' want the annoying message to come up everytime they open my database. > > Cheers > > Danny

RE: Network Security multiple users, Getting rid of the warning me Daniel Lees 13.07.2006 11:17:02 HI Thanks for the hlep, just one final thing. How do i assign a digital signature to the database and how do ppl allow that signature? Cheers Danny "'69 Camaro" wrote: [Quoted Text] > Hi, Danny. > > > I was > > wondering with the access security when a user is logged on and some1 else > > tries to log on with the same correct details what happens? > > First, for security purposes, it's not a good idea to have multiple people > sharing the same User ID and password. > > A user can log on multiple times, as long as only 255 total log ons > (connections) are made to the Access database file. After that, the users > trying to connect will receive an error message that there are already 255 > connections. > > > Another question is to do with the annoying security messages, is there a > > way to get rid of these for a particular database but keep them for all other > > files that are oppened. > > If you're referring to Access 2003 Macro Security, then you can do one of > the following: > > 1.) Set Macro Security level to low; or > 2.) Digitally sign the database file and have all users who will be opening > this database "trust" this digital signature; or > 3.) Use Automation Security to open an instance of Access and the database > file with Access Macro Security set to low, regardless of the workstation's > current setting. This won't work with Access databases where User-level > Security has been implemented, but it will work in other circumstances, as > long as scripts are enabled on the workstation. Please see the following Web > page for the script: > > http://home.bendbroadband.com/conradsystems/accessjunkie/macrosecurity.html > > HTH. > Gunny > > See http://www.QBuilt.com for all your database needs. > See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials. > http://www.Access.QBuilt.com/html/expert_contributors2.html for contact info. > > > "Daniel Lees" wrote: > > > Hi > > > > I am implementing a database that is to be shared on a network. I was > > wondering with the access security when a user is logged on and some1 else > > tries to log on with the same correct details what happens? Are they allowed > > on or does it say already logged on and not let u on? > > > > Another question is to do with the annoying security messages, is there a > > way to get rid of these for a particular database but keep them for all other > > files that are oppened. I don't want to put everybodies settings on low but i > > dont' want the annoying message to come up everytime they open my database. > > > > Cheers > > > > Danny

Re: Network Security multiple users, Getting rid of the warning me "'69 Camaro" <ForwardZERO_SPAM.To.69Camaro[ at ]Spameater.orgZERO_SPAM> 13.07.2006 18:26:28 Hi, Danny. [Quoted Text] > How do i assign a digital > signature to the database and how do ppl allow that signature? Please see the following Web pages for more information on digital signatures: http://msdn.microsoft.com/library/default.asp?url=/workshop/security/authcode/intro_authenticode.asp http://office.microsoft.com/en-us/assistance/HP010446121033.aspx?mode=print http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odeopg/html/deovrsigningvbaproject.asp http://office.microsoft.com/en-us/assistance/HP010397921033.aspx?mode=print http://office.microsoft.com/en-us/assistance/HP010446151033.aspx?mode=print HTH. Gunny See http://www.QBuilt.com for all your database needs. See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials. http://www.Access.QBuilt.com/html/expert_contributors2.html for contact info. "Daniel Lees" <DanielLees[ at ]discussions.microsoft.com> wrote in message news:96CC9CA2-5C00-40E9-9787-41A9D6246D8A[ at ]microsoft.com... > HI > > Thanks for the hlep, just one final thing. How do i assign a digital > signature to the database and how do ppl allow that signature? > > Cheers > > Danny > > "'69 Camaro" wrote: > >> Hi, Danny. >> >> > I was >> > wondering with the access security when a user is logged on and some1 >> > else >> > tries to log on with the same correct details what happens? >> >> First, for security purposes, it's not a good idea to have multiple >> people >> sharing the same User ID and password. >> >> A user can log on multiple times, as long as only 255 total log ons >> (connections) are made to the Access database file. After that, the >> users >> trying to connect will receive an error message that there are already >> 255 >> connections. >> >> > Another question is to do with the annoying security messages, is there >> > a >> > way to get rid of these for a particular database but keep them for all >> > other >> > files that are oppened. >> >> If you're referring to Access 2003 Macro Security, then you can do one of >> the following: >> >> 1.) Set Macro Security level to low; or >> 2.) Digitally sign the database file and have all users who will be >> opening >> this database "trust" this digital signature; or >> 3.) Use Automation Security to open an instance of Access and the >> database >> file with Access Macro Security set to low, regardless of the >> workstation's >> current setting. This won't work with Access databases where User-level >> Security has been implemented, but it will work in other circumstances, >> as >> long as scripts are enabled on the workstation. Please see the following >> Web >> page for the script: >> >> http://home.bendbroadband.com/conradsystems/accessjunkie/macrosecurity.html >> >> HTH. >> Gunny >> >> See http://www.QBuilt.com for all your database needs. >> See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials. >> http://www.Access.QBuilt.com/html/expert_contributors2.html for contact >> info. >> >> >> "Daniel Lees" wrote: >> >> > Hi >> > >> > I am implementing a database that is to be shared on a network. I was >> > wondering with the access security when a user is logged on and some1 >> > else >> > tries to log on with the same correct details what happens? Are they >> > allowed >> > on or does it say already logged on and not let u on? >> > >> > Another question is to do with the annoying security messages, is there >> > a >> > way to get rid of these for a particular database but keep them for all >> > other >> > files that are oppened. I don't want to put everybodies settings on low >> > but i >> > dont' want the annoying message to come up everytime they open my >> > database. >> > >> > Cheers >> > >> > Danny