Hello All.
I would like some advice.
What is the best way to make an Access database design not accessible?
Like accessing tables, form design and etc.
Is it a good idea to make a MDE file? What other options do I have?
On more question should all users have their own front end?
Thanks a lot.
Simone Dupre 5 4320
Yes, creating an MDE is a great way to prevent users from switching your
forms and reports into design view, and prevent them messing with the code.
To prevent them messing with the design, set the database's AllowByPassKey
and AllowSpecialKey s properties of the MDE file to False. Details at
support.microso ft.com in k.b. article 313915.
Other options include the full security, but that's generally overkill
unless you have particularly sensitive data.
Yes, each user should have their own copy of the front end. It can be in
their workspace on a server if necessary, but it will run faster and reduce
network traffic if the application is installed onto their local hard disk.
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Simone" <oi****@hotmail .com> wrote in message
news:fc******** *************** ***@posting.goo gle.com... I would like some advice. What is the best way to make an Access database design not accessible? Like accessing tables, form design and etc. Is it a good idea to make a MDE file? What other options do I have?
On more question should all users have their own front end?
Thanks a lot. Simone Dupre
"Simone" <oi****@hotmail .com> wrote in message
news:fc******** *************** ***@posting.goo gle.com... Hello All.
I would like some advice. What is the best way to make an Access database design not accessible? Like accessing tables, form design and etc. Is it a good idea to make a MDE file? What other options do I have?
An .mde is best - for the front end. You can also laboriously use Access
security and set the permissions for each and every object so no one but you
can access design views.
On the back end, you actually might want to do something with permissions,
or set a database password.
On more question should all users have their own front end?
Yes.
Thanks a lot. Simone Dupre
I use this most of the time. Create a "Welcome" form with no objects and add
this code to form_load.
*****CODE*****
Private Sub Form_Load()
Dim MyDB As Database
Set MyDB = CurrentDb
If UCase$(CurrentU ser) = "ME" Or UCase$(CurrentU ser) = "THEM" Then
MyDB.Properties ("StartupShowDB Window") = True
MyDB.Properties ("StartupShowSt atusBar") = True
MyDB.Properties ("AllowBuiltinT oolBars") = True
MyDB.Properties ("StartupShowDB Window") = True
MyDB.Properties ("AllowFullMenu s") = True
MyDB.Properties ("AllowBreakInt oCode") = True
MyDB.Properties ("AllowSpecialK eys") = True
DoCmd.Close acForm, "frmwelcome "
Exit Sub
End If
MyDB.Properties ("StartupShowDB Window") = False
MyDB.Properties ("StartupShowSt atusBar") = False
MyDB.Properties ("AllowBuiltinT oolBars") = False
MyDB.Properties ("StartupShowDB Window") = False
MyDB.Properties ("AllowFullMenu s") = False
MyDB.Properties ("AllowBreakInt oCode") = False
MyDB.Properties ("AllowSpecialK eys") = False
MsgBox ("You are an invalid user!!")
Quit
End Sub
Thanks for all your responses.
There is one more thing, even if I make an MDE the user can go into
the table and enter records. I hide the database window but let's say
some user that knows a little too much like the shortcut F11 he or she
will be able to go into the tables and enter data.
I don't want them doing that since there is a complex relationship and
they must use the forms.
Thanks
Simone
"None" <No**@none.co m> wrote in message news:<0q******* *************@d ls.net>... I use this most of the time. Create a "Welcome" form with no objects and add this code to form_load.
*****CODE*****
Private Sub Form_Load()
Dim MyDB As Database Set MyDB = CurrentDb If UCase$(CurrentU ser) = "ME" Or UCase$(CurrentU ser) = "THEM" Then MyDB.Properties ("StartupShowDB Window") = True MyDB.Properties ("StartupShowSt atusBar") = True MyDB.Properties ("AllowBuiltinT oolBars") = True MyDB.Properties ("StartupShowDB Window") = True MyDB.Properties ("AllowFullMenu s") = True MyDB.Properties ("AllowBreakInt oCode") = True MyDB.Properties ("AllowSpecialK eys") = True DoCmd.Close acForm, "frmwelcome " Exit Sub End If
MyDB.Properties ("StartupShowDB Window") = False MyDB.Properties ("StartupShowSt atusBar") = False MyDB.Properties ("AllowBuiltinT oolBars") = False MyDB.Properties ("StartupShowDB Window") = False MyDB.Properties ("AllowFullMenu s") = False MyDB.Properties ("AllowBreakInt oCode") = False MyDB.Properties ("AllowSpecialK eys") = False MsgBox ("You are an invalid user!!") Quit End Sub
Simone,
Before you create your .mde, go into the Advanced options under Tools |
Startup and uncheck the Access Special Keys option, or do something like
what None does below with the AllowSpecialKey s property.
"Simone" <oi****@hotmail .com> wrote in message
news:fc******** *************** ***@posting.goo gle.com... Thanks for all your responses.
There is one more thing, even if I make an MDE the user can go into the table and enter records. I hide the database window but let's say some user that knows a little too much like the shortcut F11 he or she will be able to go into the tables and enter data. I don't want them doing that since there is a complex relationship and they must use the forms.
Thanks Simone
"None" <No**@none.co m> wrote in message
news:<0q******* *************@d ls.net>... I use this most of the time. Create a "Welcome" form with no objects and
add this code to form_load.
*****CODE*****
Private Sub Form_Load()
Dim MyDB As Database Set MyDB = CurrentDb If UCase$(CurrentU ser) = "ME" Or UCase$(CurrentU ser) = "THEM" Then MyDB.Properties ("StartupShowDB Window") = True MyDB.Properties ("StartupShowSt atusBar") = True MyDB.Properties ("AllowBuiltinT oolBars") = True MyDB.Properties ("StartupShowDB Window") = True MyDB.Properties ("AllowFullMenu s") = True MyDB.Properties ("AllowBreakInt oCode") = True MyDB.Properties ("AllowSpecialK eys") = True DoCmd.Close acForm, "frmwelcome " Exit Sub End If
MyDB.Properties ("StartupShowDB Window") = False MyDB.Properties ("StartupShowSt atusBar") = False MyDB.Properties ("AllowBuiltinT oolBars") = False MyDB.Properties ("StartupShowDB Window") = False MyDB.Properties ("AllowFullMenu s") = False MyDB.Properties ("AllowBreakInt oCode") = False MyDB.Properties ("AllowSpecialK eys") = False MsgBox ("You are an invalid user!!") Quit End Sub This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: John M |
last post by:
Hi
For reporting grades and comments about students, I use one subreport per
subject. This includes a number of text boxes, some containing numerical
data, but one containing a textual report. Depending on how much is
written, sometime there are three on a page, sometimes two etc. What I
cannot seem to do is to get it to 'not start a report for a subject unless
it can fit it on a page'. The keep together option seem to have no effect...
|
by: deko |
last post by:
Is there any way to let users compose and run SQL from the Access interface?
If I create a new query from the Database Window, select Design View and
then View >> SQL View, I get a window from which I can compose and run SQL
queries. What I'd like to do is let users have the ability to run SQL
queries like this against imported tables.
I was thinking I could open the imported table in a form and have a textbox
in which SQL can be...
|
by: Andy_Khosravi |
last post by:
I'm in a bit of a pickle.
My employer, a health insurance firm, had me design a small database to
track benefit issues. The intended users were technical specialists and
some managers (about 90 people, no more than 10 concurrent users at any
one time) all of which had Access 97 loaded on their machines.
Everything was going smoothly, and I delivered them their VBA
application that does everything they initially wanted it to.
However,...
|
by: VB Programmer |
last post by:
When I go from HTML view (in a webform) to Design View I get the following
error:
Could not open in Design view. Quote values differently inside a '<% ...
"value" ... %>' block.
I know exactly where it is. All I did was change the PARAM value of an
OBJECT from this:
<PARAM NAME="MyValue" VALUE="20">
to this:
<PARAM NAME="MyValue" VALUE="<% = Request.QueryString("Value1") %>">
|
by: spam.noam |
last post by:
Hello,
Guido has decided, in python-dev, that in Py3K the id-based order
comparisons will be dropped. This means that, for example, "{} < "
will raise a TypeError instead of the current behaviour, which is
returning a value which is, really, id({}) < id().
He also said that default equality comparison will continue to be
identity-based. This means that x == y will never raise an exception,
as is the situation is now. Here's his reason:
| |
by: google |
last post by:
I have a few general questions. I am working on a new database to be
used within my company. I would like to give a couple of people,
particularly HR, the ability to add and delete Access users, and
add/remove them to groups, so as people join and leave the company,
they can be added/removed as database users at that time. However, I
don't want them to have to do it through the standard Access
users/groups interface, and I don't want...
|
by: zwasdl |
last post by:
When I swtich to design view from data view, the query results are
lost, and I have to run again to get it. Is there an option in access
to keep the data when I switching views? I know I can copy them to
other place, such as excel, but I'd prefer to keep them in access.
thanks,
Wei
|
by: pemigh |
last post by:
I'm almost done with an application, and trying to lock it down
tightly. But I still want users to be able to point to a new location
for the data file.
The code below fires off to detect and address the problem of a
moved/renamed data file. The problem: WITHOUT the "tdf.Attributes =
dbHiddenObject" line, my previously hidden tables are now visible.
(Not that the users will normally have the chance to see them, hidden
or not.)
|
by: Skijor |
last post by:
I just finished writing my first php script that manipulates a simple
shopping cart on a mySql database. I started with an example I found
on the web. The example hardcodes the database server, name, user, and
password in a php include file. This file is then included in every
php script that needs access to the database.
How do I make this scheme secure? I assume this is ok as long as this
file remains inaccessible on the webserver....
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
| |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |