General :: One User At A Time - Prevent Multiple Users Accessing The Database
Feb 13, 2015
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.
View Replies
ADVERTISEMENT
Oct 4, 2005
Hi,
I have an Access 2000 database and I have hidden the database window in the startup options. I have also saved the database as a .mde file.
However, if a user opens the database while pressing the shift key they can still get access to the queries and tables in the database and can change them.
Is there anyway to prevent users getting access to the tables and queries?
Thanks
View 2 Replies
View Related
Dec 19, 2012
If I need to take the backend of my database offline for changes, what's the best/easiest way to inform the users? Is there some code I can drop into the front end? I'm thinking a "on database open, if [available] in tblClose equals no, then open frmDatabaseOffLine". But I don't know a) if that's possible or b) how to program it.
View 5 Replies
View Related
Aug 6, 2013
Is there away in which I can protect an access 2007 database modification with a password.I'm doing this because I would like to prevent my client from modifying or having acces to the database's back end system (db), I would just like him to use forms and nothing else.
View 3 Replies
View Related
Aug 14, 2015
I'm ready to "publish" my desktop db for end users, however I want to limit their ability to view the objects in the Navigation Pane. Essentially, the only way I want the user to be able to interface with my db is through the forms I have created.
View 1 Replies
View Related
Feb 5, 2014
I 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 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
Oct 22, 2012
I've prepared a front end database with forms that allow data to be keyed into linked tables to my main databse.
However, currently the front end database only allows 1 user to do it at 1 time and when another user tries to open the file, an error "The Database Has Been Placed in a State by User on Machine That Prevents It From Being Opened or Locked'
Is there anyway to allow multiple users to use the front end database at the same time?
View 11 Replies
View Related
Mar 18, 2013
How do I change the database for multiple users?
There is no "advanced" option in the options tab.
View 3 Replies
View Related
Dec 17, 2012
I have two separate database files, a front end with all my forms and a back end with all my tables. The backend is stored on a network drive, is there any way of being able to store the frontend on the drive with the backend? Users do not use the actual computer to store information or access files, everything is usually saved on the network drive. I have created a shortcut that launches the front end database in the read only kiosk mode.
View 5 Replies
View Related
Nov 12, 2013
I just finished a small Access-2013 database (accdb format).
Now I want to make it available to users.
How do I make an 'executable' (meaning that tables, forms, ... cannot be opened in design mode)?
View 9 Replies
View Related
Aug 11, 2015
I have my application split, BE and FE. This is a form with a subform.For both I have the properties set to
Data Entry NO
Allow additions NO
Allow Deletions NO
Allow Edits NO
anyone person can open the form, but when a second person tries to open the same form we get the standard, locked by user or user does not have permission.If user 1 logs out then user 2 can get in. So it seems not a permission issue but some setting I have wrong. maybe at the query or table level?
View 6 Replies
View Related
Aug 11, 2013
I have created a database, with various forms, modules and tables. Cos this is to be used where I work I have created an ACCDE version. I can't get the original version to open so that I can make changes.
View 4 Replies
View Related
Aug 20, 2013
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 Related
Nov 28, 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
View 1 Replies
View Related
May 23, 2013
If you are to sell a db. What have people done to stop one person copying it to their mates.
I have a way in which they send me their name,lastname and email. I then have a separate db that genertates a code based on a maths calculation. The users db does same calc. Then a comparison is done. if they match the code they entered goes green. if codes not right it goes red.
I also have macro that swap tables round when run. so by default its limted to 10 records. When swapped its unlimted.
I just cant link the 2 functions. Ideally some way it will see the green code and then run the macro to swap tables to a full db.
Then the customer has a full db and is also tied to their name etc...
View 11 Replies
View Related
Dec 1, 2013
I have a table called tblDeliveryOverview and a table called tblPurchaseOverview in the relationship there is no link between each other but i've used a query to link the one field from tblDeliveryOverview to tblPurchaseOverview.
How can i prevent a record update from happening when i update a record in tbleDeliveryOverview and the same gets updated in tblPurchaseOverview, which i don't want to happen.
View 1 Replies
View Related
Jun 21, 2014
is it possible to prevent
1- running multiple instance of MSACCESS.exe in runtime
2- running multiple instance of same database in runtime.
i have found seems not to work on access 2010 runtime.
View 7 Replies
View Related
Jun 25, 2015
I have a split database. I have secured the mde sufficiently but I need to secure the back end so that no one could link to tables in it. If I introduce a password to the back end is this going to require those using front end to supply the password? If not then this could be good solution.
As the database is on the network drive, is there any other way to prevent people to link to the db? Can I hide the db in the network drive? Or should I hide tables in the BE. Should these still be available to be linked?
View 6 Replies
View Related
Jul 19, 2006
Is Access set up to handle multiple people entering data into the same table?
We are processing returned mail and enter all the bad addresses into an Access table. The data is simply entered into the bare table. Can two people be doing this at once without the risk of compromising the data?
View 4 Replies
View Related
May 8, 2007
Hi Guys
I wonder if anyone could give me some advice on a problem i have with an access database.
I have designed a database and a data input form to collect data that is input by workers, the problem i have is that only one person can enter a record at a time.
I curently use 2 replicated database's on two seperate computers and run the synchronisation once one person has finished so that all the changes are replicated to the 2 different databases
If there is any other easier way to accomplish this i would be very greatful if anybody can shed some light on the subject.
Thanks
Brad
View 3 Replies
View Related
Jun 29, 2012
I created a database and a form on it that i enter myself right now. I am planning on using this database on several PCs with different users. Currently I have this database on the network, but when multiple people try to access it at the same time they cannot access without saving a separate copy or just having read access.
View 3 Replies
View Related
Jul 8, 2015
I need to put my Database to work with multiple users.
1- I already have divide the database;
2- I already have made the file accde of the front-end file;
3- I already have put the two files: back-end and front-end on the network server.
My problem now is that if I open a Form to register data the other User can't open the same form to add data. What I must do to work in the same form with multiple user?
View 14 Replies
View Related
Mar 8, 2013
I have my database on a server and i want 2 or more users to access that database from different stations at the same time. I am using MS Access 2010, what do i need to do and how do i do it to allow more than one person on my database? The database contains 2 tables - table 1 has 1,450,00 records - table 2 will be populated with some of the records from table 1.Table 2 is empty.3 sub-forms - 1 main form and 1 report (for labels).
Both tables have the same fields, but not all the fields are filled in and each user will be filling in the fields required.Each record is a case, and no more than one user will be assigned to a case.I need at least 2 users working on my database at the same time, i would like to have 4 users working on this database if possible.
View 4 Replies
View Related
Jul 10, 2012
I have built a database and within it my queries I use for reporting make tables in a separate database. This allows me to work in my data base and update info as needed. My problem is that my make table queries wont run if anyone has one of the report pivot tables open. I have added macros to all the Excel files that pull from the reporting DB but I still have several times when I cannot update because someone is using the pivot table, Is there a way to allow me to update the report DB's while the pivot tables are open? I have tried using manual refresh methods and disabling auto update on open but the result is the same.
View 2 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