Threads Replies Last Post 13 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13   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... 1 08.03.2006 01:39:53 Need to setup the database for multiusers This is my first database that I will need to share with multiusers from not only my department, but from another. The database for all users with the exception of myself & one or two others from my department will be "read-only". At the end of this month, I plan to "go live" & need to as part of that process to give desktop access to those users to the database. I need to know what pr... 2 09.03.2006 14:02:53 Setting up a Split DB We plan to split our ACCESS application into front end and back end so we can have a more reliable multi-user setup. Currently , we just have the unsplit application in the server so they can share it. We also have a copy of the same application for stand alone use of our data analyst which we update once a week (she does not really need realtime data in fact she can afford a once a wee... 2 08.03.2006 22:59:16 Synch Link I recently purchased a PowerBook G4 for travel and shortly thereafter realized I needed an iMac G5 for purposes of synchronizing the G5 for business & home use in order to stay fully. How do I configure the two to work/synch together, either while both being home yet in in remote locations (upstairs & downstairs) or while on the road? Thanks for any suggestions or assisstance you can provide.... 2 07.03.2006 22:46:43 Encrypting certain data Hi Using Access 2003. Split fe/be database (FE - .mde) and the database will have security login for each user My client requires the credit card number to be kept for a certain period of time but for that information to be encrypted. The user level which have low security access obviously would not be able to see this credit card information. The users with a high level of securit... 6 07.03.2006 22:04:25 Emailing multiple recipients Hi Using Acces 2003. FE/BE split, 3 users. I need to be able to create a datafile with the name and email address of the recipient. There will be anywhere up to 2000 records in the file. Q: How can I produce a personalised email to each of these recipients (using Outlook) without causing spamming problems / sending 2000 individual emails? I am open to any suggestions as to anothe... 5 07.03.2006 22:02:27 Securing DB with Workgroup File I have a database which is spilt into a front end and a back end. When I am building the Security Workgroup file, should I build one for the Front end and then build an identical one for the Back end? I am accessing the program through a Desktop shortcut which points to the Workgroup file. If I have a wrkgrp file for the front end and back end, which one should I point to in my shortc... 7 05.03.2006 23:10:29 Access 97 Performance Leak after Switching to W2K3 Fileserver Hi all, we use several Access97 Applications in a Multiuser Environment - after we migrated the Fileserver which was serving the Access-Databases from Novell to Windows 2003, the Users complained about bad Access Performance. That brings me to my Question: Is there a way to Tune a Windows 2003 Fileserver for Access Performance? Thanks for your Tips in Advance berni@berlin ... 2 04.03.2006 23:35:40 Different Versions of Access 2000 & 2003 I keep getting the error saying the database needs to be repaired, and get this 6-7 times per day We have 15 people who access the database over a network, 10 people using access 2000 and 5 people using access 2003 All users have admin privilages enabled and access the database through 1 file on a network can the different versions be the cause of this problem? if not what could this ... 2 02.03.2006 18:41:39 Interesting network/link problem All, I have a company intranet which uses a 2003 Access db as a backend, developed with Cold Fusion (purchased as an off-the-shelf intranet). It works fine. However I want to query one of the tables in the back end and run a report that users can access from a link. Here's my approach, which hasn't worked so far.... I have created a new access db and linked it to the relevant table i... 7 01.03.2006 21:10:51 EARN $3,000.00 A DAY. OPEN AN INCOME-DAILY ACCOUNT WITH US <HTML> <HEAD> <META NAME="GENERATOR" Content="Microsoft DHTML Editing Control"> <TITLE></TITLE> </HEAD> <BODY> <P>YOU COULD BE EARNING OVER $3K A DAY , $100K A MONTH.INCOME. CHECK IT OUT. Investment is only $5. 99cents a month.</P> <P><A href="http://www.vosar.net">www.vosar.net</A></P> <P>Tel: 775-333-11... 1 01.03.2006 07:13:20 Multiuser -record locking I mistakingly built a database with too many of the fields all in one table, which causes a problem because anytime more than one person is using the database there is a good chance they will be trying to update the same table because most of the forms are built off the same table. If I break this table down into smaller tables and link them (to the master) will it help with allowing users to... 3 01.03.2006 03:05:15 Microsoft Access Error accessing file. network connection May have been lost I created a database and it was working well untill recently. I tried to use a button and it began to give the error message "Error accessing file. network connection May have been lost ". Now, more buttons are dysfunctional. I don't know what is wrong and if it can be fixed. I need some help fast! ... 2 01.03.2006 00:34:59 Who is logged on? Hello All I am using A2K, and have used the code at http://support.microsoft.com/?id=198755 to find out who is logged on. 1) Rather that having to open the Immediate Window in the Visual Basic Editor and then typing ShowUserRosterMultipleUsers, is it possible to run this facility by clicking a button - what would be the OnClick event procedure? 2) Is it possible to get the list of... 5 28.02.2006 11:29:14 Real Estate - Free post Your ads about property for sale. Real Estate - Free post Your ads about property for sale. You can join for free and post your ads about property for sale or for rent. www.World-Estate.com ... 1 26.02.2006 17:01:08 New front end required all users to exit backend I have a split application where 12 or so users have a copy of the front end on their machines, all linked to the same back end. When a new version of the front end is distributed to each user, because of requirements changes or upgrades, it appears that I cannot link the newly installed front end to the back end as long as anyone else is in it (and there is a locking file in existence). Is... 5 24.02.2006 21:41:15 Permissions being erased I have a database with a front end and backend where I have set permissions on objects on the Group level (not user level). My general users group is called "CRTP". All table objects in this group have "Read Design", "Read Data", "Update Data", "Insert Data", and "Delete Data" permissions. When a user starts using the application, they get a message that says they do not have rights.... 2 23.02.2006 17:03:04 Auto FE Updater problem I recently set up Tony Toews Auto FE Updater on our network to distribute new FEs of an application I created for my church. Neat utility, and really like the way it works but I am having a couple of problems with it. I sent Tony some email directly about some of the problems, but another problem has cropped up and I thought I'd post here to see if anyone has any suggestions. There are abo... 6 23.02.2006 16:16:23 Opened Exclusively message I have a FE and BE using a Workgroup file for multiuser login. I have a procedure that gets called during the initial login which checks to see if there is a backup of the database. If not, it makes a backup. This procedure works great until it gets to the last step which uses the "DBEngine CompactDatabase" procedure. I have it set up to save the compacted database to a separate fold... 3 23.02.2006 15:40:33 Tsi synchronizer don't work with kaspersky antivirus personal hello everybody since I installed kaspersky antivirus personal, my TSI synchronizer does not work any more. if i unstalled kaspersky, it goes well. any idea? thanks Yann ... 4 20.02.2006 06:57:19 Trying to set up User accounts I have the Access 2002 Developer's Handbook, and I am trying to learn from the example provided in Chapter 2, but I am running into the following problem. I set an admin password and a username and password on the backend, then the following things happen: 1. If I open up the frontend on the same computer as the backend, I am prompted for the username and password. Which is what I ex... 2 19.02.2006 07:44:14 Multiple users working in file no longer allowed Since switching to Microsoft XP multiple users can no longer access the same file. Everyone can get in and run queries, however, if you try to create a new query you get the Unable to open File, File Already in Use error. I have checked security on the folder that the database is located in. I have given everyone full access to the folder. Individually each user can go in to the file ... 1 18.02.2006 00:47:27 Periodic "no exclusive access..." message I have a split database (FE on users' systems, BE on server) that occasionally, for no reason I can discern, gives a user the old "You do not have exclusive access..." message upon opening the database. I'm not using Access security, so I know the problem isn't related to a workgroup file. The problem doesn't happen consistently (that I've been able to tell), and it doesn't always happen... 3 17.02.2006 21:48:44 Relying on basic Excel functions in Access I have a multiuser Access 97 database. A references was set to Excel 8.0 to make certain functions available (left, mid, trim, etc). I am not truly automating Excel, simply using these functions. As the company undergoes upgrades, users are moving up to Office 2002 or 2003. They have been allowed to keep Access 97 until the database is approved for redesign and upgrade. The newer ve... 4 17.02.2006 21:17:28 VB 5 Program trying to utilize Record Locking (.LDB) with MS Access I have a program that was developed originally for single-user use and we are now trying to modify it to allow multi-user. We need to be able to perform record locking, and everything that we have read would indicate that the .LDB file will take care of that automatically (with the proper parameters set for the .MDB). However, when we open the MS Access file from within the Visual Basi... 3 17.02.2006 20:33:10 13 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13