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

[Billiam]

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

 

[Jeff Boyce]

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]

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]

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]

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

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

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

 

[Guest]

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

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