User permissions to view data in form

S

Sierras

Hello,

I'm trying to create a database where users can input issues. But I
would like that they only have access to their own issues. For
example, if there are 20 issues in the database, and user 1 created 3
of them, I would like that the form (and table) only allow for that
user to see those 3 issues. While the admin would be able to see all
of them.

Is this possible?? Thanks
 
P

prabha

Hi,

If you are using User Level Security in Microsoft Access why not create a
query that pulls records where the User Name in your table equals
CurrentUser(). Example:

Field: OrderID UserName
Criteria: CurrentUser()

Then base on Form on that query.

I hope this helps! If you have additional questions on this topic, please
respond back to this posting.


Regards,

Eric Butts
Microsoft Access Support

"Microsoft Security Announcement: Have you installed the patch for
Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises
you to review the information at the following link regarding Microsoft
Security Bulletin MS03-026
<http://www.microsoft.com/security/security_bulletins/ms03-026.asp> and/or
to visit Windows Update at <http://windowsupdate.microsoft.com/> to install
the patch. Running the SCAN program from the Windows Update site will help
to insure you are current with all security patches, not just MS03-026."



--------------------
| From: Sierras <[email protected]>
| Newsgroups: microsoft.public.access.forms
| Subject: User permissions to view data in form
| Message-ID: <[email protected]>
| X-Newsreader: Forte Agent 1.93/32.576 English (American)
| MIME-Version: 1.0
| Content-Type: text/plain; charset=us-ascii
| Content-Transfer-Encoding: 7bit
| Lines: 10
| Date: Fri, 06 Feb 2004 07:57:52 GMT
| NNTP-Posting-Host: 151.201.221.82
| X-Complaints-To: (e-mail address removed)
| X-Trace: nwrdny03.gnilink.net 1076054272 151.201.221.82 (Fri, 06 Feb 2004
02:57:52 EST)
| NNTP-Posting-Date: Fri, 06 Feb 2004 02:57:52 EST
| Path:
cpmsftngxa07.phx.gbl!cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.su
l.t-online.de!t-online.de!news-lei1.dfn.de!news-fra1.dfn.de!news2.telebyte.n
l!lightspeed.eweka.nl!news2.euro.net!newshosting.com!nx02.iad01.newshosting.
com!diablo.voicenet.com!cycny01.gnilink.net!cyclone1.gnilink.net!spamkiller2
.gnilink.net!nwrdny03.gnilink.net.POSTED!e0704694!not-for-mail
| Xref: cpmsftngxa07.phx.gbl microsoft.public.access.forms:253973
| X-Tomcat-NG: microsoft.public.access.forms
|
| Hello,
|
| I'm trying to create a database where users can input issues. But I
| would like that they only have access to their own issues. For
| example, if there are 20 issues in the database, and user 1 created 3
| of them, I would like that the form (and table) only allow for that
| user to see those 3 issues. While the admin would be able to see all
| of them.
|
| Is this possible?? Thanks
|
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top