Threads Replies Last Post 87 Pages: <<  17  18  19  20  21  22  23  24  25  26  27  28  29  30  31  32  33  34  35  36  37  38  39  40  41  42  43  44  45  46  >>   Copy linked tables How to automatically copy linked tables every 8 hours to another network location, if possible with changed name or in zip? Example: ----------- \\server\tables.mdb to \\server2\tables2.mdb Thanks!... 3 9/27/2006 1:24:02 PM Workgroup - back ups Hi, The previous person in my post created a database for the organisation to use which is secured using workgroups. I am now having to make some changes and trying to make a backup. The problem is that when I try to open the database exclusively I get an error message saying that I don't have the necessary permissions to use the (file location) object. I am instructed to have my syst... 4 9/26/2006 6:51:23 PM Ugh! Permissions dilema... Hello everyone. I'm using A02 on XP. DB is an old A97 that was converted up to A02. Have a user group with edit rights and they work fine on one form but not on another. I cannot figure it out! I've checked the permissions from the DB to tables to queries to forms. If I give someone in the group admin rights, all is well but I can't do that for everyday permissions. Just can't fig... 12 9/26/2006 6:47:31 PM Cannot double-click MS Access after running successfully. I copied an MS Access 2003 database from another computer to this computer and I am able to successfully launch the database once (with running database macros successfully). If I try to re-launch (double click) the same database after it closes, I receive the following error message: "Windows cannot access the specified device, path or file. You may not have the appropriate permissions... 1 9/26/2006 5:41:02 PM Moving to network drive I currently have an MDW file with a shortcut and security files. I have also split this database so that it has a front end. I need to move these to O:\Csg. How do i go about it and what do i need to move? Matt... 9 9/26/2006 2:32:42 PM cannot open access database on network but can open all else I am trying to open an access database located on a networked computer. I get the error message "Microsoft Access cannot open this file. This file is located outside yourintranet or on an untrusted site. Microsoft will not open the file due to potential security problems. To open the file copy it to your machine or to an accessible network location." I can copy the file across the n... 4 9/25/2006 9:57:01 AM Can i require password from operating system for mdb file to open? Can i limit an access mdb file to a given set of machines by loading into the machines a password that the mdb file looks for before opening so that it will not work on other machines? The idea is that a user would not be able to make a copy of the file and instal it on another machine.... 13 9/25/2006 7:36:47 AM MDW locks, cant add/modify users We have been using this database on terminal server for a long time, but recently had to move it to a different server. It used to run on Server 2000 with Access 2000. It is now running on Server 2003 EE with Access 2003. We converted the MDW and MDBs to 2002/2003. Since getting on the new server, the mdw constantly locks up, and we cannot make user changes (adding/removing/editing).... 8 9/24/2006 1:26:23 AM can use code to reference mde file? Does anyonw know how to use vba code from mdb to add or replace a reference to an mde file? Thanks in advance -- Jay... 6 9/23/2006 4:01:17 PM Command Button Password Could anyone tell me if it is possible to write some code into the "Onclick" Event procedure that requires a password before the user can access a command Button or Ctrl Tab? Thanks for any help... 10 9/23/2006 5:15:11 AM how can i find my missing folder ... 2 9/22/2006 10:08:07 PM Whare are permissions stored? In a split db, where are group permissions actually stored -- in the .mdw file or in the FE? I keep setting group permissions and they keep changing.... 7 9/22/2006 7:00:32 PM Security log ins I currently have a database in Access 2003 with user permissions and passwords. When the relevant user logs in they go to the form and assign themselves to a job. However, at the moment it would be possible for them to sign in and assign a job to another worker. Is it possible to create a piece of security where a user logs in and can only assign him/her self from the drop down list wi... 14 9/22/2006 6:58:50 PM Access News Group via OUtlook express I'm trying to access news group via outlook espress but I can't. I think the prot 119 is in fire wall or lock. The is another away or another port to access the news group server? Thansk JP... 1 9/22/2006 6:37:02 PM How do you password protect a form Hi all, I have created an Access 2003 database that when opened it shows only the mainform that has command buttons that access various other subforms. One of these subforms is an input form from where you can enter data that will go into a specified table. I would like to secure this one and only subform so that unauthorised people can not enter data or edit the data. Thanks ver... 4 9/22/2006 2:51:02 PM Listing current users at startup on the autoex form As an administrator, I need to know who is logged into the data base at openning screen, so I can notify they to exit, if the need arises? How do I do this, would I use the CurrentUser() and do I do that? Thanks... 9 9/22/2006 1:25:02 PM avoid data changed or deleted carelessly My staff use forms for data input and they are also able to access the underlying table. There is possibility that when they open tables the data therein are altered or deleted by mistake. Any way to not allowing the staff to access tables to avoid exposing the data to danger? Simon Wong... 3 9/21/2006 10:45:01 PM Hiding Backend Files I have implemented security on the front- and back-end files for a timesheet application, and after 2 days of testing, everything seems to be working as expected. It occurs to me, however, that there is nothing preventing a legitimate user or anyone who can gain casual access to our network from accidentally or purposefullly deleting the back-end files. Can anyone suggest any strategie... 8 9/21/2006 9:48:40 PM Audit on Access Hi People, I am wondering if there is a way to audit access database and be able to track down who used the database, what changes were made and the time changes were made. This is a feature in many database applications and I am wonder if this can be done in Access. I know you can check who is logged in. Anybody please advise Billy ... 3 9/21/2006 6:05:55 PM MS Access Password (Corrupted) I have been given a Access Database to look at as it seemed that they forgot the Database password. I purchased some software to hack it and it came back with the password they used. Does this sound like a lost cause or is there something i could do to help them?... 1 9/21/2006 5:30:01 PM FAX Error on Windows 2003 using ASP.NET Hi All, I have developed FAX Application in ASP.NET 2.0 using FAXCOMLib in Windows 2003 Server Environment. My code is given below. Dim FS As New FAXCOMLib.FaxServer Dim FD As FAXCOMLib.FaxDoc FS.Connect(ServerToConnect.Trim()) FD = FS.CreateDocument(str_Path_Of_File_To_Be_Faxed.Trim) \\\file Name to be send FD.FileName = str_Path_Of_File_To_Be_Faxed.Trim FD.Fa... 1 9/21/2006 6:38:02 AM Another question about removing security Hi, I'm in a bit of a bind. I have been given a copy of an Access 97 database that has security already set up. I have the shortcut file, the .MDB file and the .MDW file. I am using Access 2002 on my PC. I can log on to use the database application (as Administrator - using the shortcut), but I can't get into Design Mode to make any changes. Help! -- Andrew B... 2 9/20/2006 4:49:51 PM Auto join to MDW From info on other posts, I have set my shortcut to the following: "C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" "C:\Database\FSCorp.mdb" /wrkgrp "p:\DataWH\FSCorpUsers.mdw" where p is our network drive. Opening the database through the shortcut did in fact get the login prompt. However, after opening the database, I went to TOOLS - Security - Workgroup Administrator to... 6 9/20/2006 4:32:52 PM Allow Help Desk to Reset Passwords Without Full Admins Permissions I would like to allow our help desk to reset user passwords but don't wish them to have the rest of the abilities members of the Admins group have. Easily enough done if one doesn't mind embedding an Admins member user name and password in an executable or Access application, but I would prefer not to do that, perhaps only as a matter of principle in that I understand user level security is s... 7 9/20/2006 1:35:51 PM Multiple Users on an 2003 Access Database I have set up an Access 2003 Database. Multiple Users will have to be able to work on this database at the same time. (i.e. two users can create a query on the one table at the same time). I have done the above in the past on existing databases however I have never set one up from scratch. I would appreciate any assistance. Thanks, Alan.... 2 9/20/2006 12:07:28 PM 87 Pages: <<  17  18  19  20  21  22  23  24  25  26  27  28  29  30  31  32  33  34  35  36  37  38  39  40  41  42  43  44  45  46  >>