Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 313
  • Last Modified:

Blocking someone from changing the extension on a Microsoft Access Database

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
kkenison
Asked:
kkenison
1 Solution
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
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
 
Jeffrey CoachmanMIS LiasonCommented:
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
 
aikimarkCommented:
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
 
kkenisonAuthor Commented:
Thank you very much for the help. This seems to work great.  Thanks again.
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now