Threads Replies Last Post 19 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19   FrontEnd on server and record-level locking Hello Everyone Please accept my apologies if I've posted to the wrong section - just move me along if necessary. I'm helping someone to improve a small, unsecured Access 2003 database for his company. For years they have used just a single table, and the consistency of data entry in the table was sad to see. The new db will use only four tables with non-cascading enforced referential re... 10 1/1/2009 7:18:02 AM Guaranteed Millionaires http://guaranteedmillionaires.blogspot.com/... 1 12/31/2008 10:09:44 PM Attached tables & performance question From a performance standpoint, does it make any sense to "delete" infrequently used attached tables and only reattach them using code if they are needed for a specific form or function? My commercial application is quite large and has over 45 attached tables and it takes sometime to initially open on some of my client's systems running over a LAN. The application is split properly between ... 8 12/23/2008 2:59:04 AM Access Query with SQL Server Query Dear Sir, Can any one tell me where I can find the list of commands and function of JET SQL not supported in SQL Server 2005 Query. Sanjay Shah ... 3 12/18/2008 2:08:06 PM Network Connection In A Split End Database Is Constantly Interrupted Hi, I have a split database with about 60 front end users and today I have had users get messages stating constantly that their network connection is interrupted. I have spoke with my IT department and our switches have not been having any problems today. What else could cause an interruption in the database connection to the network?... 6 12/14/2008 4:21:20 AM Access 2007 replacement for mslldbusr? We have an application (VB frontend, Access 2000 backend) that we are considering moving to Access 2007. One question for which I haven't found an answer - is there an Access 2007 version of msldbusr.dll. Currently we call a method from this library (LDBUser_GetUsers) to see how many users are logged on to the database when any user opens the application. We are using DAO 3.6 in the current v... 5 12/8/2008 6:27:54 PM Error 3218 I have a FE/BE multiuser database. BE is on the network, a copy of the FE is on each users PC. The database options are set for default no locks with record level locking checked. I have a form in the FE for adding records to a table linked from the BE. The record source for the form is the linked table, not a query. I have set the form properties to no locks, to not allow edits or ... 8 12/7/2008 2:13:36 AM Record Locking After much searching for an answer, I thought I would post this question in the hope someone will lead this old horse to the water. I am using Access 2003 runtime for distribution. I have a BE MDB with FE MDE on over a dozen workstations. Each workstation is scanning bar codes and updating two tables. One field in MASTER is updated at each scan (incrementing the value of that field with th... 7 11/29/2008 12:43:15 AM Creating 10 Different Users For A Database Application Hello all, I have spent the last two weeks (baptism by fire) designing an access database and I am now at the point where I want to define about 10 different users that can access it. I don't have any idea how to do this. I will have certain options disabled for most users as well as certain forms. I imagine I will have to do something with a module. I am really familiar with Excel codi... 3 11/11/2008 2:55:43 PM If two users click on same time - Multiuser I have different teams ( say TeamA , TeamB , TeamC ) , each team need separate sequential Work Order Numbers ( if work order is created by TeamA member it should see the last order number and add one to it ) tblCurrentMaxIDFmly contains the last Id number used by the team and this is updated every time if Work order is created RnDGroup CurrentMaxID TeamA ... 4 11/2/2008 2:39:21 AM "Un-Splitting" a Database All, Back when I knew less about Access than I do now (which isn't saying much if I'm being honest), I asked for help from our company's IT staff to support multiple users from a network shared drive. However, the IT "experts" decided the solution was to split the database and then put both the back end AND front end on the server and use a third file on the server, a .mdw, to control use... 11 10/27/2008 8:54:41 AM Linking to SQL Server I have an application written in Access 2000 using linked tables to SQL Server 2000. The Access database sits on a fileserver where it is used by 10- 15 users. All users have the same ODBC DSN on their PC's and the linked tables work well - with all users using the same SQL Server logon. However, I would like to implement SQL Server security and give each user their own SQL logon. I like ... 11 6/29/2007 7:04:55 PM Error when relinking MS Access 2003 FE/BE configuration. I get the following message when trying to relink new FE to existing BE at my client's site, but not on my development computer: "The expression On Click you entered as the event property setting produced the following error: Object or Class does not support the set of events" Is this a possible reference issue? Thanks Don ... 5 6/29/2007 3:16:53 PM Relinking code and user-level security I have a split database with user-level security. I am using code to refresh the links to the back end tables. Since I am not offering users the option of navigating to the correct file to reset the links if there is a problem (the users cannot be counted on to do this), I am using a simpler version of the code than was at the MVP site. It is in a standard module, and is as follows (e... 3 6/28/2007 7:40:19 PM FE Updater with user level security I have been working on getting Tony Toews' AutoFE Updater to work. I have split the database successfully, and have implemented user-level sucurity. There are a few things about the Updater and its documentation I do not understand. I do not have any effective control over the macro security level at the individual workstations. The documentation says there may be some problems with... 6 6/28/2007 6:15:57 PM Linking to a password protected BE Hi, I'd like to be able to programatically set up a link to a .mdb file with a password on it (password set using tools/security/set password). Is this possible, if so how? Thanks if you can help ... 2 6/28/2007 2:05:47 AM Best approach for multi-user on Citrix?? Hello, I have an Access 2003 database that's going to be used by about 6 users. The database will be secured with 2 user groups and 6 users and the usual shortcut pointing to the database and the .mdw file. The users are all thin clients on a Citrix network. I've been reading a lot about the need to split the database in order to reduce network traffic and simplify FE modifications... 7 6/27/2007 3:24:01 PM Multi-User Mystery We have a split multi-user DB, BE on server, FE on each user's PC. (Access 2003 running on Windows XP.) From time to time we have to pull a copy of the BE off-line, tinker with it, then write it back to the server. We have a timer event built into the FE so we can throw everybody out by creating a trigger file on the server; the FE "pulses" the server every 10 seconds or so, and if it... 5 6/27/2007 1:10:06 PM Can I disable the X Close button in the database window? Hi, I have a report in an Access database that takes a couple of minutes to run. I added a status bar showing the report progress based on the number of records in the data source, but the users freak out and hit the X Close button on the database window because they think it's hung up. Is there any way to disable that button and still show the status bar? -- Thanks, Jeff... 9 6/27/2007 8:26:33 AM Read only front end Are there any gotchas with making a front end read only by the simple means of setting the Read Only attribute on the .mdb file? Not thinking of any security measures here, it would just seem an easy way of avoiding FE bloat and easily checking what version of it one has and not having it constantly picked up by file synchronizers, incremental backups, etc ('cos the modified date on the... 9 6/26/2007 6:22:24 PM Wireless and Access I have a access mde front end deployed over citrix with a mdb be on a file server. This application is used in various operating rooms in our hospital. I'd like user's to be able to access the application (via citrix) over a wireless LAN as the nurses who enter data in the app during procedurec would like to do so on mobile workstations (rolling carts). Using a wireless LAN with a wirelss rou... 11 6/26/2007 6:22:08 PM compact repair how can i compact and repair an BE database using FE application?... 2 6/26/2007 6:21:49 PM Why "unable to make MDE file"? Hi, I'm just learning about splitting an Access database for a multi-user environment. I went through the process using the database splitter and everything works fine with the FE on my local desktop and the BE on a network file server. I read that the next thing to do is to save the FE as an MDE file and distribute that to the users. But, when I click Make MDE file..., I get an er... 5 6/26/2007 6:21:42 PM Only one user at time can open access file We have an access file (.mdb) in a shared folder on the windows 2003 server. Every user can access the file from the path "K:\Customer\Cust.mdb". Our problem is that only one user at time is able to have the file open. Cust.mdb starts ok for the first user, but when the second user tries to double click the file nothing happens. It workes this way whoever person is the first or second us... 3 6/26/2007 6:20:57 PM Can database work in multiuser I will place the database in a local drive where everyone can access the same database.. However, can they work when someone is using the database? -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-multiuser/200706/1 ... 3 6/26/2007 11:08:58 AM 19 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19