Threads Replies Last Post 13 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13   network speed hi! i have four computers connected to a D-Link 4-port router that also acts as a DCHP server. the problem is that the three computers are doing 100 mbps while the fourth computer can only do 10 mbps. If i force the forth computer to do 100 mbps, it can't communicate with the routher and can't be detected by the other computers . All of the computers are of the same brand and configuration... 3 06.07.2006 03:32:41 Recordset adLockReadOnly but still "currently locked by another user" ! Hello groups ! In a vbs script, I connect to an Access 2000 database and open a recordset for in readonly mode : Dim oConn Dim oRS Set oConn = CreateObject("ADODB.Connection") Set oRS= CreateObject("ADODB.RecordSet") oConn.Provider = "Microsoft.Jet.OLEDB.4.0" oConn.Open "Data Source=M:\mydb.mdb;User ID=myuser;Password=mypassword;Persist Security Info=True;Jet OLEDB:System databa... 1 27.07.2006 07:37:09 Users are getting "Database has been placed in a state by user 'Admin'... on machine 'XXXX' that prevents it from being opened or locked." in a VBA application. I have had multiple users (everyone runs Windows XP) in MN connecting to an access database on the MN file server (running Windows Server 2003) for several years without and database locking issues. This week we brought on our TX facility (they are on a different domain than MN). TX users connect ove... 6 25.07.2006 16:01:49 Re: Table Lock in Multi User Access We have FE copies on users desktop which links to tables on the server database. The form is pointing to a table and multiple users are running that same form at same time. The access database is 2003 format. When one person is adding a record in that table, and another person tries to add new record, it says table is currently locked by first user. There are three users most of time is same ... 1 25.07.2006 14:07:33 Internet Market Secret Reveal !!!! How To Get 1 Million Visitors On Your Web Site Without Paying A Dime In advertising ! Are you frustrated by the lack of traffic coming to your site? If I would tell you that after months of research, I just got my hands on the most hidden secrets... very sneaky tricks ! Click here : http://thegloballink.biz/news-moneyhome.html Hurry, before the page gets banned! ... 1 24.07.2006 07:19:14 Relink Access tables from code My mdb fe links to multiple back end mdb files - the recommended code from The Access Web works but only lets me select one location and then tells me a particular table (from a different back end) doesnt exist. How can I select multiple back ends one after the other (if that makes sense). I used the code from http://www.mvps.org/access/tables/tbl0009.htm to open the SaveOpen Dialogue ... 4 23.07.2006 09:26:01 Split Databases - Best Practices? I'm starting this thread to pull together related questions and to check my understanding. Please debate apparent misconceptions. Do you agree that these are best practices? 1. Use JET OLE DB when connecting to BackEnd (BE) MDB file. Reason - thread safety. a. ODBC Table Links should be updated using DNS-less code like: adoTbl.Properties("Jet OLEDB:Link Datasource") = strP... 36 23.07.2006 06:53:18 Need to have multiusers update the database at the same time hi all, thanks everyone for the help in the past, i really appreciate that. Now i have a new problem and help would be really appreciated. I have a small network based on 4 computers. I have the main Database on the server. I have all 4 computers connected to the database and they all can update the data at the same time. I do NOT want to split the database. Problem started when i upgrade d... 4 22.07.2006 07:46:03 Could not lock file. (Error 3050) = Please help! Gentlemen - I have a problem with one of our databases. I would like to have one person able to modify the database and every body else should only have read access to the database. The problem is when the person who has full access is in the database nobody is able to view the database at all. The error we are getting is "Could not lock file". This has to do with the inability to ... 3 20.07.2006 21:22:02 public function CurrentUser I need user security without installing then internal user_level security. In the book: Access Cookbook by K Getz et al. they suggest to creat your own pub function. Can anybody write a simple code for changing the CurrentUser with the NetworkUserName so I can use it in all forms. TIA -- Best regards CA Brandt... 4 20.07.2006 15:31:38 test ... 1 17.07.2006 15:11:03 Database Bloating I have a multi user database that goes exponetially when it is use. It is a split database. Each user has their own deont end. However you can literally 'watch' it grow when I have twelve users in it at the same time ... 2 17.07.2006 05:26:24 Newbie: 2 MDB multiuser application I need to create a multi user application. I want to split the MDB into two. At the user's C Drive will be the front end. On the server will be the back end database. I want to do this application in ADO. Is there a web page or book that shows how to do this? ... 2 16.07.2006 22:03:17 Can't add new users or groups I create a new MDW file, then logged in and created a new database and added a super user. Then I removed all the permissions from the admin and user. Know when I go back to the serurity I can't add any user and the group tab is missing. How can I get this back. Thanks Mike P ... 3 13.07.2006 11:00:35 Help please.. I am a noob.. I want to have my database shared in a network (maximum number of users are 3) .. But i dant know how to build it. Considering the references I have read and about the limited users only, then I want to have it not splitted i guess. Thank you in advance for the helps. -- - thx - Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-multiuser/200607... 2 13.07.2006 10:58:11 Access on TS Server 2003 I have an Access ADP deployed on Citrix to a number of servers. When the app is opened by the first user everything is OK. Subsequent users receive a message stating tat the file will be opened read only. The message appears whether the users are on the same physical server or not, indicationg that this is a Windows Server 2003 disk access/security problem. Also, it doesn't matter wh... 2 10.07.2006 10:37:01 ...a state that prevents it from being opened or locked... Hello, We have a database on a network drive used by 6 people. At the moment, when anyone tries to open it, they receive the error message: "The database has been placed in a state by 'Admin' on machine '<computername>' that prevents it from being opened or locked." Here's the quandry. The person who works on the computer named in the error message is at lunch, and the PC is lock... 6 02.07.2006 11:07:35 Error using 'Row Source Type' table/query with RWOP query In an Access multi user application I am able to read and update backend db tables fine using RWOP queries. One table (TABLE A) in the backend db uses the Combo Box, RowSourceType = Table/Query settings or some fields so they display drop downs on input forms. In the client app form these Combo Box values will only show up if I copy the 'sub-tables' that are the RowSource tables, into th... 4 01.07.2006 01:39:07 Can't access shared database when open by another user I installed IE7 Beta 2, found it too buggy for my system and uninstalled it promptly. Maybe it is a coincidence, but since then I cannot open a database in a shared folder on another computer in my workgroup if someone else has it open. If the other users exit, I can open it. I can also open another database in the same folder. I just can't open one that anyone else is in. Strangely, ... 3 30.06.2006 16:07:02 How to get unique next number from table field? Hello, Multiusers use access database. I need to get next field number (ID), and must avoid using AutoNumber. How to get next value (DMAX or something), but to protect users, from getting same next value? Any trick, or I have to design MultiTier application? Thanks Milan... 4 30.06.2006 02:29:20 Amigos.com Amigos.com http://amigos.com/go/g671669 ... 1 24.06.2006 19:37:58 database won't open I have built an Access database that is located on a network drive at my company. The database is accessed by as many as 7 people at any given point in time (although there is never really more than 2 or 3 on it at the same time). It has been in use for 2 months now with absolutely no problems. However, today I try to open the file and when I click on the icon, an Access window opens, but... 3 22.06.2006 20:05:59 Poo Poo!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! !!!!!!!! ... 1 22.06.2006 02:31:51 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 two different forms, the second person gets a DISK ERROR mes... 8 19.06.2006 05:30:37 salud al 100% hola no se si sea este el lugar correcto para lo que les voy a decir: la verdad eso de los negocios yo crei que no era para mi , no no es lo que estan pensando no se trata de mandar los seis dolares atantas personas. No no se trata de eso. Miren yo soy un distribuidor independiente de una compania que para mi vale mucho, he aprendido muchas cosas y tambien he conocido un poco mas a la g... 1 15.06.2006 23:36:01 13 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13