Multiple Users In One Database
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 Complete Forum Thread with Replies
Related Forum Messages:
Multiple Users One Database
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 Replies !
Trouble Opening Database For Multiple Users.
We have an access Database stored on a server that until now was only ever accessed by the one user. Now more users need to access it at the same time. However when a second user trys to open the database the error message "File Already in use appears". I did not create this database so have no idea how it was set up. I think it may have something to do with being opened up exclusively. Is there anyway around this by creating a short cut or changing any kind of propertties?
View Replies !
Multiple Users Can't Open Same Access Database
Greetings. When I create an Access database on my company's "secure" server (through a PIX box), I get this message in a dialog box when I try to open the database again: "Open File - Security Warning. Do you want to open this file?" It then gives the file Name, Publisher (unknown publisher), Type (Microsoft Office Access Application), and From (the file path and name). The bottom of the dialog box has this message: "While files from the Internet can be useful, this file type can potentially harm your computer. If you do not trust the source, do not open this software." When I click on the "Open" command button, the file opens just fine. There are a couple of things going on here: 1) When I open this same database or any other Access database on another of my company's servers that is not protected by a PIX box, I do not get this dialog box. 2) When two users try to access an MS Access database on the "secure" server, the first user will get in, but the second user will not. The second user will not get ANY warning messages -- nothing happens. This occurs if the second user tries to open the database by either double-clicking on a shortcut on the desktop or by double-clicking on the file name in Windows Explorer. Note that the second user CAN access the same file if s/he starts up MS Access from scratch, and then chooses FILE>OPEN from the main menu. My goal is to be able to let multiple users access the MS Access databases on the secure server by either double-clicking on the shortcut icon or by double-clicking on the file name in Windows Explorer. I thought perhaps that the "unknown publisher" issue might be part of the problem on the secure server. So I created a certificate using the utility "SELFCERT", went into the database, went into Visual Basic (Ctrl-G), went into TOOLS>DIGITAL SIGNATURE and assigned the digital signature, and re-saved the file. I then exited the file, went back in, and the dialog box still pops up saying the file's publisher is "unknown publisher"! If I go back into Visual Basic, the database is clearly marked as digitially signed by me. I don't know why the initial dialog box is still showing that the file is not digitally signed. If anyone has any thoughts about these issues (multiple users not being able to access the same Access database, and why my file is saying it is still not digitally signed), I would appreciate your input. FYI, I am on a Windows XP workstation and our company users Windows Servers. Thanks, David
View Replies !
Unique "Unrecognized Database Format" Problem W/ Multiple Users
I have read through just about every post on this forum related to "Unrecognized Database errors" and have not found a solution to my direct problem. Stats: Database is running Access2K on all machines; db is on network location, no sharing issues or permission issues have been identified, no other databases in this network location have had this problem. also, we have tried compact-repair and also have tried re-creating the database and neither have proved successful. I can open the database just fine if I am the only one opening it. If someone else tries to open it once I have it opened one of the following occurs: 1. Nothing. Hourglass appears for a split second, then nothing happens. 2. Error message "unrecognized database format "mydb.mdb"" appears. If I click OK and both users close the db, it can be opened just fine again by the first user. It doesn't matterwho opens it first, but the second user gets this message. Any ideas why this is happening? Thanks!
View Replies !
Multiple Users
All, I have database with user level security that works fine, but I have asked to place this database onto our secured network which means multiple users could have it open at any given time. How can I setup this database to allow multiple users? I am very, very green at Access. Please don't say split the database...please! :eek: debo
View Replies !
Multiple Users
Please refresh my memory on how i can set up a database having about 10 users possibly making entrie at the same time. I am trying to make a small database for containing employee surveys.
View Replies !
MDE And Multiple Users
I want to create and mde file in order for the users not to change any thing on my design, I will be uploading the file into my server and give them the path to access: 1.3 people (max) will be accessing the database, is that a problem or not? 2. I cant create an mde file I have to convert my db but I have read as well if I covert it to 2000 people who have lower or higher version wont be able to access it, how can I fix that? Thanks.
View Replies !
Multiple Users?
Hi, I am trying to create a database that MULTIPLE users can log on and view the data. Eg. I have a client list and have employed 5 ppl to call each one of my clients and confirm their details. I have imported all the details into a table and just want users to simulataneously log on and click a "next record" button that will bring up the next "new" record with the details displayed on a form. of course the database will flag this record as "old" and which user called them. Main thing is 5+ computers can connect to this database simultaneously and no record gets displayed more than once. Can MS Access do this? if it cant, would a vb front end located on each computer help? Thanks for any suggestions! Jon Cheah
View Replies !
Multiple Users
i have a database which is shared on the network. i have one problem right one. when one is using the database, another person cannot access it. what can i do to enable multer user access it at the same time. Any help will be highly appreciated.
View Replies !
Multiple Users
Hi all, o.k prior to a previous message i have been back to my manager and informed him that there is no way of updating effectivly via email. o.k first i will tell you what we will have: Three networked pc's running xp prof, and access 2003. Now what i want is to be able to have my database running as a server on one machine and have the two other machines running the same database simultaniously all of them updating. Now what i need, i dont want to have the work done for me, just if someone could point me in the right direction, maybe one or two tutorials, any pitfalls i may find etc. thanks in advance.. Rob
View Replies !
Multiple Users
I am building a database which will be used by around 30 people at the same time. When telephone calls come in they will log the details. I dont need anything to explicit. I have one table, around six queries and 3 reports. I will be using one form with a save button and next record button and a switchboard. The users will log on at the same time and will log all telephone calls thoughout the day. Will the database work with so many people using it at the same time or do I have to change the properties.
View Replies !
Multiple Users Over VPN
I'm a relatively new Access user who is remotely connecting over VPN to an Access DB on a "fileserver" on a peer-to-peer network. The VPN connection is "always on", and I have a drive mapped to the fileserver. When I originally load the Access file, it takes about 2-3 minutes to be able to start working. If no one else is updating records, my speed is fine. If someone else updates a record, my Access session "freezes" for 2-3 minutes... coincidentally the same amount of time needed to load the DB in the first place. I assume this is because the entire DB is resynchronizing everytime a record is updated. Is there anyway to speed this process up? My updating records does not have a similar effect on the local users. Thanks for any help or suggestions, RJRon My computer: Dell laptop, P3-500, 128Mb RAM Operating system: Windows XP Pro at both ends Access version: Access 2003 at both ends My internet connection: Cable, download consistently over 1000kbps, not sure about upload Their internet connection: DSL, download consistently over 1500kbps, upload 500kbps
View Replies !
Multiple Users
How would I go about making my database so that more than one user could open it on the server and both be able to populate the tables. Is there any problems I should watch out for? Also, what is a good way to create a "log in" type form, where the user would log in to the DB, so I can keep track of who entered in the information, at what time and so on. And then would that person have to log out some how? or just close the database Jared
View Replies !
Multiple Users
I've created a database and I'd like to allow multiple users to go in and edit the same table. I looked in the Tools - Options - Advanced tab and it's currently set to open in Shared mode. However, when I have the database open (as the creator) no one else can open it. Is there a way to fix this? Thank you.
View Replies !
Multiple Users
I have a peer to peer network using XP. I have 5 people that need to share one MS Accss Data base. I have checked the security section and it is shared. The difficulty is that only two or three folks can be on at on any one time. I was hoping that all of us could be working at the same t ime. Any thoughts on how to accomplish this? Thanks in advance for your time
View Replies !
Multiple Users
Hello, I am going to have a database on a shared folder. Only about a max of 5 people will be accessing the db at one time. Will it be enought to just create the Frontend and Backend portions of the database and not run in to any problems. For example, if 2 or more people happen to be in the same record at the same time trying to update a field. I have studied the VBAUnbound.zip, but it is a little confusing to me. So if i can get away with just using bound forms that would be great. Thanks in advance.
View Replies !
Multiple Users Slowdown
Hi everyone, This is my first post, hopefully you guys can help me out. I have set up an access database for my dept. stockroom. The stockroom previously was just 1 excel spreadsheet that had the shared setting enabled so multiple people could edit it and such. This became extremely tedious and saves started to take up to 15 minutes when about 5 people had them each open and did edits. I managed to set up an access front end and backend for this situation. Basically the table was saved in an access database and the forms were in another that linked to the tables. So the table database is on the network shared folder, and the forms are on each individual computer. It seems like this would work fine and such, but when just 3 to 4 of them open up the forms and start working, as soon as one person trys to make a change, the whole program slows down almost to a halt. what am i doing wrong? any suggestions would be appreciated. Thanks! Jerry
View Replies !
Multiple Users And Employee ID's
I am nearly ready to release my ACCESS 2000 database to 150 employees in our office (client/server network). However I have two problems, I have looked through countless posts and cant find exacly what Im looking for. ACCESS automatically defaults to each individuals network ID when it is opened, so I have set that as UserName for each user, I have created a UserDetails table with this netowrk ID as a primary key, linking that as a foreign key to various OrderDetails tables. My question is how on earth can I get ACCESS to automatically enter this UserName onto each order a particular user makes? to be able to run queries for specific users etc? I dont want the user to be able to manually type in this because it can compromise the integrity of our data. secondly, what is the best way to set up the FE, BE situation on our network? I tried the wizard and it gets a bit technical Cheers for the help and congrats to a very helpful site, Russ :)
View Replies !
GIF89.DLL And Multiple Users
Does anyone have a good idea how to either 1.) add this library to the database file itself or 2.) automate a process to get it registered on multiple computers without having to goto each station individually? I have added animated gifs to my database but as you can imagine if i want my users to be able to see it i would need to register this file on EVERY machine i want it to work on.
View Replies !
Questionnaire For Multiple Users
Hi, I am trying to construct a questionnaire that asks a series of questions (one at a time) to multiple users who have to answer A or B. The users will be performing the questionnaire at the same time. ___________________ I want the questionnaire to run as follows: 1) People select their name in a form (Form1) 2) A series of questions (from the tblQuestion table) are presented to the user (Form2) 3) A table is populated which records the following info * Response_ID (Autonumber) * User_ID -> based on their selection in form 1 * Question_ID (number) -> taken from the tblQuestion table * Response_Value) (Text = A or B) -> as submitted by user ___________________ I presume I need to set up the following tables: Table 1 - tblUser * User_ID (number) * User_Name (Text) Table 2 - tblQuestion - the table that contains the actual questions * Question_ID (Number) * Question_Description (Text) Table 3 - tblResponse - the table that gets populated * Response_ID (Autonumber) * Question_ID (number) * Response_Value (text) ___________________ My problem is that I am not used to adding records to a table (via forms) as this is the first time I have to run the questionnaire for multiple users (previously i just placed the "A or B" textfield in the tblQuestion, but this is not possible with +100 users. Could someone please give me some advise as to how to get started with this, in particular at the Form level. Thanks in advance, Steve
View Replies !
Multiple Users Question
Hello, I have this database that I'm working on that wasn't designed specifically as a "multi-user" application. But it's now to be used by various people across a network, and I'm wondering what, if anything, I need to do to make this work. I don't really have any security concerns, I just want to end up with a system where more than one person can create new records at a time, and browse through existing records, edit them, and print reports off the record they are viewing. Access help make it sound rather easy - just set "Open Mode" to "Shared", and "Default Record Locking" to "Edited Record". "Open Databases Using Record-Level Locking" is also checked. It sounds like that beyond that, all I have to do is make the application available on shared network drive, and that's it. Could it really be that easy, or what else needs to be done? Thank you for your advice.
View Replies !
Multiple Users And Forms
Hi, very new to access and chucked in at the deep end. we require a database which will be used by multiple users to place orders. the users are at different locations although they all log on via terminal services so connection issues are minimal. i understand that we require a fe/be database because of the users. the users will only work with forms and reports. they should not be allowed to see the other users orders and the form needs to automatically put the users id into the order. the only way i can see to achieve this is to make a custom form up for each location. would i be right in assuming this? if so, how would i prevent one location from opening up another locations form? infact, i wouldn't want one location to know that there are other forms for other locations. any help would be appreciated. thanks
View Replies !
Multiple Users In Same Form
There will multiple users accessing the same database/forms at the same time. How do I ensure that all entries are saved and not overridden by each other entries? Access 2003
View Replies !
Preferences; Multiple Users
I have a database which is shared via a network drive. Now certain users want to hide some colums in some query results of tables. Problem is, when one user changes something it will only be temporarily, next time they open the table, it will be set with preferences of a different user, who might want to hide and show different records. Is there a simple way to save these preferences seperately for every user? Thx!
View Replies !
Table Used By Multiple Users?
Hi all, I have a table tblLineItem contains materials/line item records assign to different buyers. Each buyer/user needs to access the same table tlbLineItem and choose certain line items and works with them to create PO (purchase order) . How do I lock the table while whoever access first then after that person finish it release the table to avoid each process of one buyer's items overlap with other buyers' line items. And if the table is being used have a message box alert to inform the buyers, so they can wait? My problem with this database is right now I placed a check box on each line item on the form that have the data source is the tblLineItem. Each buyer filters only their line items, check the box of the line items they wish to create PO at a time and click the button "Create PO". However, if buyer A uses the same form and check the boxes on his/her own line items, while coincidently buyer B also work on the same form then when they click "Create PO", their line items cross with each other!! If you have suggestions, please advise/help!! Thanks so much.
View Replies !
|
TRACKER
