 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / General 2 / January 2008Securing my database!
Am I crazy or could this be Done!! My MS Access Database has a Form Called [frmCompanyInfo] their is say 4 fields That's have to have data CompanyName BankName BankAddress BackAccount BankAccNumber Would it be possible to have a module that would take say the 2 digit or letter turn it into a number times it by say 753 which would have to be entered on that form the data base to be operational, the Module would be password protected to find out what its doing, if the 2 space was blank it would default to a number say 9............Anybody's thoughts would be appreciated.......Just don't want my friends coping it to their friends for there use...........Bob V >Am I crazy or could this be Done!! >My MS Access Database has a Form Called [frmCompanyInfo] their is say 4 [quoted text clipped - 11 lines] >appreciated.......Just don't want my friends coping it to their friends for >there use...........Bob V YOu can do better than that, although no desktop database can be secured past the ability of a skilled and determined hacker to break into. Download the Microsoft Access 2000 Security FAQ: http://support.microsoft.com/kb/207793/en-us Print it out. Read it, carefully. Get a good night's sleep. Read it AGAIN, all of it, even MORE carefully. Make a backup of your database. Follow the security instructions, step by step. I will often check them off on the printout (and I've done this many times). This will let you specify which tables, forms, reports, etc. any user can see. You can define multiple user ID's, multiple user groups, etc. I have NO idea what you mean by your 753 and 9 and so on... but any "home grown" security system will be very easily broken by anyone with a modicum of programming knowledge. John W. Vinson [MVP] > ...no desktop database can be secured past > the ability of a skilled and determined hacker to break into. LMAO Dimbulb MVP. 3DES cryptography in VBA, for example... 1 line of code and a 4096-bit key... Dim encStream As New CryptoStream(ms, _ TripleDes.CreateEncryptor(), _ System.Security.Cryptography.CryptoStreamMode.Write) Not even the NSA would be able to crack it with a thousand years of supercomputer processing time. Say, have you ever tried thinking? Even just once? >LMAO > >Dimbulb MVP. <snip> >Say, have you ever tried thinking? Even just once? And you are an anonymous coward. Go away. Tony  SignatureTony Toews, Microsoft Access MVP Please respond only in the newsgroups so that others can read the entire thread of messages. Microsoft Access Links, Hints, Tips & Accounting Systems at http://www.granite.ab.ca/accsmstr.htm Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/ >>LMAO >> [quoted text clipped - 5 lines] > > And you are an anonymous coward. Oh, really? And what law of what land is it that requires posters to newsgroups to be identifiable by name? No doubt if my real name were Fred Bloggs and I posted with that then you would run up the ladder of inference like a mad rat with its butt on fire and hurl insane accusations of anonymity at that name too. Before you try to dodge the two salient points just brought to your exceedingly meagre attention span, I strongly recommend that you brush up on a rather simple network utility called WHOIS. NNTP-Posting-Host: 210.1.196.98 address: Pipeline Internet Providers Pty Ltd address: 6/87 Reserve Road address: Artarmon address: NSW 2064 Anonymous coward, you say? You less than useless, know-nothing fool. > Go away. No. How about you grow a brain? >Anonymous coward, you say? You less than useless, know-nothing fool. Already did all that. You're still an anonymous coward. Tony SignatureTony Toews, Microsoft Access MVP Please respond only in the newsgroups so that others can read the entire thread of messages. Microsoft Access Links, Hints, Tips & Accounting Systems at http://www.granite.ab.ca/accsmstr.htm Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/ >>Anonymous coward, you say? You less than useless, know-nothing fool. > > Already did all that. > > You're still an anonymous coward. So, which do you feel is more cowardly, posting with a valid IP address but without a real name, or cutting out all of your detractor's text and running off to hide in the vain hope nobody will notice you were too chicken to address the points being made? PS: Why are you repeating yourself? So Guys what am I going to do about trying to Secure my database , even if they would have to find some one to try and crack it , would be better than nothing!! thanks Bob >>>Anonymous coward, you say? You less than useless, know-nothing fool. >> [quoted text clipped - 8 lines] > > PS: Why are you repeating yourself? >So Guys what am I going to do about trying to Secure my database , even if >they would have to find some one to try and crack it , would be better than >nothing!! thanks Bob Sorry about the intrusion... did you see my previous response? Here it is again: Download the Access 2000 Security FAQ: http://support.microsoft.com/kb/207793/en-us Print it out. Read it, carefully. Get a good night's sleep. Read it AGAIN, all of it, even MORE carefully. Make a backup of your database. Follow the security instructions, step by step. I will often check them off on the printout (and I've done this many times). Unfortunately, if you have A2007, they've taken the security features out. You'll need to - at least - use A2002 .mdb format, and (I'm not sure, I don't have 2007) use an older version to secure the database. Other than that the security whitepaper covers all versions of Access from Access95 through Access2003. John W. Vinson [MVP] Thanks John will do as I have MS Access 200..Bob >>So Guys what am I going to do about trying to Secure my database , even if >>they would have to find some one to try and crack it , would be better [quoted text clipped - 29 lines] > > John W. Vinson [MVP] > So Guys what am I going to do about trying to Secure my database , even if > they would have to find some one to try and crack it , would be better > than nothing!! thanks Bob I am drawn to wonder if you, or anyone else for that matter, have ever thought about asking google your questions... in fact, I'm drawn to wonder if any of you have ever thought. Results 1 - 100 of about 156,000 English pages for how do I secure my access database?. (0.31 seconds) Howto create a secure MS-Access (MS-Jet) database programmatically... ACC: Microsoft Access Security FAQ Available in Download Center... How to Unsecure a Secure Access Database - Access / VBA Articles Results 1 - 100 of about 85,500 English pages for how to secure an access mdb. (0.58 seconds) Making an Access File More Secure - Access - Microsoft Office Online Results 1 - 100 of about 120,000 English pages for Making an Access File More Secure - Access - Microsoft Office Online. (0.33 seconds) Do you also need help working out how to get to google? And to you. you Idiot I have had back up help when things don't go right with my first reply post. Now Idiot you don't get that on GOOGLE!! >> So Guys what am I going to do about trying to Secure my database , even >> if [quoted text clipped - 21 lines] > > Do you also need help working out how to get to google? > And to you. you Idiot I have had back up help when things don't go right > with my first reply post. Now Idiot you don't get that on GOOGLE!! You seem upset, Blob. Are you going to burst a blood vessel and mess up the carpet? >>> So Guys what am I going to do about trying to Secure my database , even >>> if [quoted text clipped - 22 lines] >> >> Do you also need help working out how to get to google? Unlike John the way I read your mesage (also skipping the 753 part) is that you want to give your friend your application, but make it impossible for this app to work on your friend's friends computers. This does not require workgroup security like John was suggesting, but some kind of Activation scheme. There are many ways to do that, but because of the nature of security, the exact methods shall remain secret. Keywords: hidden, system, registry, text file, computer name, domain name, etc. One publicly available way is to require a dongle, sometimes called a hasp: a small device in the serial port or usb port that your app can check for. I'm sure you can google for it. -Tom. >Am I crazy or could this be Done!! >My MS Access Database has a Form Called [frmCompanyInfo] their is say 4 [quoted text clipped - 11 lines] >appreciated.......Just don't want my friends coping it to their friends for >there use...........Bob V >Unlike John the way I read your mesage (also skipping the 753 part) is >that you want to give your friend your application, but make it >impossible for this app to work on your friend's friends computers. Ah... you're probably right, Tom. I didn't see that interpretation. John W. Vinson [MVP] |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.