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
Another baffling problem - there are far more traps for new players than I ever imagined. Any suggestions gratefully received.
I have a fe/be split database with multiple users on a network. All users have the same front end on their PCs and are either running Access 2000 or 2003.
Problem 1:
Some users cannot open the database at all, getting the error message "Could not open xxxxx.mdb - File already in use."
Problem 2:
Some users can open the database but get a message in the status bar saying "Recordset not updateable."
Other users, running either Access 2000 or 2003 have been able to use the database without difficulty. The number of users is in single figures and it is unlikely that more than 4 people have attempted to log on simultaneously.
The database default open mode is set to "shared", the default record locking is set to "No locks" and the "Open database using record-level locking box is checked".
I have been having difficulties setting the security for the database (see other postings on this site) and so it is currently unsecured with no password set for the admin user. Users are joined to their default system Workgroup Information Files.
My guess is that there is a setting on the Access installation of the user's PC that needs to be changed but this is only a guess - anybody any idea what I should try next?
Regards,
Keith.
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 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.
Hello Everyone,
I have a database that I splited the tables on one file and queries, forms and macros in another. The front end file (the one with the forms) I published it in our intranet, so when some one clicks on the link a form pops up which is the way it supposed to work. The problem I have is when some other people in my area go to the intranet and click on the link and get the error that the file is read-only and the macro that makes the form open up fails. I checked the file's properties and is NOT read-only, so I don't knwo what the problem is.
Please help!
thanks,
Pablo
I am trying to create a database such that everyone in my company will be able to access it, but without having to install access and put a link to the DB on every computer. Ideally, I would like to have some sort of web applet that uses the DB on a central server and allows users to add and modify entries without having to know anything about Access.
Any help would be appreciated
Hi there, wondering if anyone can help.
im trying to create a multiple user access database, but i am experincing problems when more then one person is trying to access the same entry fields and this is causing conflicts, the database is stored on a server and is not localised to the network machines. what i would like, is when a form is opened by user 1 (record no 10), user 2 should be able to use the same database form and go to a new record (record no 11) that isnt already in use by user 1.
any advice on enabling the database for multiple user access is welcome.
Last question.. honest.. maybe ;)
I have a query that prompts the user to display certain/all of the members in my member table. The problem is, using a parameter query in the memberID field only allows the user to send the message to one member, not multiple members. "1 or 2 or 3" or "1,3" obviously don't work.
I've tried creating a form with a list box to select the members (which I;ve done) but obviously you need code and stuff to get it to work which I think will be too complicated. Is there a simpiler way or is the form the only thing that will work?
Thanks
Kris
I have a database application that i intend to split with the table part on a server and the forms part on each users desktop. It will be used by approx 10 users. While the probability of different users accessing and updating the same form is small, the possibility exists.
Is there a way i can prevent any weird multiple update stuff happening? I'm using Access 2003
I've got this database that needs some users to be read only and some users to have full control. I applied the appropriate ntfs permissions but there is a problem. If a read only users open the database, and then a full control users opens the database its stuck in read-only.
The database is a 2007 accdb.
I'm trying to set up a simple query that links four tables. However, the tables are extremely large, all in excess of 1.5GB each so I had to split the tables up into four separate DBs. I've tried the following with no success:
1) Link the 4 tables in the DB which contains my primary key. This quickly inflates increases the file size above 2GB and won't let me go any further.
2) Build a remote query to connect the four tables. This looked promising until I tried to run the query and it became evident that it only knows to point to the last database source that you specified.
I'm running everything locally on my C drive. The data source are simple text files (1.6 million rows) from the FDA website.
Hello,
I have a database we use to enter new account numbers and several other atribbutes about the account and it is split into a FE/BE with the BE in a shared folder. I have the open database using record-level locking checked but it seems to me that the database is opening up with page-level locking. Multiple users will receive a message that the current record is locked and I am sure that they are all not updating the same record. Does anybody have any idea's of what I can do? If nothing else I am going to have to recreate my form as an unbound form and see how that goes.
I have not created any user accounts for this new app. When working over terminal services, multiple users can open the app and look at it, but only the first person in can add info.
I have set the record lock fields and sharing correctly.
It appears that the program will only allow one admin to take control of the db, regardless of what they are doing inside the app. Is the best solution to define individual userids and passwords for each user?
Hello
I have created a database for my department to log all of our jobs to keep track of them and I want to create a simple search for them but I am having difficulties.
I am familiar with creating queries to search tables for matching records, but is it possible to get search criteria from the user (ideally from a search form they fill in) to form the query?
For example, I would like the user to be able to query the jobs by month and/or business area and/or supplier...is this possible?:confused:
Any help gratefully received!!!
:)
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?
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
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!!
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?
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 RelatedI am creating a form that has a bunch of yes/no box for daily task. Is there a way for access to record which user selects yes/no.
For example
yes/no box1 - user 1 completed this task
yes/no box2 - user 2 completed this task
and so on
So when i look back i can see which user complete which task. I did a bit of research and saw that i can save a user that update a record. But since this is a daily task, each new record will be a new day.
I've designed an Access Database (using Access 2003) and assigned user-level security to it such that some users are read only and some are full access. Everyone requires a login and password to access the database. The problem is, once I copy/paste the database from my computer to the shared drive (where it will be accessed by all the users) the prompt for a username and password disappears.
View 3 Replies View RelatedI am currently attempting to setup a database that will be used by many people. I have the database setup and it is split into a backend (tables and data) and a front end ( forms, queries, etc) which the users will download and use off their own machines. I'm attempting to house the backend on our webserver.
The backend is on our webserver and I'm attempting to link the tables from the front end to this location. I typed in the webaddress into the open menu after selecting the Get External Data --> Link Tables menu item. I am sure that this web address is correct because I copied from my browser (from which I was able to download the database from). After I put in the web address into the open box, I get an error about not a valid file name. Is there something I'm not thinking about? What could be my problem? Is it permissions maybe? Does there need to be something special setup with the backend or my webserver? Any ideas as to do with the problem would be greatly appreciated.
My database is on a shared server and many people are able to access the database at any time. What would be the best method to create a way for me to make design changes, etc. without having to make sure everyone is out of the file to allow me to open exclusively?
View 6 Replies View RelatedHello, I am in the process of creating my database and I was looking for some guidance. My goal is to manage and track clients attending our program and ultimately being able to print and individual report with that information. Example: john doe on 12/28 attended 3 groups X,Y and Z.
I have created two tables one with the client's ID, name and starting date.
The second with the groups offered, the instructors and days and times of the groups.
The third I believe should be a dated table that would have groups and all the people who attended that day. This is where I am getting confused. I am not sure how to proceed.
Any ideas or suggestions would be welcomed.
Thanks in advance.
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
Okay, wonderful gurus! I'm getting ready to split a db and I'm seeking advice or counsel from you. I know how to do this, but want to make sure no one out there has some mystical secret to reveal. What do you think I need to know before I do it? Assume that I've done this before and am looking for little "good to knows".
One MAJOR question I have is concerning the security involvement. I am going to assign a workgroup (security settings) to the db, and I'm wondering how to make sure that both ends are usable with security after the split. I know this is confusing, but I know how smart you all are and I'm hoping you know what I mean.
THANK YOU, THANK YOU, THANK YOU!!!!!
KellyJo