473,320 Members | 1,600 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Securing both front end and back end

I have a 2K database with a front end linked to a back end. I need to lock
down or secure both ends so a user can not access the raw data in tables
etc. I also need usernames and passwords for 50+ users. I've experimented
with securing the database but can't get it the way I want it. I can still
use the shift key to obtain access. Anyone have a link to a site or
something to give me a guideline as to what I can do?

Thanks
Jan 20 '06 #1
4 3868
You need Jamie's Software - Access Property Editor.

Download from http://www.jamiessoftware.tk/

Jan 20 '06 #2
On Fri, 20 Jan 2006 12:55:10 GMT, "Brad P" <br******@hotmail.com>
wrote:

Well, Access security is better than that. But you'll have to
download, study, and fully understand MSFT's security FAQ before
proceeding.
Yet this Access security can be cracked. If you really need strong
security, Access is not the best platform. But then you already knew
that, because you did your research *before* you started.

-Tom.

I have a 2K database with a front end linked to a back end. I need to lock
down or secure both ends so a user can not access the raw data in tables
etc. I also need usernames and passwords for 50+ users. I've experimented
with securing the database but can't get it the way I want it. I can still
use the shift key to obtain access. Anyone have a link to a site or
something to give me a guideline as to what I can do?

Thanks


Jan 20 '06 #3
I just need to prevent the average user from getting into the backend of my
application. My application doesn't contain critical data. The previous post
with APE may be my ticket. Thanks for that!

"Tom van Stiphout" <no*************@cox.net> wrote in message
news:hc********************************@4ax.com...
On Fri, 20 Jan 2006 12:55:10 GMT, "Brad P" <br******@hotmail.com>
wrote:

Well, Access security is better than that. But you'll have to
download, study, and fully understand MSFT's security FAQ before
proceeding.
Yet this Access security can be cracked. If you really need strong
security, Access is not the best platform. But then you already knew
that, because you did your research *before* you started.

-Tom.

I have a 2K database with a front end linked to a back end. I need to lockdown or secure both ends so a user can not access the raw data in tables
etc. I also need usernames and passwords for 50+ users. I've experimented
with securing the database but can't get it the way I want it. I can stilluse the shift key to obtain access. Anyone have a link to a site or
something to give me a guideline as to what I can do?

Thanks

Jan 20 '06 #4
Actually, to keep my users out of the back end, and front end code/forms
etc, you don't need any security..or even any code for that matter.

You most certainly can, and should hide all of the ms-access interface. The
options to complete hide and keep people out of the ms-access interface can
easily be done using the tools->start-up options. Using those options allows
you to complete hide the ms-access interface (tool bars, database window
etc). Also, using these options means you do not have to bother setting up
security. And, if you deploy a mde..then things are well locked up.

Try downloading and running the 3rd example at my following web site that
shows a hidden ms-access interface, and NO CODE is required to do
this....but just some settings in the start-up.

Check out:

http://www.members.shaw.ca/AlbertKal...s/DownLoad.htm

After you try the application, you can exit, and then re-load the
application, but hold down the shift key to by-pass the start-up options. If
want, you can even disable the shift key by pass. I have a sample mdb file
that will let you "set" the shift key bypass on any application you want.
You can get this at:

http://www.members.shaw.ca/AlbertKal.../msaccess.html

For the back end...I just put in a autoexec macro..and tha keeps them
out...I use:

So, I make a macro called AutoExec. In the macro, I put the following code:

Action Parms
Msgbox message:You do not have permissions to run this file
Beep: Yes
Type: Critical
Title: Can not run

Quit: Options:Exit

As an alterative, you an make a nice little form in the back end, and set
the startup options to run that form that displays a message, and then when
they click ok...you do a application.quit. Eithway..this keep 99% of the
users out..as they think they don't have persmissions...
--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pl*****************@msn.com
http://www.members.shaw.ca/AlbertKallal
Jan 22 '06 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Matt | last post by:
I always heard people saying IIS ASP front end, and MS-SQL back end. ASP is for server side programming and dynamic content generation, how could it is called front end? Because I thought it is...
11
by: Susan Bricker | last post by:
Greetings. I am looking for some advice on making a database secure. By secure, I mean that I want only certain people to have write access to the database and I want the updates to be permitted...
4
by: John Baker | last post by:
Hi: I have an application that has a back end and a front end. I need to add a table which is identical to one in the back end, and then use it for a temporary holing place form some records. I...
11
by: Wm. Scott Miller | last post by:
Hello all! We are building applications here and have hashing algorithms to secure secrets (e.g passwords) by producing one way hashes. Now, I've read alot and I've followed most of the advice...
4
by: Stephen Poley | last post by:
Whenever anyone has a question about securing an Access database he/she is usually referred (unsurprisingly) to the Security FAQ. This is however incomplete/unclear with respect to databases with a...
5
by: The alMIGHTY N | last post by:
Hi all, Let's say I have a simple math formula: sum (x * y / 1000) / (sum z / 1000) I have to do this across 50 items, each with an x, y and z value, when the page first loads AND when a...
10
by: Les Desser | last post by:
In article <fcebdacd-2bd8-4d07-93a8-8b69d3452f3e@s50g2000hsb.googlegroups.com>, The Frog <Mr.Frog.to.you@googlemail.comMon, 14 Apr 2008 00:45:10 writes Thank you for that. It was very...
8
by: Albert D. Kallal | last post by:
You most certainly can, and should hide all of the ms-access interface. The options to complete hide and keep people out of the ms-access interface can easily be done using the tools->start-up...
14
by: Brian Nelson | last post by:
Sorry for the long post, I've tried so hard to solve this one but I'm just stuck! We've had a multiuser .mdb file on a network share for years. I know it's not ideal, but it's worked well from...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.