Solved

Blocking someone from changing the extension on a Microsoft Access Database

Posted on 2013-10-23
4
285 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
4 Comments
 
LVL 57
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 45

Accepted Solution

by:
aikimark earned 250 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

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

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

It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

738 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