Fe/Be Update For Permissions Took Two Days
Jan 18, 2007
This is not a question, but a short informational about a phenomenon I experienced at work. We had split a db and put the fe on each user's computer and the be on the server. After updating the permissions for the group, we were still getting "exclusive" issues (even though we knew we had the permissions set correctly). After a call to the main IT division, we were told just to wait a few days and the issue would resolve itself because it would take some time for the network to send the message to all the controlling machines, which would then notify their nodes and set the new permissions. Since the machines "talk" to each other constantly sharing many updates and such - apparently it can take a few days to get the "word" out to all the computers. Well, long story short, that seemed to be exactly what happened, and after two days - all of the systems were up and running and sharing without a glitch. Has anyone ever experienced something like that? I just found it to be a bit strange.
View Replies
ADVERTISEMENT
Aug 13, 2007
Can anyone tell me what the ideal NTFS persmissions should be for users who are only inputting data to an Access database?
Would Read, Write, & Execute on the networked folder where the BE resides be enough for the users to update the database?
Thanks!
Michael
View 2 Replies
View Related
Sep 11, 2014
I have a form called subfrm_vactions
rowsource is a query called qryVacations
the query should calculated two things
1 - the difference between start_vac and End_vac in days to calculate the vacation period and put the value in field called Period (working well)
2-the work days which the period between the last day in Previous record (End_Vac) and the (Start_Vac) in the next record (didn't work)
the result is the difference between (End_Vac) and (Start_Vac) in the same record which i don't want
simply i want to calculate the work days.
View 5 Replies
View Related
Jan 24, 2014
I have to count the number of days each week (7 days) that a person has worked - simple enough.
But - what if they come off the job within the week?
I have been using the DateDiff function which is fine.
In the database they have a Mobdate and a DeMobDate but if the DeMobDate falls within the week the whole thing falls apart?
View 2 Replies
View Related
Dec 14, 2004
Hello everyone,
I have problem with my code here. I am using this code to determine if the LogDate with a weekday of Sunday can be declare as Sunday Work or Regular Work. The 1st week of my entry can determine if the LogDate is Sunday then compute if it reaches a 7 days working, if he is absent even 1 (one) day in his previous working days within the week. His Sunday LogDate is considered as Regular Days instead of Sunday Work. Can anyone tell me what is wrong in this code?
The problem here is the computation of 7 days after 1 week. There should be a 7 days computation every week per month in able to declare Sunday Work or Regular Work. I tried this code but it did not work on 2nd week, 3rd week and 4th week of the month.
How come on 2nd week, Sunday (LogDate) is not considered as Sunday Work even he completed the 7 days (working days) per week? I need help on this ASAP Thanks
Tim
Below is the code i'm using for defining Regular days and Sunday Working Days:
Private Sub LogDate_AfterUpdate()
Dim rst As DAO.Recordset, rs As DAO.Recordset
Dim db As DAO.Database
Dim dteToday As Date, dtePrior As Date
Dim i As Integer
dteToday = LogDate
dtePrior = DateAdd("d", -6, dteToday)
Set db = CurrentDb
Set rst = db.OpenRecordset("SELECT [HolidayDate] FROM tblHolidays", dbOpenSnapshot)
rst.FindFirst "[HolidayDate] = #" & dteToday & "#"
'See if the date entered is a holiday
If rst.NoMatch Then
Holiday.Value = 0
Else
Holiday.Value = 1
End If
If Weekday(dteToday) = vbSunday Then 'If dated entered is a Sunday determine if
Dim strSQL As String 'it will be a regular day or a Sunday
strSQL = "SELECT [LogDate] "
strSQL = strSQL & "FROM tblLog "
strSQL = strSQL & "WHERE [LogDate] >= #" & dtePrior & "#"
strSQL = strSQL & " AND [LogDate] <= #" & dteToday & "#"
'Create a recordset of records from date entered and 7 days prior
Set rs = db.OpenRecordset(strSQL, dbOpenSnapshot)
rs.MoveLast
i = rs.RecordCount 'Count the number of days between the two dates
If i = 7 Then 'If there are seven days then it is a Sunday
Sunday.Value = 1
Else
Sunday.Value = 0 'If less than 7 days then it is a regular day
End If
Else
Sunday.Value = 0
End If
DayofWeek.Value = Format(dteToday, "dddd")
End Sub
View 1 Replies
View Related
Jun 14, 2013
Is there a way i can convert the weekend days into working days for example.
5/4/13 1:30 PM is on saturday what function can I use to make this day read 5/6/13 8:00 Am which is monday. Same thing for holidays.
View 1 Replies
View Related
Apr 14, 2014
I have a form where a start date is inputted (Inputfrm , StartDate) and a form where the end date of the process is recorded (Inspectionfrm , EndDate) and these both record in the table InputTbl as StartDate and EndDate respectively.
I have created a union query which shows a list of all the dates where there is work recorded (WorkingDatesQry and the column of list of unique dates is "WorkingDate"), and as we run a highly varied schedule depending on time of the year and order numbers I cannot just use a query which says Monday-Friday or Tuesday - Saturday.What I am trying to do is to find the number of days between StartDate and EndDate where there is a date recorded in the WorkingDates query.
View 1 Replies
View Related
Apr 3, 2013
Client has asked me to create a report showing summary of monthly sales by day. That was easy. I created a query for the month the user selected and then summarized and group the data by day. Client like the result but would like to see zeros on the report for non sales days. Non sales days are days like holidays and there are no sales.
I am thinking of creating an table with 31 days of zero values and then join the two tables in a query? Or, should I create a temporary table with code and then merge the two tables which the existing query which I can then use for the report?
View 4 Replies
View Related
Dec 4, 2006
I have a query and I need the records to display 3 working days before the 15 working day deadline.
I used the following in the criteria box below the received date field and it doesn't pull the correct number of workdays, it's pulling calendar days instead.
<=DateAdd("w",-12,Date())
Can anyone help, thanks for your time!!!
View 8 Replies
View Related
Dec 4, 2006
I have a query and I need the records to display 3 working days before the 15 working day deadline.
I used the following in the criteria box below the received date field and it doesn't pull the correct number of workdays, it's pulling calendar days instead.
<=DateAdd("w",-12,Date())
Can anyone help, thanks for your time!!!
View 6 Replies
View Related
Dec 26, 2006
I rent out a property , on the rental statement I have a field [Datepaid], [RentpaidFrom] and [rentpaidTo]. I would to have a field that can calculate the rent that is paid to show if the rent is in arrears or in Advance. I guess the code would be something like (datediff ???? etc) but i have no idea what it should be. the calculation should appear on the query as i.e.2 days in arrears or 12 days in advance etc
your help would be much appreciated
merry christmas to you all
Jabez
View 4 Replies
View Related
Mar 14, 2006
Dear All,
I'm new to VBA coding. A code below is copied from a friend of mine and I can't make it work. How to call up this function in my form. In my form I have 3 text boxes (StartDate, EndDate and NumOfWorkDays). My form is based on a table.
Please anyone who would help me on this, kindly give me the step by step procedure as I am really novice. Thanks in advance.
'*********** Code Start **************
Public Function WorkingDays(StartDate As Date, EndDate As Date) As Integer
On Error GoTo Err_WorkingDays
Dim intCount As Integer
StartDate = StartDate + 1
'If you want to count the day of StartDate as the 1st day
'Comment out the line above
intCount = 0
Do While StartDate <= EndDate
'Make the above < and not <= to not count the EndDate
Select Case WeekDay(StartDate)
Case Is = 1, 7
intCount = intCount
Case Is = 2, 3, 4, 5, 6
intCount = intCount + 1
End Select
StartDate = StartDate + 1
Loop
WorkingDays = intCount
Exit_WorkingDays:
Exit Function
Err_WorkingDays:
Select Case Err
Case Else
MsgBox Err.Description
Resume Exit_WorkingDays
End Select
End Function
'xxxxxxxxxxxxxxxxxxxxxxxx
Can someone please direct me to the right path.
Your help is highly appreciated.
qwerty70
View 1 Replies
View Related
Jun 11, 2006
I'm changong computers and at prestne (for a few days) I am using a borrowed computer. When I edit any of my db's I now get a message telling me that I haven't got permission do carry out what I am doing & the permissions will be erased (can't remember exact message cause I'm on another computer). The edits I have made work ok but I really don't know anything about permissions:confused: It's something I have not been bothered with because this is the first time I've changed computers with all my db's. I use acess 2003. The computer I'm seeing the mesages on is using the version of jet that came with it, my old one had an updated version of Jet (probably not the latest though). Any suggestions?
View 2 Replies
View Related
Oct 12, 2006
Hi - I wonder if anyone can help. In my haste today I ran the security wizard on an Access DB and I've locked myself out. Using Win XP home and Access 2003. Now when I try to open the DN it tells me I don't have the necessary permissions. I've hunted through the forum and there seems to be tons of postings on this, and I have tried creating a new .mdw file etc, but just can't get into it. Can anyone help me please in giving the exact steps I need to take to unsecure the DB again, as there is dozens of manhours work in it, and I desparately need to get it opened again. Thanks.
View 2 Replies
View Related
Jul 22, 2005
Hi,
I have secured a DB and everything is tickety boo except for the fact that I want to be able to administer permissions from the FE (MDE) and the modify permissions button that i have put on a custom toolbar is greyed out when I log in?
I have full admin rights on my group and own all the objects and Access lets me assign all the permissions if I enable the shift bypass and enter the development MDB that way but that's quite a bit of hassle if I want to just change a permission or two.
Can anyone tell me why it won't let me change them?
Thanks, Tom
View 1 Replies
View Related
Aug 12, 2005
Is there a way in which to assign user permissions to vba code?
I have some command buttons which run vba code but i only want to allow certain users to use these.
View 7 Replies
View Related
Feb 28, 2005
Hi, I have just made my maiden voyage on the good ship "Security Wizard" and the water has been a little rough but as yet I still have my sea-legs intact!
Slight problem though... I want users to be able to add data to a table but not to be able to view the whole table if they try and open it in the database window. Now I know reasonable measures would just hide the DB window but I have the threat of Data Protection Auditors looming over me becuase management "forgot" to tell me security was required and it has already been breached before I used the wizard.
Anyway, I did some research on here and I found a method whereby I can set the table so only I have permission to view/add data, then I can get users to add data via a query with permissions set to Owners.
I'm really hoping that someone will come to my rescue and tell me that there's a much easier way than that...
Please....
Anyone....
Thanks, Tom.
View 1 Replies
View Related
Oct 30, 2004
Ok so my program is nearly complete...
Now I want to add permissions. So far I've gone through the very confusing security wizard and added myself and my boss to the list, but I have no idea what a workgroup is or anything. Also, how do I do permissions, like give myself full permissions, my boss almost full permissions, the secretary access to only certain forms and reports, etc.
And is there any easy way to log when someone logs in and out and what they did, etc.?
Thanks,
-Jason
View 4 Replies
View Related
Nov 9, 2005
My access DB is split into a front and back end - the application runs fine as an MDB file for all user groups.
If I then generate an application MDE file - I get the following error :
'You don't have the necessary permissions to use the 'MSysModules2' object. Have your system administrator or the person who created this object establish the appropriate permissions for you.'
(If I log in (as the same user) to the MDB version of the file - no error displays....????)
Why is this happening?
Ahy ideas would be gratefully received as this is the only thing stopping me from going live with the MDE. app.
Regards
View 8 Replies
View Related
Jun 12, 2006
We use an Oracle base software called Trapeze and Microsoft Access sometime used as a front hand to access the Trapeze oracle tables.
Since a user has to be created in Oracle, with update, delete, read, write, append rights, for Trapeze to work correctly
Is there a way for me (, even though the user has update, delete, read, write and append rights via oracle) to limit them to "read" only on the table and not update when they access the database through MS Access to create raports? I would like to allow them to create reports by linking to Oracle tables, but I don't want them to be able to update or delete or change the data in those tables.
They only way I want them to change the data has to be through the Trapeze GUI front hand application.
Any suggestions is greatly appreciated.
Thank you.
View 2 Replies
View Related
Oct 19, 2006
I have copied a work database onto my flash drive and then onto my laptop to do some work in it.
Now I can not open the database because it has the error message.
You do not have the necessary permissions to use the database etc...
I have copied the Application file, the Data file and the Workgroup information file and the only one I can open is Workgroup information file. I have tried holding the shift key down as well.
Any suggestions as I have heaps of work to do and I have tomorrow away from work to do it.
View 1 Replies
View Related
May 8, 2007
I have created an adp, and have created stored procedures for all of my forms. In the SQL Server database I have given my users permissions as db_datareader and db_datawriter, however they were unable to open any of my forms because they didn’t have execute permissions on my stored procedures. I finally had to give them permissions as db_owner so they could use my forms. Do I have to give them db_owner permissions to execute my stored procedures? I know I can go in and assign them execute permissions for my stored procedures, but there has to be a better way. Does anyone know how to give users execute permissions on stored procedures without having to give them db_owner permissions or having to grant execute permissions for each stored procedure individually?
I am still in the development phase of my project and having to assign users or groups with each stored procedure I create could really be a pain. Can someone please help me?
View 2 Replies
View Related
Jul 12, 2007
Hi
Not sure if you guys can help with this one but 6 years ago I used to run an internet marketing company and wrote a database to manage all the info.
I've been out of touch with access since then but recently wanted to get back into it by playing around with the one I wrote, so I searched it out from the deepest darkest folders on my hard drive and double clicked it.......only to find it says the following...
"You do not have the necessary permissions to use the c:database.mdb object" !!! :(
I have no idea why this might be so since it was only ever used on a simple network with no server involved and I am using it here at home on my standard PC.
Anyone got any ideas, or come across this before?????
All help much appreciated :)
View 14 Replies
View Related
Apr 20, 2005
I have built a login form which shows or hides all tool bars depending on the
user name and password. Can I also control the other permissons like being
able to edit forms and tables? I know I can do this using the MS Access
built in functionality, but can I do it programatically from my user login
screen.
I set the tool bar visibility, close the login form and open the main
switchboard using the "on click" button of my login form. Can the above
permissions controls be done here as well?
Thanks in advance.
Peter
View 1 Replies
View Related
Aug 20, 2005
Not sure where to post these questions...
Stupid question 1: Where are the Access program files stored? The Workgroup Administrator indicates the Workgroup administrator files are located in the following path on c:......
c:Documents and Settingsmy nameApplication DataMicrosoftAccessSystem.mdw
However, there is no Application Data folder in the folder with my name! In fact, I can't locate an Access folder anywhere on my computer...
Stupid question 2: I know I set myself as the Workgroup Administrator and I do know the password I created. This I did several days ago and it appeared to be transparent as far as accessing, updating, editing, etc.
Tonight I set permissions for another user, entered her name, indicated what forms, etc., she may access, etc.--as a user.
Now when I open the database it opens a logon box with my name. I enter my password and it says it is invalid! I can logon with the user I created, but as a user, she has no administrative permissions. Thus I have screwed myself out of managing my own database!
I have the database on a a jumpdrive drive so I copied it over the one that currently exists on my hard drive. Thinking this would solve the problem, it does not, it opens to display the same logon box!
Is there a way to delete all permissions?
Luckily, I bring the DB home to work on so my copy at work will be unaffected.
Sorry for the long winded stupidity. Any help.....?
View 1 Replies
View Related
Feb 27, 2006
Hiya
Have just created an access 2000 database which when a user logs on to the network as herself and tries to lookup any combo boxes or click a button to run a query from a form it shows or does nothing, yet when I log on I can.
Our IT Services have looked at folder/share permissions which appear to be OK and I've not set any permissions/workgroups in the database.
Can anyone shed any light as to why this is happening please?
Thanks
Dawn
View 2 Replies
View Related
