restricting access to records based on user identity

\Shannan Casteel via AccessMonster.com\

I have a database for warranty claims. There is one form based on one large
table. The first object is a combo box asking for dealer number. When that
field is updated the dealers name, address, and phone number appears in some
text boxes. When the dealer selects their dealer number I would like a
password field or dialog box to appear. If the dealer enters the correct
password then they will be able to see the warranty claims that pertain to
them and no one else. If the dealer enters the wrong password a simple
dialog box should be displayed saying incorrect password with an OK button.

I like this method, and am trying to get it to work, but if anyone has a
simpler idea that would be great too.

Thanks for any help,

Shannan Casteel

--
Message posted via http://www.accessmonster.com

Nov 13 '05 #1

Subscribe Reply

2185

lesperancer

so, what's not working ?

Nov 13 '05 #2

Barry Edmund Wright

Hi Shannan,

This anwer assumes you have security on your database, else you are not
going to stop them from seeing other dealer claims anyway.

I would have them logon using their dealer ID number
Logon
Name: 10
Password: ******

Change the combo box to a text field (lngDealerNumbe r) and in the on_open
event of the form put in:
lngDealerNumber = CurrentUser
the next line in the on_open form event should be your Update Event to
populate your form.

Regards,
Barry
""Shannan Casteel via AccessMonster.c om"" <fo***@AccessMo nster.com> wrote in
message news:50******** ***@AccessMonst er.com...
I have a database for warranty claims. There is one form based on one large
table. The first object is a combo box asking for dealer number. When that
field is updated the dealers name, address, and phone number appears in some
text boxes. When the dealer selects their dealer number I would like a
password field or dialog box to appear. If the dealer enters the correct
password then they will be able to see the warranty claims that pertain to
them and no one else. If the dealer enters the wrong password a simple
dialog box should be displayed saying incorrect password with an OK button.

I like this method, and am trying to get it to work, but if anyone has a
simpler idea that would be great too.

Thanks for any help,

Shannan Casteel

--
Message posted via http://www.accessmonster.com

Nov 13 '05 #3

\Shannan Casteel via AccessMonster.com\

Thanks for your thoughts on this.

Ok, I got the text box to display the user, but how do I use this to restrict
what records that user sees. Do I have a table design issue? I have 60
something dealers, surely I don't have to create 60 tables and load each
table and respective form for each user.

I guess what I'm asking for is some more code to use so that when the text
box displays USER #1 then only the claims that USER #1 has submitted would be
visible or accessable.

Thanks for your time.

Shannan

--
Message posted via http://www.accessmonster.com

Nov 13 '05 #4

\Shannan Casteel via AccessMonster.com\

By the Way,

I haven't set up securtiy.....Ye t.

--
Message posted via http://www.accessmonster.com

Nov 13 '05 #5

\Shannan Casteel via AccessMonster.com\

Also, the number of dealers is constantly changing. The dealer # comes from
a linked excel spreadsheet.

--
Message posted via http://www.accessmonster.com

Nov 13 '05 #6

Barry Edmund Wright

You need security!

""Shannan Casteel via AccessMonster.c om"" <fo***@AccessMo nster.com> wrote in
message news:50******** ***@AccessMonst er.com...
By the Way,

I haven't set up securtiy.....Ye t.

--
Message posted via http://www.accessmonster.com

Nov 13 '05 #7

Similar topics

1813

restricting records a user can update

by: Finalstryke | last post by:

Hi, I run a hobby-based hall of fame. At the moment people send their stats to me and I manually update the database, run the queries, and convert the results to .pdf which is then put online. I'm in the process of automating the procedure by changing to a .php website with the Hall of Fame powered by a mysql database, but what I'm trying to figure out is if each user has a unique username and password, is it possible for the database...

MySQL Database

2330

Restricting Users to Certain Data in DB by filtering a field

by: MX1 | last post by:

Here's an interesting one. I have a database that has user level security invoked. The design is normalized and I have one field in particular called Rep ID. Any thoughts on how I can allow all the reps to have read-only access to the DB BUT somehow restrict each REP to only see data or records that have his or her REP ID associated with them. Basically, there is a table of clients and a bunch of other tables, income, sales, etc. that I...

Microsoft Access / VBA

7645

Accessing Access mdb via ODBC - how to return autonumber

by: Steven Taylor | last post by:

Hope someone can help. This is half an Access question. The half I'm using is Access Xp as a backend data file. I'm using ODBC to connect to the data file. All commands are via SQL type statements (SELECT, UPDATE & INSERT INTO). (I'm using/trialling Realbasic as a frontend). After inserting a record (row) into a table using "INSERT INTO ...." what is the easiest way to obtain the value of a counter field for the record just...

Microsoft Access / VBA

1654

Restricting A97 form to editing only?

by: MLH | last post by:

I have a form based on a table that is opened this way... DoCmd.OpenForm "frmAdminSetupInfo", , , , A_EDIT It was my intention that the form allow the user to edit table data - not add records. The table contains a single record only. I don't want more records be added to the table. When frmAdminSetupInfo opens, all one has to do to go to a newrec (empty new record) is press PGDN or hold down

Microsoft Access / VBA

9421

Urgent help::: ASP.Net Access is denied

by: Sachin_M | last post by:

Hi Friends, I want to develop a web based app where it will talk to a dll (which retrieves real time data from a controller) I've added a com dll reference to my project, the code is something like this: GEOAuto.OPCServer OPCserver = new GEOAuto.GEServerClass(); GEOAuto.OPCGroup OPCGroup; System.Object myNode = new System.Object(); object myval;

C# / C Sharp

3047

Role-based security: Access the role of current user

by: Jesper Stocholm | last post by:

I have implemented role-based security within my ASP.Net application. However, it seems the role is not passed to the authentication ticket I create. I want to use it to display/hide some content based on the user's role. I wrote this to do it: if (HttpContext.Current.User.Identity.IsAuthenticated) { plLoggedIn.Visible = true;

ASP.NET

4898

Win2003 Server - Access to the path is denied

by: Jody Gelowitz | last post by:

We are having an issue in that when trying to read a file that is on Server2 from Server1 (through our ASP.NET project), we receive the error: Access to the path "\\Server2\MyShare\MyFile.tif" is denied. Here is the server setup that we have: Dev - Development Computer on WinXP Pro SP2 (IIS5), VS2003 developing under .NET Framework 1.1 Server1 - Web Server on Win2003 Server (IIS6) Server2 - File Server on Win2003 Server

ASP.NET

2496

SQL or Access DB

by: DaveG | last post by:

Hi all I am planning on writing a stock and accounts program for the family business, I understand this is likely to take close to 2 years to accomplish. The stock is likely to run into over a thousand items and the accounting side will be used for hopefully many years so the entries are likely to be vast. The delema is what is best to use ase the DB engine, Access I have as part of Office 2002 or should I really be looking at SQL...

Visual Basic .NET

2147

Windows Integrated Security - Restricting Users Without Groups

by: Mr Newbie | last post by:

Hi, Im in a situation where I need to restrict users, but I dont have access or wont be allowed access to manage groups in the domain. How can I restrict access is this case ? -- Best Regards

ASP.NET

9639

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

10311

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

10146

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

10080

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

9942

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

8967

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

7492

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

4043

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

3639

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP