
Signature
Wally Steadman
US Army in Iraq
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.
> 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