PC Review


Reply
Thread Tools Rate Thread

Access 2007-can each front end user have a different front end?

 
 
Billiam
Guest
Posts: n/a
 
      8th Aug 2008
I was wondering if it is possible for each front end user to have a different
front end, as some users only need access to certain items, while others have
different needs. If you can do this, is there anything to be careful of when
setting it up this way?
Thanks,
Billiam
 
Reply With Quote
 
 
 
 
Jeff Boyce
Guest
Posts: n/a
 
      8th Aug 2008
Billiam

Creating (and maintaining) a separate Front-End for each user sounds like a
lot of work. Especially if you need to make changes in them all and
redeploy them.

Another approach might be to create a single Front-End that has the users
identify themselves and sets up/configures itself to work as that user
needs/expects. That way, any change you needed to make would only need to
be made once, in one version, prior to redeployment.

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP


"Billiam" <(E-Mail Removed)> wrote in message
news:9B285502-A82A-494A-BC77-(E-Mail Removed)...
>I was wondering if it is possible for each front end user to have a
>different
> front end, as some users only need access to certain items, while others
> have
> different needs. If you can do this, is there anything to be careful of
> when
> setting it up this way?
> Thanks,
> Billiam



 
Reply With Quote
 
Billiam
Guest
Posts: n/a
 
      11th Aug 2008
Sounds great, Jeff. How would i accomplish what you are suggesting--a
switchboard, autoexec? The few users (5) mostly just need to access reports,
and one needs to import our instructor list into her computer which she then
uses in another application...There is only one person doing the data entry
end. Finally, they will be accessing the data from our server through the
internet. Any advice appreciated as we will have to implement this in the
next month.
Many Thanks,
Billiam

"Jeff Boyce" wrote:

> Billiam
>
> Creating (and maintaining) a separate Front-End for each user sounds like a
> lot of work. Especially if you need to make changes in them all and
> redeploy them.
>
> Another approach might be to create a single Front-End that has the users
> identify themselves and sets up/configures itself to work as that user
> needs/expects. That way, any change you needed to make would only need to
> be made once, in one version, prior to redeployment.
>
> Good luck!
>
> Regards
>
> Jeff Boyce
> Microsoft Office/Access MVP
>
>
> "Billiam" <(E-Mail Removed)> wrote in message
> news:9B285502-A82A-494A-BC77-(E-Mail Removed)...
> >I was wondering if it is possible for each front end user to have a
> >different
> > front end, as some users only need access to certain items, while others
> > have
> > different needs. If you can do this, is there anything to be careful of
> > when
> > setting it up this way?
> > Thanks,
> > Billiam

>
>
>

 
Reply With Quote
 
Jeff Boyce
Guest
Posts: n/a
 
      13th Aug 2008
I have no experience "accessing [Access] data ... through the internet", and
have seen many postings advising against doing this.

Perhaps one of the other newsgroup readers can offer more specific
suggestions...

I used a login screen (self-created, not the Access security model) to
identify the individuals, then used that identification to modify what was
displayed. No, I didn't use the switchboard.

Regards

Jeff Boyce
Microsoft Office/Access MVP


"Billiam" <(E-Mail Removed)> wrote in message
news:B3D2CB9C-7498-4D0E-ABE0-(E-Mail Removed)...
> Sounds great, Jeff. How would i accomplish what you are suggesting--a
> switchboard, autoexec? The few users (5) mostly just need to access
> reports,
> and one needs to import our instructor list into her computer which she
> then
> uses in another application...There is only one person doing the data
> entry
> end. Finally, they will be accessing the data from our server through the
> internet. Any advice appreciated as we will have to implement this in the
> next month.
> Many Thanks,
> Billiam
>
> "Jeff Boyce" wrote:
>
>> Billiam
>>
>> Creating (and maintaining) a separate Front-End for each user sounds like
>> a
>> lot of work. Especially if you need to make changes in them all and
>> redeploy them.
>>
>> Another approach might be to create a single Front-End that has the users
>> identify themselves and sets up/configures itself to work as that user
>> needs/expects. That way, any change you needed to make would only need
>> to
>> be made once, in one version, prior to redeployment.
>>
>> Good luck!
>>
>> Regards
>>
>> Jeff Boyce
>> Microsoft Office/Access MVP
>>
>>
>> "Billiam" <(E-Mail Removed)> wrote in message
>> news:9B285502-A82A-494A-BC77-(E-Mail Removed)...
>> >I was wondering if it is possible for each front end user to have a
>> >different
>> > front end, as some users only need access to certain items, while
>> > others
>> > have
>> > different needs. If you can do this, is there anything to be careful of
>> > when
>> > setting it up this way?
>> > Thanks,
>> > Billiam

>>
>>
>>



 
Reply With Quote
 
Billiam
Guest
Posts: n/a
 
      13th Aug 2008
Thank you Jeff, I will give the login idea a try. Has anyone posted how to
modify what is displayed after the login procedure? If they have and woudn't
mind sharing that would be very helpful!
Thanks again for your help, Jeff, I really appreciate it!
Billiam
"Jeff Boyce" wrote:

> I have no experience "accessing [Access] data ... through the internet", and
> have seen many postings advising against doing this.
>
> Perhaps one of the other newsgroup readers can offer more specific
> suggestions...
>
> I used a login screen (self-created, not the Access security model) to
> identify the individuals, then used that identification to modify what was
> displayed. No, I didn't use the switchboard.
>
> Regards
>
> Jeff Boyce
> Microsoft Office/Access MVP
>
>
> "Billiam" <(E-Mail Removed)> wrote in message
> news:B3D2CB9C-7498-4D0E-ABE0-(E-Mail Removed)...
> > Sounds great, Jeff. How would i accomplish what you are suggesting--a
> > switchboard, autoexec? The few users (5) mostly just need to access
> > reports,
> > and one needs to import our instructor list into her computer which she
> > then
> > uses in another application...There is only one person doing the data
> > entry
> > end. Finally, they will be accessing the data from our server through the
> > internet. Any advice appreciated as we will have to implement this in the
> > next month.
> > Many Thanks,
> > Billiam
> >
> > "Jeff Boyce" wrote:
> >
> >> Billiam
> >>
> >> Creating (and maintaining) a separate Front-End for each user sounds like
> >> a
> >> lot of work. Especially if you need to make changes in them all and
> >> redeploy them.
> >>
> >> Another approach might be to create a single Front-End that has the users
> >> identify themselves and sets up/configures itself to work as that user
> >> needs/expects. That way, any change you needed to make would only need
> >> to
> >> be made once, in one version, prior to redeployment.
> >>
> >> Good luck!
> >>
> >> Regards
> >>
> >> Jeff Boyce
> >> Microsoft Office/Access MVP
> >>
> >>
> >> "Billiam" <(E-Mail Removed)> wrote in message
> >> news:9B285502-A82A-494A-BC77-(E-Mail Removed)...
> >> >I was wondering if it is possible for each front end user to have a
> >> >different
> >> > front end, as some users only need access to certain items, while
> >> > others
> >> > have
> >> > different needs. If you can do this, is there anything to be careful of
> >> > when
> >> > setting it up this way?
> >> > Thanks,
> >> > Billiam
> >>
> >>
> >>

>
>
>

 
Reply With Quote
 
Guest
Posts: n/a
 
      14th Aug 2008


"Jeff Boyce" <(E-Mail Removed)> escribió en el mensaje de
noticias:eKMYtcV$(E-Mail Removed)...
> I have no experience "accessing [Access] data ... through the internet",
> and have seen many postings advising against doing this.
>
> Perhaps one of the other newsgroup readers can offer more specific
> suggestions...
>
> I used a login screen (self-created, not the Access security model) to
> identify the individuals, then used that identification to modify what was
> displayed. No, I didn't use the switchboard.
>
> Regards
>
> Jeff Boyce
> Microsoft Office/Access MVP
>
>
> "Billiam" <(E-Mail Removed)> wrote in message
> news:B3D2CB9C-7498-4D0E-ABE0-(E-Mail Removed)...
>> Sounds great, Jeff. How would i accomplish what you are suggesting--a
>> switchboard, autoexec? The few users (5) mostly just need to access
>> reports,
>> and one needs to import our instructor list into her computer which she
>> then
>> uses in another application...There is only one person doing the data
>> entry
>> end. Finally, they will be accessing the data from our server through the
>> internet. Any advice appreciated as we will have to implement this in the
>> next month.
>> Many Thanks,
>> Billiam
>>
>> "Jeff Boyce" wrote:
>>
>>> Billiam
>>>
>>> Creating (and maintaining) a separate Front-End for each user sounds
>>> like a
>>> lot of work. Especially if you need to make changes in them all and
>>> redeploy them.
>>>
>>> Another approach might be to create a single Front-End that has the
>>> users
>>> identify themselves and sets up/configures itself to work as that user
>>> needs/expects. That way, any change you needed to make would only need
>>> to
>>> be made once, in one version, prior to redeployment.
>>>
>>> Good luck!
>>>
>>> Regards
>>>
>>> Jeff Boyce
>>> Microsoft Office/Access MVP
>>>
>>>
>>> "Billiam" <(E-Mail Removed)> wrote in message
>>> news:9B285502-A82A-494A-BC77-(E-Mail Removed)...
>>> >I was wondering if it is possible for each front end user to have a
>>> >different
>>> > front end, as some users only need access to certain items, while
>>> > others
>>> > have
>>> > different needs. If you can do this, is there anything to be careful
>>> > of
>>> > when
>>> > setting it up this way?
>>> > Thanks,
>>> > Billiam
>>>
>>>
>>>

>
>

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Citrix Deployment of Access 2007 Front End RobXMiller Microsoft Access 0 15th Jul 2010 06:09 PM
Access 2007 Web Front end OD Microsoft Access VBA Modules 22 9th Nov 2009 08:28 PM
Access 2007 Front End for SQL 2005 =?Utf-8?B?QnJha2VybTE5?= Microsoft Access 35 7th Oct 2006 09:18 AM
Re: Access 2007 Front End for SQL 2005 Manuel Lopez Microsoft Access ADP SQL Server 7 12th Jun 2006 11:49 PM
XP Pro Allows User to view SQL tables through Access front end Phil Smith Windows XP Security 0 10th Sep 2003 10:15 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:47 PM.