Trying To Do Something That Goes Against UI Convention Lock A User Into A Database
Nov 1, 2004
We have an old computer that is going to be used as a simple signin and out book for volunteers. We want to restrict people on that computer from doing anything else
I have designed the form, and it is nice and evil in that it doesn't allow you to close it (cancel = true in the forms unload event) or even quit access without killing the process manually with the old ctrl-alt-del (or ctrl-shift-esc) it starts on startup and I have disabled the windows key (using XP so I had to add a binary value to the registry manually)
The problem is they can still alt-tab out of there (despite a NoWinKeys registry key that was supposed to stop that), and they can still change the main access window's size and access the start menu.
The network and local profile is such that they can't do a whole lot if they do get past the form, but there should be a way to stop them from leaving... some sort of API that will regain the focus, then I could just check that the application had the focus every second, and pretty much render the computer un-usable
Any ideas?
Thanks in advance
-mwalts
View Replies
ADVERTISEMENT
Jun 27, 2014
using the "back-end" and "front-end", how to put a password also in the "back-end"? is to lock the database "backend" for anyone to change the data?
View 1 Replies
View Related
Jan 17, 2008
Hi All,
I am running a access db within a company with about 40 users. I have split the db for multiple users. The only way I have found to fix this problem is to ask the user to close it and reopen it but this is just a quick fix.
Is this cause by our Microsoft servers or is it cause by access. Any help would be great :D
Here is the complet error msg
Could not update; currently locked by user "Admin" on machine 'XXXXXX'
please note that the user is not logged on as "Admin" but as normally user without admin rights.
Thanks in advance.
Chezney
View 3 Replies
View Related
Feb 6, 2008
Good morning! I'm building a database for use by four technicians in a call-center type operation. The call records are purely transactional in nature -- once the call has been logged, the record is closed. If the customer calls again, a new record is opened.
The supervisor doesn't want the techs to be able to go back and edit a record once it's entered -- the records are for quality-control purposes and he doesn't want them gaming the system by going back and changing things after the initial call is logged (let's not discuss the issue of employee psychology, motivation, Office Space, etc.). So I'm trying to figure out how to do that; they all have wheel mice, and I can currently see all the records as I scroll back and forward with my mouse wheel, so I'm assuming they'll be able to, as well.
Any help?
Thanks,
Andreas
View 11 Replies
View Related
Jul 2, 2013
We have a split ACC2010 database, with the back end on our server and 5 front ends on 5 client PCs. I hadn't run a compact/repair on the back end for months. When today I tried, I got the 'database is locked' error. The lock file showed 'Admin' logged on at all 5 clients. The front-ends had been closed on all 5 clients. We do not have a user called 'Admin'. Because my issue occurs for all clients, it might be caused by some sort of programming error in the front end.A VBA bug (implicit comparison to a control in an If .. Then construct) caused this type of behaviour but was resolved in Access 2007.
View 12 Replies
View Related
Sep 19, 2013
I have a form that allows a user to complete a stock take. I would like to stop other users from receiving or despatching stock while a stock take is in progress.
Is there a way I can lock a table, or stop users adding or altering records that match certain criteria. i.e. don't let users receive or despatch stock from with a locationID of 'A'.
View 4 Replies
View Related
Mar 27, 2015
I have a form and I want show a message on the form when the it is locked as another user is editing the data in a particular record.
I know the record selectors show the records lock status but it a very tiny symbol which will mean nothing to the users of the database and anyway I don't want record selector bar on the form. How I would do this???
View 2 Replies
View Related
Nov 28, 2013
I have a form in Access2000 with 5 text fields which get transferred to the table for each new record. Is there a way i can "LOCK" one field so that once the user has input that data it never changes until closed. I can already lock the field but once i create a new record the field then goes blank.
View 4 Replies
View Related
Jan 25, 2006
I've searched and experimented, but to no avail...
On a form (frmWorkOrder) , I want to “call “ a property on a subform (Named sfrmDocument). In order to disable that subform.
Thus far I’ve narrowed the error to:
Me!sfrmDocument.Form.Enabled = False
Me!sfrmDocument.Form.Locked = False
This seems to be the way that http://www.mvps.org/access/forms/frm0031.htm would handle it. Someone's suggestion and it seemed to work before ...
Maybe I’m reading it wrong!! At any rate, I get the error 2465 Application defined or object defined error.
Am I forgetting something ? Help!!
View 4 Replies
View Related
Jun 8, 2015
I would like to add the "Month" of the information queried to my file name at export if possible. I included my current code and an example of how I would like the title to read.
DoCmd.TransferSpreadsheet acExport, 10, "tblStarzIncentivePayoutExport", "C:StarzExportsIncentive Payouts" & " " & "Ran" & " " & Format(Date, "mm-dd-yyyy")
I would like the file to be named:
Incentive Payouts "Month out of the date ran in the query" Ran 06/08/2015
Is it possible to do?
View 1 Replies
View Related
Jun 23, 2015
I am having a problem running a make table query which is based on the same tables that I am using in a sub form.
Basically, the user selects certain records in the subform (which is in datasheet mode) using a check box, then once selected he hits a command button where there is some code that will run the make table query, which I use to filter other tables in a related reports.
However I keep getting this silly "database engine could not lock table" message relating to the sub form name. The subform is not linked to any records in the main form as the main form is unbound.
The solutions offered by putting DoEvents or Me.refresh/Me.requrey in the code do not work.
View 7 Replies
View Related
Apr 24, 2013
I have a multi user database in Access 2000 that is on a server. The individual users have shortcuts pointing towards the server instance. One user and one user only when opening the shortcut gets the error "you do not have exclusive rights to the database" .
All other users can enter the database with no error box. I have checked the advanced setting under options and they are correct. Ironically if you go to start and open access then navigate to the database shortcut. It opens with no error.
View 1 Replies
View Related
Feb 14, 2006
I have a live db running on a VPN network (FE/BE both centrally located on a main server , users 'view' their own personal front end through the VPN tunnel) ) and have recently provided a new updateto the FE. Until this time , most users were problem free but one persisted in getting the above error message. Now the new update is in place , they all get it, and this is when no one else is using the db and a single user logs in and tries to use the system. I guess it must be an internal fault ( ie my fault ) but then why does it work for some and not for others?. It also works no problem on my system at home. The user runs Access 2000 and the db was developed in 2003 ( default file format 2000)
Any help most appreciated
Thanks in advance.
View 1 Replies
View Related
Jan 18, 2013
I am using access 2007 and my backend DB has a lock on it while every user has said they are not in the front and back end db's. Is there a way to remove the .laccdb lock? I need to modify my backend and this is holding me up from making any design changes.
View 5 Replies
View Related
Apr 7, 2015
What I'd like to do is have an "export button", where the OnClick event, exports a single table into a new accde file. This would allow the end users to zip this file up and send it to me.
Because of all sorts of stupidity, I have no network capability and must send data back and forth via email.
I have digressed to a replication table that needs to be uploaded, once data is entered by the users...
Because the files can get relatively large (for emailing purposes), I am trying to figure out how I can get just one table from them vs. sending the whole application file back to me... It's pretty vital that they not be able to edit the table because that could really mess up the process.
So any way to create a new lock file from within the current Db?
View 1 Replies
View Related
Jul 12, 2014
I've added a list box to my form that displays a table. This table is completely independent and gains it's data from an Append query. There is also a Delete query, which clears the table for a new set of data, and an Alter query which resets an AutoNumber column in the table (so that new data sets always start numbered at 1).
Here's the problem: Since I've added the listbox and set the RowSource to the table, whenever I run the Append query I receive the error: "The database engine could not lock table 'tblLineSheet' because it is already in use by another person or process." I've made sure to close the table, but to no avail I still get this error. Without the List Box I don't encounter this error.
View 2 Replies
View Related
Oct 20, 2014
I have a DB with multiple import processes to take in information and populate various tables. This has been in place for some time and works with no issue.
The import process involves the creation of a local staging table, to which I import the received data, normalise it according to my own table structure, remove any duplication (i.e. same data imported repeatedly) and append the cleansed data to the main tables.
I've just added a validation step to check for data integrity. In other words, for duplicate data, rather than simply purge it as I was doing previously, I now check to see if the data has changed in any way and prompt the user if necessary (with the option to either ignore the change or update the existing record)
However, since I added this extra step, I am getting the following error message during my import process :
Error 3211 : The database engine could not lock table 'tblStaging' because it is already in use by another person or process
It only appears a) when a data change is detected and b) when the option to update is chosen, and seems to occur after the update has taken place (i.e. I can see the records suitably updated)
But I can't replicate the error while debugging so it seems to be a run-time issue. It's definitely not another user as the staging table is deliberately local (specific to that user's front-end)
I suspect I can probably solve the problem by adding some kind of DoEvents call or brief pause somewhere but the problem is, I don't know where the problem is occuring, so I don't know where to add the line? Or if that would even solve the problem at all?
Is there an easy function I can call to check if the staging table is locked? Which I could then use to debug and identify exactly where the lock is causing a problem? Or even apply the DoEvents to release the lock? (It must eventually get released as if I step through the code, I don't get the error?)
View 5 Replies
View Related
Apr 16, 2013
I've got a database in Access 2007 that keeps track of client data for work. It's been working fine for about a month, and suddenly today other users can't change any information because the records are suddenly locked when accessed from their accounts.
I've already checked that they can't update forms, tables, nothing.
I've checked the database properties, it defaults to shared with no locks.
I've checked the properties of my forms - no locks.
I've double checked the permissions to the folder that the database is in - no restrictions.
The database is split.
View 6 Replies
View Related
Jun 13, 2005
I need to lock and unlock a a few text fields with a CMd Button.
and i do know about the allowedits thing, but i only need to apply this to a few fields on my form.
can some one throw me a clue?
View 2 Replies
View Related
Jul 25, 2013
I have a form that contains a subform. The subform is a datasheet which calls the results of a query of 4 tables (tbl_companies, tbl_deals, tbl_products, tbl_vl).
In the main form there is a button which opens a report with a historical record of dates of value changes of each product up to a chosen date. This chosen date is determined by inputting a date into a text box.
This report also sources (tbl_companies, tbl_deals, tbl_products, tbl_vl).
When I try to open the report, I get the run-time error "3211".
'The database engine could not lock the table "Tbl_companies" because its already in use by another person or process.'
I'm guessing that because the query for the subform is already calling the table, the query for the report can't call the table at the same time?
View 3 Replies
View Related
Jun 15, 2007
I was wondering if there was a way to view mdb file without the navigation pane and ribbon (for Access 2007). I know I've used an access database that someone else made and it was done in a kind of "user-only" style interface where all you saw was the forms and reports in a dialog box style. This kept the user from seeing any of the tables and queries and all the "under the hood" types of things.
Does anybody know how to do this?
View 1 Replies
View Related
Jan 29, 2008
I would like your opinion on this; I have a ms access database that will be used in a multi-user environment, across different Teams. Data will be loaded from text files several times a day in a MS Access table, users will retrieve the data from the tables and displayed in a form. Their job will be to add comments and select drop down boxes for actions they have taken. Since the data is downloaded in the tables and retrieved from the user instead of the user keying in the data from scratch I would like to know how to best design this. I’m thinking of having a query run to display the data in the user form but is there a way that I can have the data refreshed every so often so that users can be presented with the new records that are being downloaded. What best practice should I use to avoid conflicts like example splitting the database or using record locking options
Any help is appreciated! Thanks
View 2 Replies
View Related
Mar 17, 2008
Hello Everyone! I have a project that is driving me crazy!! :mad:
I have a form on a database that retrieves data from a query; this database is in a multi-user environment. What I am trying to accomplish is to allow the form to bring up the next available record that has not/or is NOT being worked on yet. The form I built does a re-query every time the user goes to the next record and looks for anything that has not been worked on yet. It does this by looking at the timestamp the user has placed once completed the record on the form. I also placed my record locking option to Edited Record. However when the users sign on simultaneously they still get the same item on their screen. Is there a way to create some sort of locking mechanism that would allow the form to display to the user the next available record that has not been or is not being worked on by a user at this time? Theoretically I am looking at something like this: Once a user opens the form and the record is displayed on the screen, lock the record and avoid any user from viewing or editing this record. All other users should be directed to the next available record, every time the user hits the next button move to the next available unlocked record and immediately lock it from viewing or editing from everyone else.
I appreciate any help you can provide me on this!!
View 1 Replies
View Related
Dec 22, 2006
I searched around to have multiple users and the only thing I found on the topic was
the following:
On the Tools menu, click Options.
On the Advanced tab, under Default open mode, click Shared.
and its suppose to work (which it didn't since I'm posting)
I have a few tables and a few forms, and I need to be able to have 2 or 3 people on at any given time.
Thanks for any help or even looking @ my post
View 3 Replies
View Related
Jul 25, 2007
I have a 2000/2003 format database used only for reporting.
It has linked tables to an SQL Server database.
It automatically opens a form with two buttons on it (no data) and hides the database window and the regular menu, replacing it with my own toolbar.
The default open mode for the database is "Shared."
The default record locking for the database is "No Locks"
On the opening form, the record locking is set to "no locks."
Yesterday, no problem for two of us to share it.
However, when I open it on my computer (not to edit - to use. I simply open it - not in exclusive mode.), and then another person opens it, they get the message that says "the database has been placed in a state by "Admin" on machine (my machine) that is locked and will not be able to be opened." (not verbatim, but close.)
When the other person opens it first and then I try to open it, I get a message that I don't have exclusive access and will not be able to save changes. I have to hit okay about 6 times, but then it opens.
Some users at off-site locations are having problems sharing - some are not.
Any ideas?
View 3 Replies
View Related
Sep 7, 2014
i was told i could use statements like GRANT SELECT ON Accounts TO Web_User, only i dont know WHERE to write the statement and how to write it so it grants read only permission to all web users.......im using Microsoft Access 2013.
View 3 Replies
View Related