MS Access Database Security

suarve · 2 Oct 2007 at 16:10

Hi,

I have an pre-made access database that allows me execute some simple sql based on 3 or 4 tables and output the results. The databse is in .mdb format and has been secured so i am only able to view and use a single form. However, i'd like to know how this was done exactly and would like to view the code behind some of the buttons for learning purposes. I have a copy of the database but am slightly hesitant to make it available publicly as it was from a course i attended in the past.

Could anyone pioint me in the right direction on how a database can be secured in the way described above? If a copy of the db is needed just say.

Thanks for any help

~J~ · 2 Oct 2007 at 17:48

Let me get this right.

You have an Access database, and you just want to protect it similar to the one you already have?

If that's the case, I can't remember the exact menu names, but in the Tools menu of Access, there should be an option to "Create MDB", which will compile and compact the database into an 'almost' standalone database which no one can look at.

Just make sure you don't lose the uncompiled version!

Mel_P · 2 Oct 2007 at 22:03

Just try holding the shift key down when it loads - that may give you access to the database window?

Mel P

RockLobster · 3 Oct 2007 at 08:53

If the shift key doesn't work you will have to create a new database and import all the tables into your new db.

suarve · 3 Oct 2007 at 15:01

Mel_P said:
Just try holding the shift key down when it loads - that may give you access to the database window?

Mel P

Was the first thing i tried, this doesn't work unfortunately.

suarve · 3 Oct 2007 at 15:06

~J~ said:
Let me get this right.

You have an Access database, and you just want to protect it similar to the one you already have?

If that's the case, I can't remember the exact menu names, but in the Tools menu of Access, there should be an option to "Create MDB", which will compile and compact the database into an 'almost' standalone database which no one can look at.

Just make sure you don't lose the uncompiled version!

Does creating an mdb clear all the standard access menus too - like in the example below:

http://img258.imageshack.us/img258/9691/axshi6.png

Cheers

~J~ · 3 Oct 2007 at 15:24

suarve said:
Does creating an mdb clear all the standard access menus too - like in the example below:

http://img258.imageshack.us/img258/9691/axshi6.png

Cheers

Yep.

What you're doing is using the Access backend, but all the forms, tables, queries, modules, code, etc, all gets almost compiled into a standalone product that you can distribute.

suarve · 3 Oct 2007 at 18:46

~J~ said:
Yep.

What you're doing is using the Access backend, but all the forms, tables, queries, modules, code, etc, all gets almost compiled into a standalone product that you can distribute.

Cheers buddy!