Microsoft Access Protection - Workgroup Issues

vb123.com

Garry Robinson's Popular MS Access, Office and VB Resource Site

RSS & Newsletter
Join our XML/RSS Newsfeed or sign up for our informative newsletter on Office Automation, Access and VB topics
Read More

Get Good Help
If you need help with a database, our Professionals could be the answer
Read More

Is Your Database Corrupt ?
If you have a corrupt database, Try our Access Recovery service

The Workbench Find out who has your database open, start the correct version of Access, easy compacting and backups, change startup options, mde compile, shutdown database Read and Download

The Toolshed
Searchable help file comprising of all the information at vb123.com plus hidden downloads etc. Read More

The Toolbox
Libraries of software that we regularly import into our projects. This is a newer version of the Toolshed More..

Access >>> SQL
Upsize to SQL Server 2005 or 2008, easily repeated conversions, highly accurate SQL query
translation and web form conversion.
Read More

SharePoint
For our company file sharing and task management, we use
SharePointHosting

DryToast
Backup and query your BaseCamp® projects
Read More

Datamining/Graphs
Explore your data with this versatile graphing and data mining shareware tool. Read More

Garry's Blog
Find out a few other things that Garry has been writing about Microsoft Access. Read more

Like FMS Products?
Purchase them from us and get a free Workbench or Toolbox More

About The Editor Garry Robinson writes for a number of popular computer magazines, is now a book author and has worked on 100+ Access databases. He is based in Sydney, Australia
Contact Us ...

Search ...

or try our new site built with SharePoint Designer
vb123.com.au

Microsoft Access Protection - Workgroup Issues

A Note From A User

Hello, My name is Alex and I live in Switzerland.

I have been asked to secure an Access Database.

So I bought and read Garry's book "Real World Microsoft Access Database Protection and Security".

Then I have secured a sample database using user-level security.

But when I downloaded a trial version to crack user-level password I found out that the version is able to recover the ID of the owner of the Database even if it doesn't have the security file (*.mdw)

And so when you have the ID of the owner you just have to re-create whatever workgroup file and to re-create the owner in it and then you have full permission on everything?

Is there a way to prevent this to happen?

Thank you.

Alex.

Hi Alex

I totally agree with your diagnosis. When I wrote the book, there were 2 products that did this but quite a few that didn’t. By not writing about it in the book, I tried not to direct users to those products and if they downloaded a password cracker, it generally would require the workgroup file to work.

To solve the problem, you either/or need to produce a MDE to protect your code or hide the location of the files in Windows Folders. Generally though the Access workgroup security will act as a good policeman for the average user. If you have something really important, create smokescreens for that particular data.

Garry Robinson

Is Your Database Secure ? Need to know more about how to protect your database investment. Confused about Access security. Then have a look at the book that Garry is writing for Apress.
Click here for book link