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   Database Window I have a database split into a FE and a BE. Everything is fine except this morning the database window has started showing up on some of the users computers. This is strange bacuse I have the database window set to not show. Does anyone know how this could happen or how to fix this?... 4 5/2/2007 9:16:32 AM One user slow I have an access database on a network that many people use. For most people it is quite slow due to it's design, but for one person in particular, it is painfully slow. Their computer seems like everyone elses, but like I said - very slow access. Any clues as to what I can do ? Rohan. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-mul... 8 5/1/2007 4:37:02 AM Does the BE version significantly affect performance? I have a multi user app with an A2K BE (ca. 90MB and growing by the day, around 15-20MB per year) and A2K3 FE (local to users' PC's, usually up to 10 concurrent users). The app is a few years old, which explains the BE version. At a time I had a mixed environment of A2K and A2K3 FE's, but now all my users are on A2K3, so in theory I could convert the BE to A2K3 as well. My question is, i... 4 5/1/2007 3:52:42 AM any multi-user limitations We currently have an access front-end and access back-end database to allow multiple users access. The database is extremely complicated with many linked tables and lots of forms. Realistically what is the total number of users over a 100 Base T network and VPN? Any limitations? Would web enabled add any users or reduce? These users would be adding, modifying and deleting records. At ... 3 4/28/2007 4:52:11 AM Changes History (Log) Hello, Is it possible to retrieve information about inserted, deleted or updated records in an MS Access database from system tables? In other words, to read and interpret the transaction log. I am not able to change the database structure and there is no current logging mechanism, but I need to detect the changes made by any other client. Thank you. ... 4 4/28/2007 4:43:49 AM FE Updater and Novell Tony, thanks so much for your FE Updater software, and the continued support /development of it. It has certainly proved very useful/helpful to me! There is some info I have been meaning to pass on to you, which may also be of interest to others who develop Access apps that are run from Novell servers. When I first set up your utility about a year ago, we almost immediately begin havi... 2 4/28/2007 3:19:30 AM Access app & Vista Hi, I've developed a front end/back end access application for access xp & 2003. It needs to be available to all users on the PC I would prefer not to have it in the common doc.s area as it becomes visible over the network. What is the recommended way of structuring & assigning permissions for this application (I want to keep the backebnd in a separate folder to the front end)? T... 25 4/27/2007 6:22:45 PM Customize Menubar Problem I have an Access 2003 database on a server in a Windows XP environment. It has security implemented. It's an mdb file no front-end, back-end segregation. I removed the Insert Hyperlink choice from the Insert submenu (using Tools, Customize) because I don't want users inserting hyperlinks directly (I programmed a custom routine for that). The problem is that while the Insert Hyperlin... 2 4/27/2007 1:54:00 PM Size limitations Hi We have an MIS developed in Access. We have one Db for the data which sites on our server, and another with the front end and codes etc which sit on users local drive. We have 5 users max accessing the data We currently have 57Mb of data in the DB and its likely to go up to about 80Mb . Are we getting to the point where we should be changing to SQL or will Access handle db's of... 7 4/26/2007 9:45:26 PM DAO error with FE Auto Update I have been able to use Tony's Front End auto update program without any problems, except on one computer. The error I get is : _______________________________________________________ DAO version 2.0 was not found on this system. Note that DAO version does not necessarily match the Jet version. -------------------------------------------------------------------------------- Auto FE Upda... 5 4/25/2007 3:00:11 AM No data is a Query Function Hi Guys, I just started studying about Access project, I installed MSDE because I am not connected to a SQL Server, I am practicing at home, I am creating a query (Function) following the instructions of a book and I am working with the sample project supplied by the book, I already check that there is data in the tables, the problem is that when I try to see the query result there is ... 1 4/23/2007 11:22:02 PM Suppress by an other user Hi everyone, I'll try to do short with a long story!!! I'm working Access 2000 simple application running on a small local network, 3 machines. Every thing was doing well since a few mount where suddenly the systems begin to crash. I was getting the error message (excuse the translation). The record have been deleted by an other user!!! This was coming from a refr... 1 4/23/2007 1:49:06 PM Multi User application and viewing changing data question Hi All, I am working on a procurement system that will be used by about 5 - 10 users (initailly). The database is split, in that the front end is Access 2003, the backend is Oracle 9i, tables are linked. Now I have come up against something I'm not 100% sure how to handle. As there can be more than one person procuring items at the same time, how do I ensure that an item selected for pr... 7 4/20/2007 8:20:07 PM Relationships went away on split I have a database that I decided to split. Everyting is working fine, but a few days after the split I went to add some new relationships, but every one of the 52 relationships I already had built are gone. Is this normal? Do relationships delete if you split a database?... 5 4/18/2007 6:03:57 PM Better design, more corruption? Situation - The BAD: About 7 years ago I wrote an Access 2000 database for my employer. It was not split, being used on @ 25 computers. Due to users NOT having the same permissions on the folder where the database was located, I was rarely able to do compact and repairs (the ldb file never deleted), Only when a "database corruption error" occurred, could I call our IT dept, and have everyo... 14 4/17/2007 4:57:44 PM detect locked record When locking is set to edited record, the second user to access a record is unable to enter any data. I'm looking for a way to detect that this is happening and send an explanatory message to the user. It seems to me that there must be an event that I can capture. I've tried the following: Private Sub Form_KeyUp(KeyCode As Integer, Shift As Integer) If Not Me.Dirty Then MsgBox "This rec... 2 4/17/2007 4:53:16 PM deadminer Hi Dom,... 1 4/14/2007 5:08:52 PM Major bug in Vista File Sharing (Peer-to-Peer) http://forums.microsoft.com/msdn/showpost.aspx?postid=1259708&siteid=1&sb=0&d=1&at=7&ft=11&tf=0&pageid=1 This appears to be a problem with the new SMB2 protocol developed for Windows Vista. For a brief description of what SMB2 is, See: http://wiki.ethereal.com/SMB2 Disabling SMB2 on the machine that hosts the share seems to solve the problem. Share works fine when a Windows XP machin... 6 4/13/2007 7:53:55 PM °ü×°²ÄÁÏ http://www.gz-oc.com/intro.htm ... 1 4/13/2007 5:53:50 AM Ensure User Launches from Local Front End RE: Access 2003 My application has been split and the front end runs on client PCs with the back end on a LAN file server. Also I have an updater routine that copies an updated client from the LAN file server to the client PCs when needed. I keep the client front end on the LAN server for distribution purposes. The problem is that occasionally, user's get confused and go to the LAN fi... 11 4/11/2007 2:15:20 AM Auto FE Updater from Tony Towes Does anyone know how to set the Shortcut Error Message Handling option for Tony Towes' Auto FE Updater? The program is great. The only problem I've had is getting this option to take effect. Looking at http://www.granite.ab.ca/access/autofe/inifile.htm, the instructions say: ------------------------------------------ Shortcut Error Message Handling - (Optional) 2 - Correct p... 6 4/2/2007 7:32:55 PM Can' I have an access 2002 database. I use a form to display records basing resultset = SQLstr$. The form essentially displays records for a given user on a specific week. Each time the user changes a week date, the SQLstr$ changes and the new set of records are displayed. The form has an edit button that opens an unbound form (frmSelectProject) to collect edits for a record. After the i... 3 3/30/2007 7:28:03 PM Can't open Access Database I have finished a new input form that has recordsource equal to an SQL string that retirves records for one week for one user. The form locks the record being edited. In testing, quickly edit a record 3 or 5 times and then exit the database (File, Exit). Then the .ldb file stays on. If I press ALT+Tab I see that Access icon as as one of the running programs. I select the icon but I ... 3 3/28/2007 8:56:09 PM Second user can open his frontend, but can't link to backend unless first user close his frontend. Access 2003 and Windows Vista Business Hi everybody, New computers running on Windows Vista Business. Office 2003 SP1 MSJET40.dll version 4.00.9635.0 Backend on server. Frontend on local drive. Second user can open his frontend, but can't link to backend unless first user close his frontend. If first user don't close frontend, and second user try to close Access, computer lock ! Hard reboot necessary. Can you help me ? Any... 8 3/28/2007 1:38:39 PM Cannot share Access Database or any other file on Vista http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1267567&SiteID=1 ... 1 3/28/2007 12:30:28 PM 19 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19