Daniel
> Never did update my Y! profile. I guess it's better than being named "001100101001010".
That would be a "bit" much. {grin}
I'd love to see your tools uploaded. Please remember they have to be open-source because our site shares everything. If you don't feel comfortable with open-source you can always add links to your stuff in our Links folder.
I still think your current setup is unnecessary, but maybe I'm not seeing the big picture. Are you saying the desktop is being remoted to by the other 3 stations? ACK!
Giving everyone the FE they need would be so much easier. And deploying MDEs is a snap if you use the VBScript I have on my site (http://www.thatlldoit.com/Pages/howtosarticles.aspx). All I do these days is email the user a hyperlink to the script. I only have to do that once. If I make a new version of the FE I just change the text file name and its corresponding variable in the script.
Bill
--- In MS_Access_Professionals@yahoogroups.com, "Daniel Combs" <drc0369@...> wrote:
>
> Never did update my Y! profile. I guess it's better than being named "001100101001010".
>
> Thanks for the tips. The thing is that the desktop is a shared desktop for all 3 stations. In other words, what one person sees on one station, another user on a second station is logged into the same desktop. Hence the three FE db's. One assigned to each station. Basically a roaming login. It can be accessed from other PC's also as well as remote access from home.
>
> I'll check out the inactive shutdown tool as well as a few others I saw that could be helpful in other areas. Will be posting a few of my own for others to check out as well.
>
> I thought about going the mde route before, will look into it as well.
>
> Again thanks, until next post. May the vba force be with you.
>
> --- In MS_Access_Professionals@yahoogroups.com, "Bill Mosca" <wrmosca@> wrote:
> >
> > Happy Birthday, drc0369! (Your name? or did your parents have an unorthodox process for choosing their children's names?)
> >
> > I don't see what the problem is in a user opening the FE on 3 different stations. Each instance would still be unique. And if you use my code for inactive shutdown you can make sure if they open the FE and leave it idle for a specified time it will close itself.
> >
> > Please don't use a shared FE in a multi-user environment. That's just asking for trouble.
> >
> > As to hiding your code you can either compile the database as an mde/accde file in which the code cannot be read or put a password on the VBA project (but that is way too easy to crack).
> >
> > 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-64270730881E
> > My nothing-to-do-with-Access blog
> > http://wrmosca.wordpress.com
> >
> >
> >
> > --- In MS_Access_Professionals@yahoogroups.com, "drc0369" <drc0369@> wrote:
> > >
> > >
> > > Hello all, I've been gone for a while but it's good to be back. While
> > > gone my Access skills and VB.NET skills have increase a good bit. I have
> > > two issus though that I still haven't mastered. Creating a multi-user db
> > > with login/password access. I know fairly well how to create the tables
> > > that determine which level of db access each user should have that is
> > > checked against, but i want to know how to go about it when it's a
> > > single db that is a split db (front end and back end). Because of the
> > > intranet set up our department has one shared login, but we can be
> > > active on three different PC's. I know that using just one front end for
> > > multiple users can be problematic at times, but for now this is the best
> > > setup we can have untill it changes.
> > >
> > > For that reason, I have three front end db's (DB1, DB2, DB3) that the
> > > user can use depending on which PC they are on. Tried sifting through
> > > the previous posts to see if there were any similar posts but found none
> > > (or I didn't sift deep enough). What would be the best way to tackle
> > > this? I use to put the password in the vba code as a constant to match
> > > up against, but of course anyone with any vba knowledge can just go into
> > > the code and see the password. It's not a critical situation, but it
> > > just helps to be safe.
> > >
> > > And today just happens to be my 44th b-day!
> > >
> >
>
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (4) |
Tidak ada komentar:
Posting Komentar