473,320 Members | 1,794 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.

Protect Back-End Tables in Desktop Db - How?

Hi.

I have been working on an Access Db for awhile and am very close to
being ready to hand it over to the person who requested it. There will
be one user and the db will reside on a desktop PC.

Here's my dillemma? How do I insure that the user will not have access
to the tables? I'd hate for her to get curious and go in and "muck
around" with the data. I have the db split and have logic to disable
the "shiftkey bypass" on open. I plan to, also, convert the front-end
mdb to a front-end mde. However, what do I do with the back-end
(tables)? Is there a way to protect them?

I would like to keep the db split (front-end/back-end) so if
modifications are required in the future (to the
screens/reports/processing), I can just send a new front-end (I have the
'relink' logic in place on initial launching of application).

Any ideas for protecting the tables?

Thanks.

Regards,
SueB

*** Sent via Developersdex http://www.developersdex.com ***
Nov 13 '05 #1
3 3229
SueB wrote:
Hi.

I have been working on an Access Db for awhile and am very close to
being ready to hand it over to the person who requested it. There
will be one user and the db will reside on a desktop PC.

Here's my dillemma? How do I insure that the user will not have
access to the tables? I'd hate for her to get curious and go in and
"muck around" with the data. I have the db split and have logic to
disable the "shiftkey bypass" on open. I plan to, also, convert the
front-end mdb to a front-end mde. However, what do I do with the
back-end (tables)? Is there a way to protect them?

I would like to keep the db split (front-end/back-end) so if
modifications are required in the future (to the
screens/reports/processing), I can just send a new front-end (I have
the 'relink' logic in place on initial launching of application).

Any ideas for protecting the tables?


Access has User Level Security (fairly advanced topic) that would be the
surest method. Otherwise you just use varying levels of obfuscation. For
example, your BE file could be placed anywhere and given any name. The
extension doesn't even have to be "MDB". That might make it hard for the
user to even know what file to look at.
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Nov 13 '05 #2
I just put a simply little "autoexec" macro that runs in the back end..

I have that macro launch a msgbox command that says you don't have
permissions. The user clicks ok, and they are kicked out.

works 99% of the time, and take no more time then it does to write this
post...

and, if you disable the shift key by-pass, then it not locked up tight, but
does keep the average access user out....
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

Note that the "critical" setting seems to make the msgbox look much more
official!!!
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.

And, to disable the "shift key", simply grab my shift key utility here to
turn off the shift key by-pass

http://www.members.shaw.ca/AlbertKal.../msaccess.html
--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pl*****************@msn.com
http://www.members.shaw.ca/AlbertKallal
Nov 13 '05 #3
Albert,

Thank you so much for your suggestions. I'll be looking to incorporate
them shortly. And I must send a very big thank you for your Mail merge
routines. I was referred to your website for sample routines from
someone in this very forum. The Mail Merge works like a charm. I was
thrilled with the results.

Regards,
SueB

*** Sent via Developersdex http://www.developersdex.com ***
Nov 13 '05 #4

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

Similar topics

12
by: Danny | last post by:
Hello how can you protect the .mdb that an asp page modifies? This must be open to all for modifications right? But how can it be hidden so people can't just download it if they guess the path?...
3
by: Narlen | last post by:
Hi there, I don't know much about web design but I proudly managed to password protect a page on my site. Later I realized that everyone looking at the source in any web browser can see the...
15
by: Fady Anwar | last post by:
Hi while browsing the net i noticed that there is sites publishing some software that claim that it can decompile .net applications i didn't bleave it in fact but after trying it i was surprised...
9
by: Dakkar | last post by:
i saw something named obfuscator and its decompiling the source code of my program which written in c# and my program includes mysql root password inside of it is there anyway to protect my...
5
by: Brent Burkart | last post by:
I want to protect my website with a user and password. I have SQL Server 2000 where I want to store the users and passwords and the website is complete. I just need to add in some security with...
7
by: Alan Silver | last post by:
Hello, Sorry this is a bit wordy, but it's a pretty simple question... I have a web site, http://domain/ which is a public site, part of which (http://domain/a/) is protected by forms...
2
by: Back 9 | last post by:
Hello, In this news group I knew that Reflector for .NETis so cool. But on the other hand I want to hide my code from it. Is there any way to do that? TIA
12
by: =?Utf-8?B?am9uaWdy?= | last post by:
I wrote a simple VB.NET application that imports and edits CSV files. Now I’d like to “lock” the raw (pre-import) CSV files so these cannot be opened separately. It is not high-sensitive...
22
by: teejayem | last post by:
Hi, I am new to programming with databases and was wanting some help. Is there any way to password protect an access database and access sent sql commands to it via vb.net code? Any help...
3
by: Sin Jeong-hun | last post by:
It seems like the Protect() uses the Windows accout information to encrypt data. If I know the user name and the password, can I decrypt it on another PC? If it is not, how about the exported key?...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, youll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
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...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
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: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
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...

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.