Network Security multiple users, Getting rid of the warning messag

12 Jul 2006 11:01 AM

Daniel Lees

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

12 Jul 2006 3:14 PM

Vanessa Jennings

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!

Show quoteHide quote

"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

12 Jul 2006 3:31 PM

Daniel Lees

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

Show quoteHide quote

"Vanessa Jennings" wrote:

> 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

12 Jul 2006 3:16 PM

Vanessa Jennings

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.

Show quoteHide quote

"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

12 Jul 2006 3:17 PM

Vanessa Jennings

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.

Show quoteHide quote

"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

12 Jul 2006 3:59 PM

'69 Camaro

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.

Show quoteHide quote

"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

13 Jul 2006 11:17 AM

Daniel Lees

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

Show quoteHide quote

"'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

13 Jul 2006 6:26 PM

'69 Camaro

Hi, Danny.

> 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.

Show quoteHide quote

"Daniel Lees" <DanielL***@discussions.microsoft.com> wrote in message
news:96CC9CA2-5C00-40E9-9787-41A9D6246D8A@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