Mary Ann Thom
asked on
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.
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you very much for the help. This seems to work great. Thanks again.
1. Distribute as a MDE (source code stripped out).
2. Perform a check at startup for being in runtime mode:
If application.SysCmd(acSysCm
Msgbox....
Application.Quit
End if
Jim.