MS Access Multiuser - New to multiuser

Author

New to multiuser

Trauton

2005-05-24, 3:24 am

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!)

Alex White MCDBA MCSE

2005-05-24, 3:24 am

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.

--
Regards

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

"Trauton" <Trauton@discussions.microsoft.com> wrote in message
news:58635576-4056-4984-9451- B821D382FD6F@microso
ft.com...
> 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!)

Trauton

2005-05-24, 3:24 am

Thanks a million Alex. I appreciate your help!

"Alex White MCDBA MCSE" wrote:

>
> 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.
>
>
> --
> Regards
>
> Alex White MCDBA MCSE
> http://www.intralan.co.uk
>
> "Trauton" <Trauton@discussions.microsoft.com> wrote in message
> news:58635576-4056-4984-9451- B821D382FD6F@microso
ft.com...
>
>
>

Sponsored Links