ACCESS FEED: RE: [MS_AccessPros] RE: RE: Single user to multi user

Sabtu, 28 September 2013

RE: [MS_AccessPros] RE: RE: Single user to multi user

Myra

Glad I could be of help. And sorry for the slow response. I just spent a week in a 2012 SQL Server data warehouse training course. Really cool stuff especially the SSIS packages.

Regards,

Bill

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of myrafly@yahoo.com
Sent: Thursday, September 26, 2013 10:29 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] RE: RE: Single user to multi user

Bill,

Thanks for the links to that sample code. I have at least 2 of these to do and I am really grateful to not have to think that hard to get it done. I am so glad all of you are always here.

Myra

---In MS_Access_Professionals@yahoogroups.com, <ms_access_professionals@yahoogroups.com> wrote:

liz- Ar-Ar! I don't think my dog would sit still for a robot. It would probably remind him of his arch enemy, the vacuum cleaner. Bill --- In MS_Access_Professionals@yahoogroups.com, <liz_ravenwood@...> wrote: I just visited with someone in Marysville who is using api's to talk to hardware. I suppose if you have the right port and the right robotic, you could do that.

Respectfully,
Liz Ravenwood
Programmer / Analyst
B/E Aerospace | Super First Class Environments

1851 S Pantano Road | Tucson, Arizona 85710
Office +1.520.239.4808 |
beaerospace.com
Passion to Innovate. Power to Deliver

-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com [mailto: MS_Access_Professionals@yahoogroups.com ] On Behalf Of Bill Mosca
Sent: Saturday, August 17, 2013 12:33 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: RE: [MS_AccessPros] Re: Single user to multi user

> You always impress me.

As the pants said to the dry cleaner.

Thanks, Liz. I've been developing Access applications for over 15 years. And I've had great help along the way. I've had find ways to make Access do just about everything except walk a dog. And if I can just get it to clip on the leash I'll have that, too!

Regards,

Bill

From: MS_Access_Professionals@yahoogroups.com
[mailto: MS_Access_Professionals@yahoogroups.com ] On Behalf Of Liz Ravenwood
Sent: Saturday, August 17, 2013 9:37 AM
To: ' MS_Access_Professionals@yahoogroups.com '
Subject: RE: [MS_AccessPros] Re: Single user to multi user

Cool stuff Bill! You always impress me.

Respectfully,
Liz Ravenwood
Programmer / Analyst
B/E Aerospace | Super First Class Environments

1851 S Pantano Road | Tucson, Arizona 85710 Office +1.520.239.4808 | beaerospace.com Passion to Innovate. Power to Deliver

-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com>
[mailto: MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com> ] On Behalf Of Bill Mosca
Sent: Friday, August 16, 2013 2:00 PM
To: MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com>
Subject: [MS_AccessPros] Re: Single user to multi user

Hi Liz

Most of my applications have user administrators so I don't have to mess with permissions. All I do is make adjustments when design changes are made. I also include a permissions "rank" in the user group table. Initially, there are groups ranked from 10 to 100 incremented by 10. That leaves me enough gaps to add levels if need be. And I'm always the only one with a 100 rank.

I even go so far as to write code so I can spoof as another user to test what a given rank will be able to do. That comes in handy during testing.

Bill

--- In MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com> , Liz Ravenwood <liz_ravenwood@...> wrote:

>
> I'm enjoying having the users police themselves. I use the getlogin
> code I

found to get the network login id and then based on that, they can add others to their secure group which in turn can set controls to visible, disabled, accessible...

>
> Respectfully,
> Liz Ravenwood
> Programmer / Analyst
> B/E Aerospace | Super First Class Environments
>
> 1851 S Pantano Road | Tucson, Arizona 85710 Office +1.520.239.4808 |
> beaerospace.com Passion to Innovate. Power to Deliver
>
> -----Original Message-----
> From: MS_Access_Professionals@yahoogroups.com

<mailto:MS_Access_Professionals%40yahoogroups.com>

> [mailto: MS_Access_Professionals@yahoogroups.com

<mailto:MS_Access_Professionals%40yahoogroups.com> ] On Behalf Of Bill

> Mosca
> Sent: Friday, August 16, 2013 8:52 AM
> To: MS_Access_Professionals@yahoogroups.com

<mailto:MS_Access_Professionals%40yahoogroups.com>

> Subject: [MS_AccessPros] Re: Single user to multi user
>
> Phil
>
> I find it easier to apply the security first and then split. That way
> you are

sure to have the security on the tables set at the same time as the other objects.

>
> By the bye, you might want to consider going with a do-it-yourself
> security

since the new ACCDB file format does not allow User Level Security. Scott Diamond wrote a couple of good blogs explaining how to do this. You can read them at:

> www.accesssecurityblog.com/post/Securing-Access-databases-using-Active
> -Directory.aspx
> www.accesssecurityblog.com/post/2011/04/02/Login-Security-using-Access
> -VBA.aspx
>
> Regards,
> Bill Mosca, Founder - MS_Access_Professionals
> http://www.thatlldoit.com Microsoft Office Access MVP
> https://mvp.support.microsoft.com/profile=C4D9F5E7-BB03-4291-B816-6427
> 0730881E
> My nothing-to-do-with-Access blog
> http://wrmosca.wordpress.com
>
>
>
> --- In MS_Access_Professionals@yahoogroups.com

<mailto:MS_Access_Professionals%40yahoogroups.com> , "pdk444444" <pdk444444@>
wrote:

> >
> > Hi Guys
> >
> > I have a single user database that I want to develop into a
> > multiuser and split at the same time
> >
> > Is it best to split first and then apply the user security (it is
> > mdb) or

vice versa or does it make no difference?

> >
> > cheers
> >
> > Phil
> >
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
>
>
>
>
>
> This email (and all attachments) is for the sole use of the intended

recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.

------------------------------------

Yahoo! Groups Links

This email (and all attachments) is for the sole use of the intended
recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.

[Non-text portions of this message have been removed]

------------------------------------

Yahoo! Groups Links

This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.