Threads Replies Last Post 13 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13   Multiuser db with users in different locations - advice? Hi, I have developed an Access application to administer competitons for a photography club. Now, because of the workload entering all the data, I am looking to make it multi-user. That, in itself, is not a problem, and I have done such apps in the past. However, thie issue here is that the whole thing isn't in a single office, running over a LAN, or at separate offices with a leased l... 3 31.03.2006 10:54:00 Another user logged in? Hello All I have a split FE/BE a97 mdb, with 4 PCs on a peer-to-peer W2k network each with their own FE, and a BE on a fileserver running w2kserver. Whenever I try to do a compact/repair on the FE on my PC I get "The microsoft jet database engine stopped the process because you and another user are attempting to change the same data at the same time". But this is not true - there is defini... 2 30.03.2006 02:55:00 shared over network - mapped drive vs. sharename Which is faster, if any, when accessing a backend from a local fronted over a network - mapping the share to a driveletter og just using the sharename? Does it matter? Jesper ... 6 30.03.2006 02:52:40 Multiser Access-Data Entry I'm using Access 2003. I have a database that I want to allow all users to view, and print reports, some users to be allowed to enter all of the data, and finally some of the users to be limited to entering data in specific fields. Is this possible? The form is tabbed. Thanks, -- Bob... 2 28.03.2006 13:19:56 Server Questions - Hardware advice I will be splitting my database in the next month or so after more input and testing from management. I will have access to a SQL server.... So here are my questions. 1. If the database is going on a SQL server, are there additional steps I need to take or does it just work like a file server? 2. Should I really be asking management for a dedicated file server to hold the access databas... 4 27.03.2006 03:21:54 Error 1206 I have about 15 users in my database and quite often I get error message number 1206 "Could not find field 'Description'". Would this be related that I haven't set yet edited record-locking = as soos as one user begins to edit a record, no other user can make any changes to it until 1. user saves the changes? ... 2 25.03.2006 14:15:13 How do I place an icon each user's desktop for the database? After setting security & splitting the database, I need to place an icon on each user's desktop so they may just click & view the database. How do I do this? ... 3 24.03.2006 17:11:46 Corrupt database can't repair I have an AC2000 Database running in AC2k3 that users are now getting this error: The microsoft jet database engine stopped the process because you and another user are attempting to change the same data at the same time When I try to open it to repair I get the error, when I try jetcomp.exe it gives an error, when I try to import the objects I get the error (In fact it doesn't let me ch... 7 22.03.2006 20:06:23 network will be slow dear sir, i am working as a system administrator, we are using windows 2000 server DC 180 nods . this is the institute. wen our students is using mapped drive at a time then network will be very slow.. the students is using mapped driver... our mapped drive is Z:/ drive......... if anybody have got this problem pls give a solution pls........ ... 2 22.03.2006 05:24:41 security error when we open a database from a word application. I forward a problem to you because the security team did not reply yet. Please if you can be of help or let them know in case they find time to answer. By: P. Scaram In: microsoft.public.access.security I forward you a problem where after an upgrade to Windows XP and Office 2000 opening an MS Access database from Word using DAO 3.6 it returns to me a 3033 security error. ... 1 21.03.2006 13:27:05 ¤ China ZhongZhan Aids Mei Mei Killer! http://onfinite.com/libraries/175399/440.jpg elmar@digi-art.de ... 1 21.03.2006 12:48:21 ¤ China ZhongZhan Aids Mei Mei Killer! http://onfinite.com/libraries/175399/440.jpg elmar@digi-art.de ... 1 21.03.2006 12:48:16 Users Hi All, How can I determine wich users (or machines) are logged onto a back-end database? (in case of maintenance ?) And how can I kick them out (after a first friendly request) regards, Joop ... 2 20.03.2006 20:19:27 Ink Sorry guys. The spam stuff was not my intent. I do oppoligies and won't happen again. I have never been on newsgroups before and not sure how to work them. I hope you guys can forgive a bad choice. Murphey... 1 20.03.2006 12:07:30 Access 97 Disk Network error For the past 9 years we have had a database (split) .Server 2000. Two buildings (One server) T1 line connecting the two. The building farthest away has now started giving disk or network errors. The network administrator says it is the database. I disagree. Also it used to be multiple users at the far away building could get into the program at the same time. Now if one is in it and another ... 2 18.03.2006 02:07:13 Remote Synchronization I have a standard multi-user Access database with a backend, a design master and a master replica. Each user makes a replica of the master replica and synchronized to the master replica. I synchronize changes to the design master also to the master replica. I have four users that work from home and all user at least a cable modem broadband connection. It is very very slow for the rem... 2 18.03.2006 01:53:00 MSACCESS.exe has generated errors This annoying error message from MS Access "MSACCESS.exe has generated errors and will be closed by Windows. ... " Keeps happening for most versions of MS Access like 95, 97, 2000, that I am aware of. On the web, I see that I am not the only one who have problem, sound like there is a huge variable as a reason to this error. As an IT staff, we have tried everything possibly we can to solve t... 15 18.03.2006 01:49:26 Error Mesage "File is already in use" Dear all, I share the MDW file in the server. If the second user execute the shortcut, there is an error message "file is already in use". How to solve this problem ? Thanks. Regards, Vensia ... 2 16.03.2006 03:37:36 Access 2000 limitation? I am wondering if access 2000 has a table size limitation. A limit to the number of entry's perhaps or something similar. Reason being is that i have a department of users that state that they need office 2003 because access 2000 'could not handle all of the data being input'. I am aware of access having a limitation - in terms of practical usage - when the number of simultaneous use... 3 15.03.2006 21:45:10 db locked Have an Access db on Network drive being opened by other application. Problem: only one user can open at a time. Have set to shared mode and each user is able to create the ldb file on the network drive, but still get message saying can't open because already open by other user. -- Anita Headley Database Systems Analyst... 4 15.03.2006 03:36:22 multiuser database freezing I have a database with both the front end and the back end on the network. (yes I know this is a bad idea). The current problem is that sometimes when the user is working, the hourglass appears out of nowhere, and then, the current field she is in (a memo text field) is highlighted - so that if she is not looking out for it, it may get totally overwritten with her next keystroke. Has a... 6 12.03.2006 23:35:41 terminal services sharing user login How can I set up an Access FE on terminal services to allow multiple users to access without any disruptions to other users when the FE database is compacted on close. Is this possible or do I have to remove the compact on close statement? Thanks, Karen -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-multiuser/200603/1... 5 11.03.2006 01:30:35 Upgrade? Hello All I have spent considerable time looking into the question of whether or not to upgrade my A97 application to A2003, and have found a lot of information on the web. Unfortunately a lot of it seems to be contradictory, and much of it is over my head (I am a competent amateur, not a prefessional). I would be extremely grateful if someone could put into SIMPLE terms ( and I realise... 7 10.03.2006 09:40:02 BECOME A DOT.COM MILLIONAIRE WITH ONLY $5.99Cents or $1K. ... 1 09.03.2006 20:43:07 Code to Choose Multi/Single User Hello, I am currently working on an application that uses a license key (made up by me) to determine whether the user has rights for a single user or a multi-user license. I have split the database and would like to allow the user to put the BE on their server while their FE is on their workstation. The question is how I can keep the user from connecting to the BE with multiple FE on ... 5 09.03.2006 19:45:12 13 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13