A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

User Password to protect my design Access2007 database.



 
 
Thread Tools Display Modes
  #1  
Old October 20th, 2008, 10:30 AM posted to microsoft.public.access.tablesdbdesign
yiotaa
external usenet poster
 
Posts: 8
Default User Password to protect my design Access2007 database.

I have a multiuser database in MSAccess 2007 and I would like to have
password in order to protect my database design.
Please help me!
  #2  
Old October 20th, 2008, 02:41 PM posted to microsoft.public.access.tablesdbdesign
Tom van Stiphout[_2_]
external usenet poster
 
Posts: 1,653
Default User Password to protect my design Access2007 database.

On Mon, 20 Oct 2008 02:30:01 -0700, yiotaa
wrote:

Assuming you mean the A2007 ACCDB format, that is not possible. Also
keep in mind that even though in some cases the application can be
yours (and your clients are licensing usage), the data is not. If you
were able to hide the db design, you would likely also hide the data
and that's a big no no in many jurisdictions.

-Tom.
Microsoft Access MVP


I have a multiuser database in MSAccess 2007 and I would like to have
password in order to protect my database design.
Please help me!

  #3  
Old October 20th, 2008, 07:25 PM posted to microsoft.public.access.tablesdbdesign
John W. Vinson
external usenet poster
 
Posts: 18,261
Default User Password to protect my design Access2007 database.

On Mon, 20 Oct 2008 02:30:01 -0700, yiotaa
wrote:

I have a multiuser database in MSAccess 2007 and I would like to have
password in order to protect my database design.
Please help me!


If you want to keep the users from seeing your code or modifying the structure
of forms and reports, make your .mdb or .accdb file into a .mde or .accde and
distribute that. KEEP A COPY of the original, you'll need it to make
modifications.

There is no really solid security structure in 2007. You can make it a hassle
for users or hackers, but any password can be cracked if someone is
determined.
--

John W. Vinson [MVP]
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 06:13 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.