473,806 Members | 2,371 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Allowing users to view only their own data

Ed
I am trying to create a access database that will allow a "user" to
login, and only view/change only the material they have entered. Also
allowing a administrator to view all the data, and create reports from
them. Any good ideas? I kinda of had an idea of creating a seperate
table with usernames and passwords then writing a visual basic and sql
combination to allow them only to view and edit their own data.

Feb 2 '06 #1
1 1816
Ed wrote:
I am trying to create a access database that will allow a "user" to
login, and only view/change only the material they have entered. Also
allowing a administrator to view all the data, and create reports from
them. Any good ideas? I kinda of had an idea of creating a seperate
table with usernames and passwords then writing a visual basic and sql
combination to allow them only to view and edit their own data.

I'd look at the SeqFaq for access. Using/modifying code found there you
should be able to do what you'd like.
Feb 2 '06 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
1609
by: Betty Harvey | last post by:
The next meeting of the XML Users Group will be held on Wednesday, April 21, 2004 at the American Geophysical Union (AGU) at 2000 Florida Avenue, N.W., Washington, DC 20009-1277. The meeting starts at 7:00 p.m. and usually last approximately 2 hours. If attending the meeting by Metro, get off the Dupont Circle stop and walk north to Florida Avenue...turn right. There is no cost associated with attending but if you are planning on...
5
4322
by: Simone | last post by:
Hello All. I would like some advice. What is the best way to make an Access database design not accessible? Like accessing tables, form design and etc. Is it a good idea to make a MDE file? What other options do I have? On more question should all users have their own front end? Thanks a lot.
4
2405
by: deko | last post by:
Is there any way to let users compose and run SQL from the Access interface? If I create a new query from the Database Window, select Design View and then View >> SQL View, I get a window from which I can compose and run SQL queries. What I'd like to do is let users have the ability to run SQL queries like this against imported tables. I was thinking I could open the imported table in a form and have a textbox in which SQL can be...
16
2518
by: Andy_Khosravi | last post by:
I'm in a bit of a pickle. My employer, a health insurance firm, had me design a small database to track benefit issues. The intended users were technical specialists and some managers (about 90 people, no more than 10 concurrent users at any one time) all of which had Access 97 loaded on their machines. Everything was going smoothly, and I delivered them their VBA application that does everything they initially wanted it to. However,...
7
2922
by: jsale | last post by:
I'm currently using ASP.NET with VS2003 and SQL Server 2003. The ASP.NET app i have made is running on IIS v6 and consists of a number of pages that allow the user to read information from the database into classes, which are used throughout the application. I have made class collections which, upon reading from the DB, create an instance of the class and store the DB values in there temporarily. My problem is that if user1 looks at...
2
2188
by: PB | last post by:
I need to enable users to download data in either an Excel file or an Access database (MDB file). The data they need exists in a SQL Server database: the XLS or MDB file does not actually exist at the time the users request it. My initial plan is that when users request their data, they will click a button or link indicating that they want their data in the respective file format. Then, on the server I want to execute a stored...
6
1970
by: google | last post by:
I have a few general questions. I am working on a new database to be used within my company. I would like to give a couple of people, particularly HR, the ability to add and delete Access users, and add/remove them to groups, so as people join and leave the company, they can be added/removed as database users at that time. However, I don't want them to have to do it through the standard Access users/groups interface, and I don't want...
1
1108
by: craig.buchinski | last post by:
Ok i have created a login, what i want to do is each time a user logs in, i want to direct them to their own web page and not a "community" web page. Any help would be great.
7
3080
by: CCHDGeek | last post by:
I have a subform that is searched according to a field value on the main form. The subform has mutiple pages and each page has a subform based off a query. Today when I logged into the main form, none of the subforms that in are Datasheet view are allowing data entry. In fact, none of the rows are even visible. All I can see is the column title row for each datasheet. What does this mean? Are my queries not setup correctly? Is it an...
0
9719
marktang
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...
0
10366
jinu1996
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...
0
10110
tracyyun
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...
1
7649
isladogs
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...
0
6877
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5546
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5678
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4329
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
2
3850
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.