Question About: A Table Of Users Who Have Relationships To Other Users??
Feb 21, 2006
Hi,
I have a table of users somthing like this:
User_ID
Name
Hobby
Favorite_Food
Blah
Blah
Blah
Users can be friends with one another and I need some way of logging this.
My 2 options (that i can see) are:
1) Putting a friends entry in the main user table then comma delimiting the User_ID's in the friend entry like so:
User_ID: 001
Name: John
Hobby: Frizbee
Favorite_Food: Cake
Friends: 002,004,010
2) Making a seperate table with multiple entries for each user like so:
User: 001
Friend 002
---
User: 001
Friend: 004
---
User: 001
Friend: 010
---
User: 002
Friend: 001
---
User: 004
Friend: 001
---
User: 010
Friend: 001
---
The database has to be handled by a web service and/or a web appliction making the comma delimited option occupy more server time breaking down the string into usable user_ID's.
But (and this is probably my actual problem) if i was to impliment my second idea, I'm not sure what I should make the tables primary key or the best way to relate it to the main user table.
My initial thought is to just have a, technicaly useless, ID be the primary key and impliment a one(User) to many(friends entries) relationship... but im a bit of an access n00b so thought i better come ask for some advice.
Thanks.
View Replies
ADVERTISEMENT
Aug 23, 2007
hi,
i have a raw data table built, may i know how to hide the table to not allow users to alter the raw data table?
I use the Tool > Startup option to hide everything but if the users are clever enough, they would able to make that available and try to alter the raw data table which i want to prevent and hope that's not gonna happen.
View 1 Replies
View Related
Mar 5, 2008
Hi all,
I have a table tblLineItem contains materials/line item records assign to different buyers. Each buyer/user needs to access the same table tlbLineItem and choose certain line items and works with them to create PO (purchase order) .
How do I lock the table while whoever access first then after that person finish it release the table to avoid each process of one buyer's items overlap with other buyers' line items.
And if the table is being used have a message box alert to inform the buyers, so they can wait?
My problem with this database is right now I placed a check box on each line item on the form that have the data source is the tblLineItem. Each buyer filters only their line items, check the box of the line items they wish to create PO at a time and click the button "Create PO". However, if buyer A uses the same form and check the boxes on his/her own line items, while coincidently buyer B also work on the same form then when they click "Create PO", their line items cross with each other!!
If you have suggestions, please advise/help!!
Thanks so much.
View 4 Replies
View Related
Jul 27, 2007
My search was snowballed with lot of results about dealing with split database, seeing who's online, etc. so I'm not sure if that is a good idea.
I want to make a table of Users because my users may need to put their name on some of reports, so I could use CurrentUser() to figure out who's who and put down their proper name after comparing the username via a query.
However, I'm not sure if it's possible for me to link the user table to the user groups of database to ensure that there's no ghosts or users that doesn't have a proper name to be placed on the reports or whatever. More of a validation, really.
Is that doable or maybe there's another way to do that?
Thanks!
View 2 Replies
View Related
Mar 2, 2015
Is there a way of creating a log to capture changes in a table by users?
In a current database that I'm taking over, there was a lot of records deleted from the main table and now I need to figure out what happened.
So, if I would be able to have a log that records all the actions taken by users, I could at least see who did what.
View 13 Replies
View Related
Jul 6, 2015
I have an Access database which has a linked table to a CSV file.Only one user can use this part of the database that links to the CSV - for other users we get the error 3051 - opened exclusively by another user. How can the csv file be a linked table with multiple users ? The query itself is set to no locks.
View 5 Replies
View Related
Apr 3, 2013
I have a form that I've created to allow users to do a ad-hoc query on data in a table. Most of the fields are setup as
Code:
Like [Forms]![Unusual Login Research]![CustomerName] & "*"
where I have a drop-down box with options for: >, <, >=, <= and between. I've tried a bunch of iterations of the same criteria and keep getting the error above. Just as a test, i was trying to at least get the between option to work with the following:
Code:
[Forms]![Unusual Login Research]![ScoreAtLoginCriteria]+" "+[Forms]![Unusual Login Research]![ScoreAtLogin1] And [Forms]![Unusual Login Research]![ScoreAtLogin2]
Where ScoreAtLoginCriteria is the drop-down, set to "between" and ScoreAtLogin1 and ScoreAtLogin2 are integers.
View 4 Replies
View Related
Jan 25, 2007
Basically I have a secured split database. Each user has a copy of the FE on their local drive and the BE is on the server. I have 2 main user groups: FinanceUsers and purchasingUsers
Both groups of users edit data directly in the invoice table ( believe me it was not my idea - I am slowly improving it - enforcing relational integrity and fixing the table and field names and creating forms).
When a Finance user edits data in the Invoice table and tries to close it they get a message asking if they wish to save the design changes if they have changed col widths or anything. They just click no and the table closes. (Is there any way to prevent this message coming up? They do not have modify design permission in any case.)
The main problem is that when a purchasing user edits data in the Invoice table a dialog pops up asking if they wish to save the table as a form, data access page or query. (They do not get the message box asking if they wish to save design changes at all)
If the user clicks cancel the window does not close. If they choose 'form' and type a name for the new form for instance it will not save it (presumable because they do not have 'Open Exclusive' permission). So they cannot close the Invoice table at all.
Both groups have the same permissions on the Invoice table: Read Definition, Read Data, Insert Data, Update Data, Delete Data.
The only difference between their permissions is that Finance users have 'Open Exclusive' permission on the database and Purchasing users do not. This is the same in the BE and FE. I would prefer that no-one had open-exclusive permission really.
It is really odd - It only happens with the tables. Any ideas what is causing it?
View 4 Replies
View Related
Nov 24, 2006
Hi,
I'm building a DB where I have multiple users. I would like to have all data in 1 table but only give access to records created by the individual user. Is this possible?
Alternatively, if each user has it's own table, how can I report on the sum of all tables.:confused:
Cheers,
Rene
View 5 Replies
View Related
Dec 31, 2013
I have a TABLE with the following data:
- EMPID
- LASTNAME
I have a form with the folliwing data:
- text box for user to enter EMPID, txtEMPID
- LASTNAME
I would like to create a button to initiate a query to do the following:
- once the user enters a EMPID in the form, it will search in the TABLE under the EMPID field...
- if the user enters an EMPID that is in the TABLE...display "Y"
- if the user enters an EMPID that is NOT in the table...display "N"
- a error message box needs to pop up if "Y" to alert the user that "the EMPID already exists and that duplicate entries are not allowed"
One of my main questions is how do I run a query based on the users input and search a table? would the following work in the query?
View 7 Replies
View Related
May 15, 2013
I want to create a form where by the user can select the fields he requires and the table is created.
Example: I have a table of subjects like maths, english, french, chemistry etc,
The user can choose what subjects are available in that particular school and therefore a table is created based on the chosen subjects.
Is there any way it can be done even with vba?
View 4 Replies
View Related
Apr 22, 2013
I am fairly new to Access and I would like to create a form to allow users to create their own query. I would like to allow users to select multiple fields (perhaps with checkboxes?) from all possible fields in a table to return either all data from that field or narrow their search by inputting certain criteria or choosing from a drop down into a text box. Is this possible in Access and any detailed specifics on how to achieve this?
View 3 Replies
View Related
May 9, 2005
All,
I have database with user level security that works fine, but I have asked to place this database onto our secured network which means multiple users could have it open at any given time.
How can I setup this database to allow multiple users? I am very, very green at Access. Please don't say split the database...please! :eek:
debo
View 3 Replies
View Related
May 16, 2005
If I place the program on a server, how can I tell which users are using the program? Also, is it possible for me to kick someone off the program without going to their computer?
View 1 Replies
View Related
May 26, 2005
Please refresh my memory on how i can set up a database having about 10 users possibly making entrie at the same time. I am trying to make a small database for containing employee surveys.
View 3 Replies
View Related
Jun 23, 2005
When the application starts up I need to control the user of the system, I will have to accounts which I will define one will act as an admin and the second will act as a user the differences is that the user acts is “read only” cannot add, delete and edit.
I would appreciate your comments and ideas regarding this part?
Thanks.
View 4 Replies
View Related
Jun 29, 2005
I want to create and mde file in order for the users not to change any thing on my design, I will be uploading the file into my server and give them the path to access:
1.3 people (max) will be accessing the database, is that a problem or not?
2. I cant create an mde file I have to convert my db but I have read as well if I covert it to 2000 people who have lower or higher version wont be able to access it, how can I fix that?
Thanks.
View 6 Replies
View Related
Jun 30, 2005
I think I am missing sth here, after I set my new group then I create my new user, then what! How can I specify which user to login with? Will the user be promoted for a username and a password?
View 3 Replies
View Related
Aug 18, 2005
Hi,
I am trying to create a database that MULTIPLE users can log on and view the data.
Eg. I have a client list and have employed 5 ppl to call each one of my clients and confirm their details.
I have imported all the details into a table and just want users to simulataneously log on and click a "next record" button that will bring up the next "new" record with the details displayed on a form. of course the database will flag this record as "old" and which user called them.
Main thing is 5+ computers can connect to this database simultaneously and no record gets displayed more than once.
Can MS Access do this?
if it cant, would a vb front end located on each computer help?
Thanks for any suggestions!
Jon Cheah
View 1 Replies
View Related
Oct 6, 2005
What the user front-ends required in order to run/view my DAPs that put on the web?
Do they really need to have Access installed (any versions is OK?) ....
or anything else?
Thanks
View 1 Replies
View Related
Mar 8, 2006
What is the simplest way to track who is making a change to a record and when they made the change? I've tried searching for help but I'm not quite grasping how to do this. Any ideas?
View 13 Replies
View Related
Feb 19, 2007
Hey guys,
I'm curious to know if it is possible to kick users off your db so you can make changes. Is it possible to send them a message to save and close within 30 seconds, or just send them a messgae. I guess I want to know whether I can
1) Kick a user off
2) Send them a message
3) Send a user a message and then kick them off
View 2 Replies
View Related
Mar 12, 2007
i have a database which is shared on the network. i have one problem right one. when one is using the database, another person cannot access it. what can i do to enable multer user access it at the same time.
Any help will be highly appreciated.
View 9 Replies
View Related
Aug 17, 2007
Hi
Just a quick question
Is there any way that I can view which users are logged onto the database?
Thanks
View 6 Replies
View Related
Aug 23, 2007
Hello
Has anyone ever made a code to enable users to chat to each other in real time to help with transfering calls etc within the organisation?
Many thanks
Paul S
View 3 Replies
View Related
Feb 12, 2008
This is probably a really easy thing to do but I need to set up users and passwords to access a database that will contain sensitive information so cannot be accessible to everyone.
Can someone please tell me an easy step-by-step way on how to do this, with multiple users allowed to add and edit information (but not the workings of tables, queries etc)?
I am pretty much self taught so nothing too technical if possible!!
Also, the user's name needs to be input into an "Entered By" field in a form automatically depending on who has logged in when a new record is created.
Thanks in advance for your help with this.
Emma
View 5 Replies
View Related