New to multiuser

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Trauton - 24 May 2005 06:15 GMT

Hi,

I am new to multiuser Access design. I created an Access database that
successfully addresses certain functions in our company. Now we are thinking
of housing it in a server and allowing multiple users to add their data and
use it. The main advantage being that we will be able to create reports from
the single database with the consolidated data. I'm sure there are many
questions that I can't even figure out yet... but here's the first one: I
would like each user to only see the information on the tables that is
"tagged to them". This is because during the data entry, it will be much
more efficient for them to select from a drop down list showing the Accounts
assigned to them (usually about 15), than having to scroll through 200
different accounts. A similar issue comes up when they have to see their
open projects (just seeing "their" open projects instead of all the open
projects). What is the best way to accomplish this? (sorry for the long
post!)

Reply to this Message

Alex White MCDBA MCSE - 24 May 2005 06:25 GMT

use the code below in a module, to get the logged in users name

http://www.mvps.org/access/api/api0008.htm

add a field to your main table called something like user_name
when they add a new record stamp the record with their username

e.g.

me.txtuser_name.value = fOSUserName()

txtuser_name is the bound textbox on the form bound to the user_name field

and your query for the form should be some thing like

'Select * from TblTest Where user_name=" & fOSUserName

so that it is filtered just for the entries for that user.

Signature

Regards

Alex White MCDBA MCSE
http://www.intralan.co.uk

> Hi,
>
[quoted text clipped - 16 lines]
> projects). What is the best way to accomplish this? (sorry for the long
> post!)

Reply to this Message

Trauton - 24 May 2005 06:38 GMT

Thanks a million Alex. I appreciate your help!

> use the code below in a module, to get the logged in users name
>
[quoted text clipped - 35 lines]
> > projects). What is the best way to accomplish this? (sorry for the long
> > post!)

Reply to this Message