Is it possible to have 2 or more users adding records into the same table at the same time? They would not be editing, only data entry.
I am wondering if this would cause a problem for the auto numbering for the ID field.
I wan to create a table with a date / time starting at a specific time and then added a number of records with each record being a minute later than the first.
The starting point could be hard coded or by user entry and the loop would run for a certain number of times .....
Any ideas on how to do it ..... poss a macro :confused:
I run a school library database (Access 2003) and want to set up a password logon system so that different users can get at different parts of the program - e.g. Administrator (everything), Librarian (can add and delete records but not change the database design), Student (can only access certain areas, read only).
I've tried using the security wizard to set this up, which seems OK until you then open the database again. I would expect to then get some sort of log-on screen next time I open the database, but instead it opens normally, but then won't let me do anything because I "don't have permission". I had to restore a back-up copy.
I must be missing something obvious here. Is there a place to look for instructions? Couldn't find anything useful in the help screens.
Richard
Hi everyone,
This is in regards to user security. I'm a relatively new user to Access (and this forum). My company uses Access 2000 and I'm taking over a database thats used by several departments at my company. This database contains sensitive information so I put user security on it using the wizard. Due to the nature of the database, a particular user group needs to have the ability to create new tables. The problem is this: No matter what I do with the user group security settings, I cannot prevent other user groups from creating new tables. Is there a way to prevent certain users from adding a table?
:confused:
Your help is appreciated
so i'm using MS Access security features, .mdw file and all that jazz. i'd like to market my program, but i don't want to have to add/delete users and change/add/delete permissions for every new/existing user. is there any way around this via an unbound form in vba, ie, something like "New User Name: _______" "New User Password: _______" "New User Permissions Group: (dropdown)"? is this possible, or MUST you go through the security page?
thanks
Hello everyone.
I am looking for a little help getting a database created in access 2000 to open in access 2003. The creater of the database put security on it and I have the security doc. However, I do not know how to give permission to open the database in 2003.
Any help is appreciated!
I have created a database for 2/3 users (will progress to more once the system has been smoothed over) who will have the db.file open from 9-5 and will be consistently adding and changing data within 2/3 forms. Most of the time but not always a message comes up saying,
"You do not have exclusive access to this database at this time. Any changes you make may not be allowed to be saved later"
I can understand that it can create data corruption if multiple users are allowed to edit and modify the same data at the same time but surely a database can't be that limited. I thought that splitting the database into a front end on a local server and then a back end on my computer would solve the problem but everyone who is using the front-end still experiences the same problem.
How to be able to overcome issues with multiple users access the same forms and tables? Even when another user is editing one form and another is editing a different form the message will still appear.
Is there any option to kick out users after a certain time of idle.
Say, a user login my ms access and don't logout from database and he don't do anything in ms access. I want automatically logout from ms access after a certain time he is idle.
I'm using ms access 2007.
Hi, I created a database where everybody should insert his holiday plans and absence of business. the Database is linked and opens automatically the form when you click on the link on the pdf. But know it is not possible anymore that more than one person opens the file to insert the data. The mistake is: Could not lock file!
What do I have to do that more people can use the database at the same time (not only read-only) Thank you for the help
I have several forms will be filled out on a daily basis by 50 different people. Does Access have a way of allowing multiple users to fill out the forms at the same time and still track the data? Or is it like Excel and can only be viewed as "Read-Only" once opened by someone else?
View 5 Replies View RelatedI have an access database and I plan on splitting it so the FE will be on each users workstation and the backend will be in a folder on the server. But is there anything else I need to do to allow for the possibility of multiple users using the database and changing info at the same time?
View 4 Replies View RelatedHello again,
I think my subject heading explains it. How would you add or subtract two short time formatted values and produce a short time value? Also, how would you change a short time value into number minutes. (i.e. 5:30 into 330) Thanks!
G
Twice a year, a database of mine is accessed and put too use by various staff within a time range of 1 week. the database is on a shared drive and in a location which can be accessed by all.
The staff access the database from different workstations and in some instances at the same time.
This has only led to issues in the database being copied and then confusing staff on what database to click on thus i have 2 databases which i then have to sift through and copy/paste into the correct one.
I want to know the best way i can:
1) Prevent multiple users accessing the database at a time.
2) making a copy of the original and typing into a separate database.
I have a button which runs a list of queries that take roughly 10 seconds to run, when another user clicks the button while the other one is running it gives and error message 3405, File already in use.
View 1 Replies View RelatedHi,
If I have a time like 22:00 and I want to add lets say 300 minutes to it; so it now shows 03:00 how do I do this? I can do it in Excel alright with the TIME function but cannot find a similar feature in Access
Liam
I have a report that adds time for as many as six people. This isssue is when the time goes over 24 hours in total it drops the hours. The field(s) is formated in "short time" format.
Can anyone help resolve this???:confused:
Hi,
ive searched the forums for this but cant find anywhere.
how can i add one hour onto a time stamp please.
many thanks:confused:
hi
i've got a time duration field that is formatted as a string. I want to be able to sum up the durations as i group the records in different ways. I can't convert it to time, because it changes the durations to a time value, not duration example: 12:29pm instead of 0:0:21
is there any possible way to work with time durations??
thanks
*j
I am somewhat lost and would really appreciate your help!
I am using a database to classify newspaper articles. There are several users - and they need to be trained to the classification rules.
Waht I would like to do have is a way to let different users classify the same sources. However, the "trainee-user" should not be able to see the data already in the database. Also I would like to flag all "trainee-user" records to compare them to the original results.
My questions are thus:
How Do I hide records from a user and yet allow him to use the database (and see the stuff he entered himself)
How can I save information on a user in a table?
Thanks a lot in advance!!
BM.
About six months ago I created a database for tracking customer calls and comments. I replicated this database because I wanted to be able to make design changes without effecting the users ability to add records. I have no security set up for the database except for startup options. I am having an issue with users being locked from adding records once in awhile. The dialog box says "Could not update; currently locked by user 'Admin' on machine '***'". The more I read this the more I am thinking that they are getting assigned the same record ID when they go to make an entry. Although, if the users are patient and wait a few minutes they are able to finish adding the record without deleting it and starting over. There are now 22 people utilizing the database and about 17 of them are using it consistently. Any insight on this would be appreciated.
View 1 Replies View RelatedHi
Apologies first if there is an easy answer to this post as I'm new to Access.
I have a notes box on a form that users update with the latest progress of work done. At the end of each progress I would like Access to automatically add the date, time and user's network id so that I can track who did what and when.
Is there an easy way to code this?
My table, TblTYPE, will contain two field.
TYPE
DURATION
There will only be 7 records in this table:
FUS, 30 minutes
POS, 30 minutes
PRE, 30 minutes
NOV, 90 minutes
FUL, 90 minutes
ANN, 90 minutes
NPB, 60 minutes
1st question: How do I enter only minutes in the table for field 2?
------
I want the following to happen.
The end-user enters the start time and the type. As soon as the type is entered, field three calculates an end-time based on the start time and the type. When the type is entered, the minutes listed in field two of the type table are added to the start time (giving you an end time).
Can anyone help me?
1.) How to properly format the minutes in the original table.
2.) How to add the minutes to the original time in a query.
Thanks!
Scott
Can you help we have a data with a list of jobs that scores points, I need to build a query or scirpt that will add 5 points every 30 day fro the date the job was submitted this will help old jobs come the top of the list.
View 1 Replies View RelatedHi all,
I’m adding a new function to our Costumer Relations Management system – Time management. Or maybe “time registration” is a better definition for it. The idea is that our consultants can add their hours into our CRM, either from the “Project”, “Tasks” or “Costumer” part of the CRM. Note: This is a tool to keep track of hours spent on a project, not a planning tool.
I’ve made the input-form for the records (Date, ClockStart, ClockStop, TimeSpent, InvoiceHours, etc.). But now I’m basically without a clue on where to start – I want to make a function almost like the calendar in Outlook, where the consultants can input what they’ve been working on, say between 13:00 and 14:00.
It doesn’t have to be fancy graphically, but functional and give a good overview.
Any ideas?
I want to calculate total hours and mins by adding a load of times (in time format) on a report. I've got the total number of minutes and converted this to hours : [txtmins]/60
Now I want to get the remaining minutes by using : [totalmins] - ([totalhours]*60)
However, how do I round DOWN the [totalhours] before it goes into the above sum. I can round it, but it always seems to round up.
If anyone has an easier solution let me know
Recall
I am trying to add hours entered in a short time format. For example 08:15 or 02:55. I also would like it to give a total number of hours beyond 23:00. Here is a table with a Name Column and Hours Column
Name Hours
BETTER,HEATHER 8:00
BETTER,HEATHER 8:00
BETTER,HEATHER 5:41
BETTER,HEATHER 2:35
BETTER,HEATHER 1:15
WILLIAMS,R 2:30
WILLIAMS,R 0:45
WILLIAMS,R 11:20
WILLIAMS,R 8:25
WILLIAMS,R 8:15
WILLIAMS,R 10:20
How do I
A) write a query to add up the hours. I believe Heather would total 25:31 Hours.
B) Show this same total in a report? In my report I had a Name Footer which showed "=Sum([hours])". Will this work once the query is right or will I use the "=Sum([totaltime])"?
Also, is it possible for you to respond in a SQL statement so that I can copy? Thanks.