Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Blocking someone from changing the extension on a Microsoft Access Database

Posted on 2013-10-23
4
Medium Priority
?
305 Views
Last Modified: 2013-10-28
Does anyone happen to know if there is a way that I can block a user from chaning the file extension on a access database.  The project that I am working on allows me to put a copy of a form on someones desktop that lets them fill in the information and upload it to my database.  The file that I place on there desktop is .accdr.  Works great.  But if someone changes the file extension to a .accdb then they can get into the database and find out where the information is being stored.  I know by default file extensions are hidden but a lot of my employees have them shown and know how to show them. I know I should have designed this database in SQL but I am not to good at that haha.  Any advice would be greatly appreciated.
0
Comment
Question by:kkenison
4 Comments
 
LVL 58
ID: 39594331
You have to:

1. Distribute as a MDE (source code stripped out).

2. Perform a check at startup for being in runtime mode:

If application.SysCmd(acSysCmdRuntime)  = False then
   Msgbox....
    Application.Quit
End if

Jim.
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 39594401
if someone changes the file extension to a .accdb then they can get into the database and find out where the information is being stored.
Even if you create an MDE/accde file, they can still (if they know how) see where the linked table points to... (Select the table, and hover the mouse over the name)

I am sure there may be a way to "lock this down", so lets see what Jim or another expert may have up their sleeves...


JeffCoachman
0
 
LVL 46

Accepted Solution

by:
aikimark earned 1000 total points
ID: 39594446
1. don't use permanently attached tables -- use dynamic or encrypted SQL with the IN clause that points to the destination/source database.
2. encrypt any local data that might help a hacker/cracker
0
 

Author Closing Comment

by:kkenison
ID: 39607141
Thank you very much for the help. This seems to work great.  Thanks again.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

972 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question