Threads Replies Last Post 58 Pages: <<  14  15  16  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  >>   Setting Security of Mdb I have tried lot of times to set the security of the mdb of Ms Access 2000 but failed. I tried the steps of the book I follow and the tips of the help file but unable to set up the security. I go to a certain level and fail. I need to create 1 Admin and 3 user and set different permissions to the user and all permission to Admin. I will try to mentioned my steps which I use to make mdb... 2 06.04.2006 14:08:53 user and admin security Hi I was using access 2000 and created security to my database using the security feature provided by ms access. I created security so that users login with their own password and managers with their own. This all works fine. I opened my database on another pc with access 2003 and realised that the login screen does not appear. It goes straight in. When you setup ms access security to your... 4 06.04.2006 13:48:16 Last steps to secure my database I have an Access 2000 database with a large number of forms and reports and it is linked to a backend data file. Against my better judgement I am having to deploy this database to a user that is intent on damaging the files so they do not work and then trying to "reverse engineer" the program to duplicate it. I need this program as locked down as possible. I have done the following: ... 2 06.04.2006 05:42:48 Compiled Runtime Database needs new users I have a FE/BE database. Everytime I need to add new users I have to go into the wizard and add the new user and then recompile and redeploy the FE of the database. Before I made it a runtime i could just update the security and it would look on the server at the file and be ok.. .now that it is a runtime it goes to the file that is packaged with the FE runtime. How do I edit that file th... 3 05.04.2006 22:28:49 lock a field from edits after data is entered...? Is there a way to lock a field from being edited once data is entered into that field? Any info would be greatly appreciated.... 2 05.04.2006 19:26:40 User Group Accounts Hello all, The optional security groups in access each define a set of permissions for the users. Does anyone know what permissions each group has? -A... 3 05.04.2006 17:53:59 You do not have the necessary permissions Hi, A user copied his access database from his laptop to the server because his laptop had to be sent in for repairs. Now we cannot get into the database on the server. The message you do not have the necessary permissions to use the object comes up when you try to open the file on the server. I tried creating a new access database with me as the owner and then importing the objects ... 13 05.04.2006 16:18:01 What is the code for bess? tell me, now ... 3 05.04.2006 15:35:59 Trying to update the Access Database I have created an Access database with a Back-end. The back-end has files imported into it once a week. The problem I am having is when we try to update the back-end with the new data, people are still logged into it. I get a message saying the datbase is open in READ ONLY MODE and changes can not be made. At the present time we have to call IS and ask them to find out which users ... 7 05.04.2006 14:04:03 errors when accessing from a shedlued DTS SQL package Problem: Created a DTS package to get information from a MSAccess Database. We used an ODBC to get access, and configured it to use the sysem.mdw (Security file). When we run the DTS package manual (meaning by right click/execute) the package runs and gets the data. We then scheduled the the DTS to run once a day. Now when executing this job we always get the same error. The user sqlser... 1 05.04.2006 09:24:02 Access Password How can i create a user and password in the Access 2003 ?... 6 05.04.2006 03:03:01 Users with read-only permissions can't view form I am setting up security permissions. Users to whom I've assigned "read" priviliges on some subforms cannot view the blank form, but they can view any read-only form that already contains data. Is this normal? Is there anything I can do to display the form? The blank tab looks like a mistake. -- susan... 2 04.04.2006 21:50:14 Putting a database on a network I have created a database of student information and would like to put it on the school intranet, so it is accessible to all staff. It would have to be read only, so nothing can be changed by anyone but myself. I understand that I would need to split it into a front and back end, which I think I am capable of doing. What I don't understand is how to make it so I can access it and change t... 8 04.04.2006 21:18:02 security of privacy hello~ Can some one tell me how to avoid the documents in my computer be copy by others? Is it hard to do?Should I buy any secuity soft to protect my documents? pleace give me some good advices ,thank you~~~ ... 2 04.04.2006 14:38:37 How do I lock a database so it's Read-Only? I want to set up a database so that one person can update and maintain the data and so that others can only see the database as read only to look at queries? ... 2 04.04.2006 12:14:13 How to get my password back :( I set up a password for my app on Access 2000, unfortunately i lost it :( is this a disaster ?? can anybody save my life ?? any solution would be highly appreciated ... ... 2 04.04.2006 11:54:15 nice to meet you hello ... 1 04.04.2006 08:25:57 Design Permission for tables When synchronizing data between the server and a laptop connected to the network, some temporary tables are created, data is moved around and then the tables are deleted. Visual Basic is used in Access 2003. It works fine when I test it on my computers. When my client tries to run it, she gets the error message: Could not create; no modify design permission for table or query 'Table1'... 1 04.04.2006 03:02:01 ͬÎÒÁªÏµ ÎÒÊÇÕÔ»ª½¡ ... 1 03.04.2006 23:10:31 disable shift key I have read a lot of threads here, and have tried a number of different code samples from various tinternet sites, with varying results. I have successfully disabled a db, but then the code to re-enable wouldn't work. I've had various errors, but finally got the following borrowed (techonthenet.com) code to work by removing two lines (to avoid the error "Item not found in this collection... 3 03.04.2006 21:42:10 Locked out of database Dear Sir, I am locked out of my database. My database was on 2002. But now I am opening in 2003, Can that be a problem? Also I do not remember my username and password. This is a database I had preppared long ago but now I need to get some data from it. Please someone guide me so I can get into my database. Thank you.... 2 03.04.2006 21:15:06 SSL keys on USB drive How can I setup Windows XP so my SMIME key is only available when my USB drive is inserted? Do I need a special USB key or software to facilitate this? ... 2 03.04.2006 05:42:39 LDB Lock File location Is there a way to specify where the .ldb lock file gets created when a database is opened? When the database is in a read-only folder, the lock file is not created. We'd like to put the lock file in a separate folder. Thank in advance, -- Glenn... 8 03.04.2006 04:44:47 order of security could someone let me know what order to conduct the following : Encode the data base, split the database, make multiple copies of the front end, make SOME of the front ends into mde files (leave others for further development), apply user level security, determine startup options, disable shift key override, anything else to nail the security. Cheers.... 3 03.04.2006 04:42:46 unhide toolbars I created a db and hid the tooolbars through the startup menu. When I use shift to open the db, the toolbars do not return. Any thoughts?... 3 02.04.2006 19:44:01 58 Pages: <<  14  15  16  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  >>