Threads Replies Last Post 58 Pages: <<  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  31  32  33  34  35  >>   Shift kode Hi i use a code from this forum, and its works at home , now i try another place and i get this error Set prp = dbs.CreateProperty(strPropName, _ varPropType, varPropValue) The code come from a db. call shiftkey200.mdb and is a db from this forum or a link regards Alvin ... 2 29.05.2006 23:15:51 Access Security For the first time i have devloped a multi user application that required user level security. This is fine for this application but now I find that the same security applies to all my access applications most of which are for my own use and don't need security. I have tried the help solution which was to give all users all permissions, create a new database etc etc. When I did this ... 2 29.05.2006 12:11:52 Table security Hi I am looking for simple security on a single table in database. This table needs to be accessed only by a specific user (picked up from windows login) and no one else. What is the way to achieve this? Thanks Regards ... 2 29.05.2006 00:19:17 userid on network recording on record in a table I need MS Access 2000 to record the userid on a network on record so that I can trace who work on that record - .mdb file is shared on a shared harddisk via network ?... 4 28.05.2006 16:36:40 stolen ownership, round 2, isnt this illegal? I'M DUMB. TOOK A YEAR TO REALIZE PC DAD GAVE ME IS ON HIS NETWORK AND UNDER HIS CONTROL, SAME AS ALWAYS. IS THAT NOT ILLEGAL? I THOUGHT I REBOOTED AND DISABLED HARDWARE SUCCESSFULLY WEEKS AGO. THOUGHT I WAS FREE AND CLEAR, SUSPECTED OTHERWISE (YOU KNOW WHEN YOU'RE THE OWNER AND YOU COME ACCROSS FILES YOU DON'T HAVE ACCESS TO, SOMETHING'S WRONG). I WANT TO BE OFF ANY NETWORK. I DON'T WANT... 6 28.05.2006 07:31:51 details my father knows computers inside out. he;s running about 4 machines of his own (pchome, pcwork, laptop, handheld, who knows what else) and my pc on his powerdesk program, which is ridiculous i wish i could put it out for everyone. my dad's brilliant with computers but the man has some serious issues. he's had me on his network again for who knows how long but the settings tell me i am n... 2 27.05.2006 21:59:03 Re: stolen ownership, round 2, isnt this illegal? Sorry. I accidentally hit the keyboard and sent that message before I was ready to. ;-) > HOW CAN I GET MY PC BACK? I'LL GIVE SOMEONE REMOTE ACCESS IF THEY WOULD > JUST CLEAR THE WHOLE MEMORY AND REINSTALL THE OS SO I CAN START NEW. > ALONE! This isn't the brilliant idea that it sounds like. Many hucksters would love to get remote access to a computer novice's computer so... 1 27.05.2006 21:29:30 Disallow viewing of hidden objects I am using Active Directory security in an Access 2003 database and it works very well for contolling what the user can do from a form. I disable the use of the ShiftKey so the user has to work with my form when in my database. The problem I have found is anyone can link to my tables from another database using the default system.mdw. One of my reasons for using Active Directory was t... 2 26.05.2006 20:27:02 User access on a company intranet I have set user level security up on the database used by my department, which I'm the owner of all the tables, queries, etc.. I have given everyone in my department a user name, assigned them to groups and gave each a password. While the security works on my computer others in my department who access the database through the server are not prompted for their user name or password. W... 27 26.05.2006 14:48:02 VSS and objects permissions Hello, Context : I'm using VSS and the addin for Access 2003 for configuration management. I have an Access database FE/BE with specific mdw (groups and users). I have craeted a VSS project Problem : When I generate my Database from VSS all permissions are lost ! Is it a limition of the addin or a solution exist ? Thanks a lot for yours answers. ... 2 26.05.2006 01:46:37 Created Database Password Fine Then Used Security Wiz & Can't Open I am a new Access user and have created a simple table and a simple form. I then went into "Tools", "Security" and "Set Database Password". I closed out of Access, went back in, opened the database, was prompted for password and got in, no problem. Next, I used the Security Wizard using the prompts in the book, "MS Access 2003 QuickSteps" and created a username and password. Now when I... 2 25.05.2006 21:23:55 Limit use I've created user and admin accounts but Access can't seem to differentiate between the two. I want users to have to log in to the database, not Access and I want them to have VERY limited access to different areas of the database. Basically they should only be able to see a form and enter data into it. How do i do this... 2 25.05.2006 16:14:50 Password protection on a specific button? From what I understand there is a way to put password protection on a specific button on a form and not have to put it on the entire database. If this correct, does anyone have a step-by step way to handle this, or a link to where i can go to find this. I've been pulling my hair out trying to figure it out and can't seem to do it. Any help? I would appreciate it. Thanks.... 3 25.05.2006 15:01:35 Linked tables and network security Can linked tables in a folder otherwise blocked by network security (NOT Access security) be read/written to from a front end not in a blocked folder? Thanks.... 5 25.05.2006 14:55:02 how to connect as a different user at runtime (in code) Is there a way to startup an Access 2002 app with the default admin user, then have code which when executed will connect to a different user? This app starts without any login prompt which I understand means it is using the default admin user. My purpose for this is to provide additional privilages for a function at runtime that does object deletes (docmd.deleteObject). I have taken away... 1 25.05.2006 14:47:02 Database Splitter - Moving FE to local PC I made a mistake when using the DB splitter to split the DB. The BE and FE is placed on network server in the same folder. Can I copy the FE to each user local PC? How do I create the shortcut on the users PC to run Access from their PC and find the BE on the network server. I have 6 users that will share/input info in the DB. Thank you in advance for your help.... 8 24.05.2006 15:36:42 Security wizard Hi I have set up a secure DB using the security wizard added all my users with passwords, my database is now secure. I now go into the database and set user permissions, after I have done this if I bypass the shortcut and click on the MDB file I or anyone else can get straight in to the database and view all data. Am I doing something wrong, I just followed the wizards instructions. Ple... 11 24.05.2006 14:24:29 Deleting Duplicate Values in a Query Here's my problem in exact replication: I have used the find duplicate query in Access, and the query determined the following duplicate values by the following query: In (SELECT [DocNo] FROM [File Name] As Tmp GROUP BY [DocNo] HAVING Count(*)>1 ) DocNo Amounts ABC 12 ABC 123 BDC 10 BDC 1000 Now I want to go further by s... 3 24.05.2006 13:49:56 Read Only Suddenly, my DB on the network opens "Read Only" and I can't figure out how this switch was turned. (perhaps during the last Network Failure???) I am listed as the owner in the Properties, I have changed all the properties on the Security Tab to Full... I can't delete the DB because it says it may be opened by another user (it's not!) ... there is no ldb file listed.... I'm totally stump... 2 24.05.2006 12:52:08 Having trouble with a spyware in my comp... I downloaded the new Spyware remover from Microsoft and even though it has removed most of the programs, apparently it cannot take one out because it does the scan and says to do a reboot and then the remaining spy/adwares will be removed but once I finish rebooting it tells me to reboot and the process starts all over again. The file is called Adware-Qoologic. Thank you for your hel... 3 23.05.2006 20:34:02 Get Data from User-Level Secured Database I have two databases each secured with user-level security and separate .mdw files. I am also using Access 2002-2003. Is it possible to retrieve a recordset from one of the databases using VBA and a username and password setup strictly for this purpose? If so, how? If not, should the "source" database be setup as a password-secured database (without user-level security)? Regards... 1 23.05.2006 15:55:02 How do I get rid of hyperlink warning in Access I have a database with hyperlinked operating instructions. How do I get rid of that red screw warning that hyperlinks may be harmful to computer/data? This is SO annoying to all the database users! ... 3 23.05.2006 14:28:01 Ca[ture Recordnumber Reposting haven't heard back See Below. I have the below code in the Oncurrent event of the form and it is making the username be updated as navigate to and from records. If I take this out the username(in afterupdate of form) works fine and stays correct as navigate records. Any way to capture the recordnumber on the form than back to the table with out messing up the username as navi... 1 23.05.2006 14:12:01 Disable this warn message??? dear all, good day i tried this code by an Access Application DoCmd.SendObject acReport, "Invoice", acFormatRTF, _ "[fax: " & ![SQNo] & "]", , , , , False and i have microsoft Outlook 2003 .... just i need to disable the pop-up message every time i send "A program is trying to automatically send an e-mail message using a Microsoft Visual Basic Appli... 2 23.05.2006 11:31:34 Make MDE in Access 2003 How long should it take to create a MDE file? Is it SLOW or quick? Thanks! ... 3 23.05.2006 04:10:32 58 Pages: <<  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  31  32  33  34  35  >>