Threads Replies Last Post 13 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13   multiple users writing records to the same table at the same time Hi, I am working as part of a team which has an Access 2003 application, whereby 3 or 4 users could be simultaneously running processes which write large numbers of records to a single log table. Because of the nature of the process, each record is written individually in VBA, rather than using a SQL transaction. Each process opens and closes the log recordset several times during the... 8 14.06.2006 23:24:06 cannot open database due to error 3197 We have a multiuser database that seems to have become corrupted. Attempts to open the database fail and return an 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. (Error 3197)" However, there is currently nobody using the database at all. This database is in Access 2003 on a Windows XP c... 2 14.06.2006 22:24:50 Split Database Setup Hello, I have a database that was created in Access 2000. I would like to distribute this as a split database application, but am unsure of how to do it. I haven't found much information, with the exception of this: http://support.microsoft.com/kb/q162522/ I have the database split into a front end and a back end. The part I'm stuck at is creating the setup files. The backend wi... 2 14.06.2006 04:07:56 MS Access 2002 running on MS Office 2003 Professional I have an Access 2002 database on a network server that allows multiple people to enter the dB. However, if both attempt to update data simultaneously, a 'disk or network error ' message pops up and the data are lost. I have checked the cabling and the network card and all appear to be working fine. If I run this same dB on another network that is running Windows 2000, the error does not o... 2 14.06.2006 04:06:59 Table locked Coul i determine which user or computer locked a table? L. ... 15 09.06.2006 11:52:49 Disk Error A client wanted to place an MS Access 2000 database in a folder on her C: drive and then share the folder on her c: drive out to certain users using a local network setup. Those certain users all have Full Control (through the shared folder). However, if more than one person attempts to add new data to the table or to access to different forms, the second person gets a DISK ERROR message an... 1 08.06.2006 22:32:45 Connections in ADO Hi, I need help with setting up a 'dummy' connection. I'm developing an application that will be used by a field of remote users eventually, I have a parameter query setup in a class module that I want to test, however it is looking for the connection criteria. The app is currently set up as single user, so there is no database other than the one I am currently working in to connect to. ... 4 07.06.2006 21:48:01 Locking records in multiuser environments Hi. What is the recommended way to lock files/records for an Access 2003 DB in a multi-user environment? If you can refer me to any documentation and samples, it would be great. Basically I want to correctly handle updates/queries to records in my programs for multiuser environment. I'm using Visual Studio .Net 2003 Pro, Visual Basic and C#. Thank you. ... 7 05.06.2006 15:34:02 Each user with the codes or with a shortcut of the codes? Our database is split : iftm and iftm_princip. The data (iftm_princip) are in the server and each user has the codes (iftm). I am thinking to put the codes (iftm) too in the server and make a shortcut of the codes (iftm) in each user. What would be the best? Thank you. ... 3 03.06.2006 14:17:32 Linking table to IN-USE back-end mdb ??? Hello All: I have a multi-user app with back-end, front -end using AC2002 runtime. I have code that checks on startup and if needed relinks tables. What are the issues with linking to a back-end that has other users connected? Will linking fail if another connected user has the table being linked opened for adding new records or editing? I have run a few tests and linking see... 3 30.05.2006 18:36:01 configuration or a different problem? To Access Heros, I deployed my new database this week complete with Access security, with the assistance of this user group. My problem is this: I assigned permissions in Access by group and not users. However, some of the users are having problems. 1) The user gets a "Report Action Cancelled" message when clicking on a button that opens that report. The user(s) is able to open the fo... 4 25.05.2006 17:58:27 Struggling to enable more than one user Hi, I've been struggling to get a db usable by more then one person. My last post on another Access ng is as follows: Does the database really have to be split? I only want two users to have simultaneous use. This is what I have done so far: - Checked security settings on the folder (2nd tab in the properties window), and confimed that the users have modify, read, write, execute permisi... 6 23.05.2006 21:48:17 Designing an interface - need serious help Greetings all. I've been asked by the engineering department at my place of work to redesign a database used to store information about schematics drawn over the past 60 years. I've created a table of approximately 17,700 records, including stored file paths to the scanned versions of the drawings here on our network. What I'm trying to duplicate is this. <a href="http://photobucket.com"... 6 23.05.2006 07:56:01 Reliability of Access (JET) Over a LAN? Hello, I'm looking to build a solution. It is a simple .NET app which will use a network shared JET database. The database will consist of a single table with a single field containing a telephony number. There will be 26 clients each of which will periodically query to see if a specific number is in the table (once a minute or so.) In addition, they will periodically use Access o... 13 18.05.2006 17:47:26 Problem withing multi user form I have a spit mulituser database. Two workstations, if one station enters a call and puts in a start time it should appear on both stations and it does. My problem is if the second station tries to close the call (buy entering stop time), they select the record in the list box to be edited and the very first record in the table appears to be edited instead of the record selected. If I cl... 1 18.05.2006 12:35:41 Can't open already open MDB files Over the weekend one of our servers was replaced. The files were copied from the old to the new. The same drive letter, e.g. Q drive, for mapping was used but the name of the server was changed. Initially there were no problems for Access database users. On Wednesday several problems began to appear. Some users have no problems opening and sharing the same database. Others cannot open... 2 18.05.2006 08:51:00 Split databases and ADO Cursors I've read that OLE DB is the best connection technology when working on a slow/unstable network because it is thread safe. I've also read that only ADO supports OLE DB, so I'm limiting myself to JET OLE DB and ADO. I'm having trouble understanding which cursors to use when developing for a split/file server environment (a local mdb linked to a remote mdb on a network share). Does a split... 9 18.05.2006 00:13:24 Recording user events Hi There I wonder if someone could help me please. I have a multi-user database application and I would like to record specific events within the database, especially the user that has initiated the event. At the moment I have a startup form that asks for the user to enter his/her name and it is this that I currently record against certain events. However this could be I'd like to... 9 17.05.2006 04:25:11 Need Help with Access Reports I am running into a very strange error while trying to rebuild my Access 97 frontend from Source Safe. It just started a couple of days ago and I have not been able to figure out what the cause is or how to fix it. Any help would be greatly appreciated. The error is output to an error.txt file on rebuld. Below is the error Error encountered at line 74. Expected: 'End'. Found: 0x00... 3 16.05.2006 15:01:02 24 24 owns all of you punk ass motherfucckers ... 1 16.05.2006 09:52:32 IF...THEN with SQL I'm writing a SELECT SQL statement and need to use an IF THEN statement in the select line. I have one field that selects Point Deductions and I want to create another field that says "IF Point Deduction is > 26, then PRINT "Fail" ELSE PRINT "PASS". I know its possible to have IF...THEN statements in a SELECT query, I just can't figure out the syntax.... 3 15.05.2006 11:50:02 Windows Installer appears ALL the time. I have no idea what Discussion Group to post this under, but since I'm an Access Developer I figured I'd start here. I'm new to this. After un-installing Visio 2003 from my PC the Windows Installer dialog now appears every time I start a new application. The Windows Installer Dialog does nothing but hang up my machine and thus I must cancel it three times before my application loads. ... 4 15.05.2006 01:40:03 database locked - but no users! Hi Again, Don't know if you can help with this but here goes. I've got an Access 2000 database that several users access. What I'm trying to do is to amend one of its reports but it won't let as it says i don't have exclusive access to the database. The thing is, I know for sure that no-one else is in it (i've checked every computer on our network). I've tried to delete the ldb file ... 3 10.05.2006 23:57:43 Cant share a database? I cant share a database with another user - the database is split and both ends are in the one network folder Both users have windows read/write permission on the folder and both parts (front & back) of the database are set to share (left at default) but when one user opens the front end the other user it locks the other user out any thoughts? ... 11 06.05.2006 00:39:01 unrecognized database format I recently split my Access 2000 database in order to make it easier to use in a multiuser setting, but one day after I did so, my users (who number only 5) began getting an "unrecognized database format error", because the backend had become corrupt. Each user is running a local frontend that connects to a backend MDB that resides on a Win 2003 server. I've restored the database from a cop... 1 05.05.2006 13:24:06 13 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13