Threads Replies Last Post 13 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13   THE > SUPER-MONEY-SOURCE < THE > SUPER-MONEY-SOURCE < This special program is acquire copyrighting-protected, only with the participation you the copyrighting at this program. Prohibited utilization leads to the notice! THE > SUPER-MONEY-SOURCE < In this program, there is really money. 1200.- Euro / dollar and MORE are in only 3 weeks possible with only 5 participants!! Example, you get Euro o... 1 22.12.2005 17:14:16 multi user and security/mdw help! I'm currently setting up a multiuser app, and will be splitting into fe/be. I will be deploying the f/e as an mde runtime version Do I need to add the users to the system.mdw and/or setup the security file? My main concern is that everyone will be logged into Jet as Admin, if I don't. I hadn't really wanted to get involved with the security settings, but now wonder if this would cause ... 40 22.12.2005 16:23:54 VBA corrupt, how can I fix this? Hi Using A2003 and client machines also using the same versions I compile on my development machine a .mde to distribute on the FE on clients machines (3 users). One of the user's machines just will not take the compiled .mde. I have to put a .mdb on her machine, recompile, then make an .mde on her machine for it to work. I have tried reinstalling Access, tried re-registering the .... 5 16.12.2005 09:38:34 Cannot Open Access over VPN: very strange behavior Hi all, I face a very strange problem, when opening a MS Access database over a VPN tunnel. The database reacts weirdly to users' opening requests: 1)-Users who are on the Internal LAN can open the database. 2)-VPN users cannot access the database, if the database has already been opened on the LAN 3)-VPN users can open instead the database, if the database has not been opened by any c... 19 15.12.2005 21:58:42 Convert from English to French on the fly. HI, I've designed a very complex database (60 tables x 550 fields x about 150 relationships) and have come up against a huge obstacle. The database is curently designed completely in English but my customer is in Quebec and so it needs to be bilingual. How in the world can I convert everything structure and data to be in both languages. Super Simple Examples is in English we say Mr. o... 3 14.12.2005 01:20:02 Desperately need a response Didn't want to post the same message, so please search for "Update table while users are log" I just need to be pointed in the right direction, can someone help? Pleeease..... 2 11.12.2005 03:53:22 how can i tell in code if a record is locked We have a form whose record locks is set to edited record. If another user tries to open a record while another user has it locked I want to detect that and prevent the record being opened by the second user. ... 5 10.12.2005 19:32:00 XP SvcPk2, Access2002 SvcPk3 Have an application with front-end in one mdb file linked to another data mdb file. On one Dell machine, everything opens fine through Explorer and if Access is opened and one uses file menu - open file. Got a new lease shipment and on the new machines, running same OS and same SvcPk, opening the mdb by double-clicking on the file through Explorer doesn't work - says Microsoft Access c... 2 09.12.2005 10:14:53 Update table while users are logged on I have a small dbase shared between 10 users. We receive a daily flat file that needs to be appended to the main table. The problem is, this file comes in the middle of the day....updating with the users logged out takes less than a minute, if they're logged on, forever. What's the best approach? (pls don't laugh) Currently all users are asked to log out, updates are performed, they'... 2 09.12.2005 03:25:32 can't replicate from original database i have user a user b and user c i have one database with 3 replicas user a can go into original and replicate user b can go into original and replicate user c cannot go into original and replicate; option to replicate is not available user c can replicate when opening one of the replicas any ideas why user c cannot replicate from original? running access 2003 ... 1 07.12.2005 20:47:08 Who has the latest version? Hi Using Access 2003 and my client will have a FE/BE setup for their office machine. The other person in the office has a laptop and will be out on the road. Both will be entering information into the database, doing numerous activies. How can I 'synchronise' the data when the laptop user comes back into the office to work out who has the latest version of each record in each table... 3 07.12.2005 05:45:43 Re: database too slow Note that the de-compile should be done on the a2000 box that will create the mde..... -- Albert D. Kallal (Access MVP) Edmonton, Alberta Canada pleaseNOOSpamKallal@msn.com http://www.members.shaw.ca/AlbertKallal ... 3 07.12.2005 01:34:40 Message to multiusers to log off Hi I have split my database as suggested on this group. I want to be able to send a message to my users to log off in case I need to update. I will try to keep this to out of hours but we can be 24hours manned and users are in many different offices. I tried a message macro and assigned a shortcut key but in only shows the message on my machine. Any help would be appriciated. ch... 2 06.12.2005 23:08:42 Error Assigning Value to a Checkbox Control There are two checkbox controls that I use on the billing form of my app, and I need to assign their value based on the response I get from the user in a messagebox. But when I try to programmatically assign the value using Access 2000 VB, I get an error 2448 "Cannot assign a value to this object". The app is Access 2000 front-end/back-end. The back-end database is on a SQL server, if t... 9 06.12.2005 17:43:52 Problems opening database Hi all I was having problems opening a split database in an Access 2000 / Windows 2000 environment. (Please see my previous post http://www.accessmonster.com/Uwe/Forum.aspx/access-multiuser/2207/New-user-can-t-find-the-database for details). I originally thought this had to do with the workgroup file but now i think it is a different problem. If a place a shortcut to the database fr... 1 06.12.2005 15:52:08 Best Method to Share Charts on an Office Network ? I'm learning Access as I go and am currently in the process of creating various charts with Access 2002. The charts are created using INSERT / FORM then selecing the Chart Wizard (not the Pivotchart). The charts get data from various Queries. Those queries are of Linked Tables. The charts all seem to be working fine on my PC. What is the best way to share these charts with others on t... 1 05.12.2005 19:25:28 Problem saving changes to table field on Server Using Access97 We have our data mdb on a server with users with their own FE MDE on their local PCs. An issue we have is that we cannot make a change to a data.mdb table field (say increasing the length of a text field from 10 to 15) using the server. After making the change we attempt to compact the mdb, but the compact is unsuccessful and the data files is corrupted. Yet we can ma... 2 04.12.2005 06:34:00 Records unexpectedly locked (ADO/Jet) I'm finding record access unexpectedly locked in my VB 6 / ADO 2.9 /Jet OLEDB 4.0 Provider environment. I think I've isolated the problem, but I'm looking for a solution. Very simplified, I have two tables. (Access has been set to use row-level locks, and pessimistic locking has been used in the app.) tblMember: Id, Name, fkState tblState: Id, Abbr User 1 selects Member data for ... 20 03.12.2005 03:59:20 Multiuser app. using access..Urgent Hello Experts, Pl. help me in designing a small application..This app. is to be used by 12 users. We need an application to log time spent by the team in office.so this is a time sheet system. I know how to design a table, a form etc..My question is how can many users share the same database? Let us say that on my computer I have created the database as db1.mdb. (it has a... 4 03.12.2005 03:59:15 New user can't find the database I have an unsecured database, split into front and back ends which i recently created. I have placed the back end in a LAN server and the front end locally in each PC (about 10 PC's). The program works great if each user uses only their computer. However, we do not have assigned stations at work so any user can be on any computer at any time. The problem i have is that when one user move... 3 02.12.2005 20:08:51 Access 2003 & Citrix Prevent User fm Opening 2nd Session Using Access 2003 and Citrix Presentation Server 4.0 - we have had problems with users opening 2 sessions of our Access application. When the user clicks on the Access app icon is there a way to either prevent a user from opening a 2nd session, or to simply open the first session if one is already open. Many thanks, Mike Thomas ... 4 02.12.2005 12:45:27 database too slow I have a MS Access 2003 Database in Windows XP, split, front and back ends, back end on server, front end on users' machines. The problem is that on some machines, it's too slow. All our machines use Windows XP. I have carefully worked through the Microsoft Access Performance FAQ at http://www.granite.ab.ca/access/performancefaq.htm and that did help. One form speeded up from 49 secs. ... 9 01.12.2005 17:42:27 Record Locking Schemes? I've read around here and there about record locking and have come up with kind of an incomplete mixed bag of results. A particular app I'm working on is more prone to concurrent record editing contention than most I've done. Here are some bits of info an experience that I'd be glad to hear comments on. This is jet all the way, as secured as Access can be, Access 2000 soon-to-be Access 2... 9 29.11.2005 08:09:09 Deleted mdb file when multiple users compact & repair We have an access application which is split into a front & back end file & resides on a single PC. 4 other PCs access the app through a peer to peer connection. We have created the app so that Access is automatically set to compact & repair whenever the app is closed on any of the machines. The problem is that when the app is closed on all machines at the same time, the app can't com... 2 29.11.2005 02:41:39 Is it safe to take a copy of an open MDB data file? Using A97 on a LAN. Our backups usually occur at night when there is no activity with the data mdb. Occasionally we may have a user leave their front end mde open to the back end mdb, but no issues. Recently we have been experiencing data corruption issues with the data mdb. After a few years of relatively trouble-free operation we are getting a corrupted data mdb during the business d... 3 28.11.2005 01:21:48 13 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13