multi user

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Herr Li - 20 Jan 2006 06:12 GMT

Dear friends,

I have a very simple access database:
It only has three column: sales person ID, invoice number, invoice amount
What I want to do is:
We have 5 sales person, and they have their own unique ID, and when they
open the database, they can use their own ID and password to open the
database file, and enter their own invoice number and the invoice amount.

Could anyone tell me how I can do this?

Thanks a lot in advance.

Li

Reply to this Message

Larry Linson - 20 Jan 2006 22:48 GMT

> I have a very simple access database:
> It only has three column: sales person ID, invoice
[quoted text clipped - 7 lines]
>
> Could anyone tell me how I can do this?

What, specifically, did you want to know?

You can easily do this with Access, but it is not clear whether you want
each sales person to be able to see only their own invoices, or all, or what
you expect to do with the information once you have collected it. (It would,
clearly, make little sense to collect information that you don't plan to
use.)

You could use Access' user and group level security to enforce opening the
database with a password and user ID, if security is an issue. If it is just
a matter of identifying the record, you may not need to go to the effort of
implementing Access user and group level security.

If you are conversant in Access' programming language, Visual Basic for
Applications, you could also use the Windows login ID (information about
doing this can be found at http://www.mvps.org/access/api/api0008.htm).

Larry Linson
Microsoft Access MVP

Reply to this Message