 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Modules / DAO / VBA / July 2008Problem securing my DB *7142008
Dear All, I have a DB with a size of aprrox 1.1 GB,it's that big cause it contains my products with pics stored as OLE objects. When trying to secure it or even part of it the file "CRASHES(DOES NOT RESPOND)"! The reason I want to secure it is because I don't want it to be available on another computer in case somebody copies it without my permission! If it's impossible to secure can somebody provide me with some code that I can use to protect it f.e that the file only opens when on computer"XX"! Hope you can help me out >I have a DB with a size of aprrox 1.1 GB,it's that big cause it contains my >products with pics stored as OLE objects. [quoted text clipped - 4 lines] >If it's impossible to secure can somebody provide me with some code that I >can use to protect it f.e that the file only opens when on computer"XX"! Can you compact the MDB? Have you tried importing it into a new MDB? 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/ Dear Tony, I'll try it again and i'l let you know > >I have a DB with a size of aprrox 1.1 GB,it's that big cause it contains my > >products with pics stored as OLE objects. [quoted text clipped - 8 lines] > > Tony Dear Tony , I compacted the mdb which worked, and then I started the user level security wizard and I left it for 4 hours but still when I came back it was still busy "enhancing security" ! When I try importing the biggest table in another db the same thing happens ,it gets stuck,is there something else I can try? > >I have a DB with a size of aprrox 1.1 GB,it's that big cause it contains my > >products with pics stored as OLE objects. [quoted text clipped - 8 lines] > > Tony Dear Tony, I tried it again but this time I only secured forms,and macros, and it worked!! although tables,queries and reports are not secured the mdb has some level of protection , Main thing is that the mdb will not open on a standard workgroup file! > >I have a DB with a size of aprrox 1.1 GB,it's that big cause it contains my > >products with pics stored as OLE objects. [quoted text clipped - 8 lines] > > Tony >I tried it again but this time I only secured forms,and macros, and it >worked!! although tables,queries and reports are not secured the mdb has >some level of protection , Main thing is that the mdb will not open on a >standard workgroup file! I have very little practical experience with Access security. I'd strongly suggest you explain your situation and ask further questions in the Access security newsgroup. 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/ |
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.