Problem securing my DB *7142008

[J.Alladien]

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

 

[Tony Toews [MVP]]

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"!

Can you compact the MDB? Have you tried importing it into a new MDB?

Tony
--
Tony 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/

 

[J.Alladien]

Dear Tony,

I'll try it again and i'l let you know

 

[J.Alladien]

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?

 

[J.Alladien]

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!

 

[Tony Toews [MVP]]

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
--
Tony 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/