Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Multiuser / Networking / June 2005

Tip: Looking for answers? Try searching our database.

Advice on Multi-User environment

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Walter Steadman - 23 Jun 2005 12:50 GMT
Hello all,
   I have built many Access Databases, but I am clueless on the Multi User
environment.  I wanted to take one of my Stand Alone databases and make it
accessible to others.  I have read about Front End and Back End, but that is
about as far as I understand.  Are there any online resources that give good
examples of Multi-User Modes?

Question 2.  Is it possible to have a multiuser mode where who you log in as
is part of a query so you can only see your organizations data?  Might be
asking too deep of a question for my little(virutally none) experience with
multi user environment.

Any sites or suggestions would be greatly appreciated.

Signature

Wally Steadman
US Army in Iraq

Alex Dybenko - 23 Jun 2005 14:06 GMT
Hi,
i think here you can find few tips:
http://www.granite.ab.ca/access/tipsindex.htm

Signature

Alex Dybenko (MVP)
http://Alex.Dybenko.com
http://www.PointLtd.com

> Hello all,
>    I have built many Access Databases, but I am clueless on the Multi User
[quoted text clipped - 9 lines]
>
> Any sites or suggestions would be greatly appreciated.
Larry  Linson - 23 Jun 2005 23:08 GMT
> i think here you can find few tips:
> http://www.granite.ab.ca/access/tipsindex.htm

Yes, at least a _few_. <BIG GRIN>

That site, done by MVP Tony Toews, has the _very best_ collection of
information and links about using Access in a multiuser environment of any
that I have seen.

At an introductory level, there is a PowerPoint presentation I did for my
user group some time ago at http://appdevissues.tripod.com, in the Downloads
area.

Larry Linson
Microsoft Access MVP
Walter Steadman - 24 Jun 2005 11:44 GMT
Thanks so much for the advice.  Going to those sites and reading now.
Appreciate it very much.

Wally

> Hi,
> i think here you can find few tips:
[quoted text clipped - 13 lines]
>>
>> Any sites or suggestions would be greatly appreciated.
Tony Toews - 24 Jun 2005 04:08 GMT
>    I have built many Access Databases, but I am clueless on the Multi User
>environment.  I wanted to take one of my Stand Alone databases and make it
>accessible to others.  I have read about Front End and Back End, but that is
>about as far as I understand.  Are there any online resources that give good
>examples of Multi-User Modes?

You already have an excellent answer referencing my website by two
fine gentlemen.  <smile>   But to answer your question a bit more
explicitly see the "Splitting your app into a front end and back end
Tips" page at http://www.granite.ab.ca/access/splitapp/ for more info.
See the Auto FE Updater downloads page
http://www.granite.ab.ca/access/autofe.htm to make this relatively
painless..   The utility also supports Terminal Server/Citrix quite
nicely.

>Question 2.  Is it possible to have a multiuser mode where who you log in as
>is part of a query so you can only see your organizations data?  Might be
>asking too deep of a question for my little(virutally none) experience with
>multi user environment.

Certainly however be aware that Access security isn't that good.
That is with a little sluething someone could open up the back end and
look at the tables directly and see data they aren't supposed to view.
Or they could create an MDB which would link to the back end MDB.  Or
... but the possibilities are endless.  

The only way to make this truly secure are to use SQL Server and more.
Much more.

But If you want something simple and lightweight you could use the
Windows networking userid along with some tables defining which
organizations you can view.  

API: Get Login name
http://www.mvps.org/access/api/api0008.htm

Tony
Signature

Tony Toews, Microsoft Access MVP
  Please respond only in the newsgroups so that others can
read the entire thread of messages.
  Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

Walter Steadman - 24 Jun 2005 11:45 GMT
Tony,
   Thank you and the group for your great advice.  Great site by the way.

>>    I have built many Access Databases, but I am clueless on the Multi
>> User
[quoted text clipped - 38 lines]
>
> Tony
Tony Toews - 24 Jun 2005 17:50 GMT
>    Thank you and the group for your great advice.  Great site by the way.

Thanks for the comments.  They make the effort worthwhile.

Tony
Signature

Tony Toews, Microsoft Access MVP
  Please respond only in the newsgroups so that others can
read the entire thread of messages.
  Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

Trauton - 28 Jun 2005 05:07 GMT
Hi,

Thanks to the advice on this site and Tony's, I was able to set up a
multi-user database that automatically filters the records by capturing the
User login name and transferring it to the queries.  That works great!  I now
have a related question; since all records are tied to specific users it is
easy to filter them by user name.  Occassionally, I will also need to allow
User X to see the records belonging to User Y.  I woud like to use a similar
approach to the Login capture form where the User X enters certain User Name
and the rest of the queries capture the information from this input form and
return the result.  Or if there was a way where I could set this up so when
User X logs, he or she is automatically able to see the records belonging to
User Y (besides his or her own).  Sorry for the long post, I'm very new at
this.  

Trauton

> >    Thank you and the group for your great advice.  Great site by the way.
>
> Thanks for the comments.  They make the effort worthwhile.
>
> Tony
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.