Locking Objects In an Ms Access Front End Database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I have split the database (Ms Access 2002) into Front End and Back End so as
to facilitate multiple users to work on the Back End. Everything is looking
but for the users being able to add the tables, queries and other objects.

The users can access data through the forms and it is only through the
various functions provided by the form that I want them to manipulate data
and not manually enter into tables and queries and modify them. Similarly
they should not be allowed to modify the forms and reports as well.

Essentially i want all the objects to be locked to the user and the only
means of manipulating data is through Forms that I have Provided.

Any help in this regard is highly appreciated.

Cheers,

Pradeep
 
Tools
Startup
Un-click the "Display Database Window"


Alternately or in conjunction, you can also put a password on the
Code. This, however complicates debugging.

Ron
 
Making your FE an mde will stop people messing around with forms and reports.
However to completely lock down your FE you will need to implement user-level
security.
 
Hello Norman,

Thanks for the quick response.

I have created a .MDE from the front end file. When the user opens it, he
finds the database window button enabled and when he clicks on that the
database with all the linked tables, queries , reports and forms is appearing.

Out of curiosity, took a new database (which is not split) and created an
MDE. When i opened it(MDE) on a different machine, i found the same Database
Window toolbar button open and it showed all the objects when clicked on it.

I was anticpating that an MDE would not give an access to reports, forms and
macros at all.

Am i doing anything wrong?

iIf the MDE file doesn't give access to all the objects. Then your
suggestion added to the suggestion made by Ron would meet my requirement.

Please suggest!!!

I appreciate everyone in the chain trying to help me out :-)

Cheers,

Pradeep
 
Hello,

Something was wrong with that copy of the database.

I have taken a fresh copy and tested it. Everything looks good.

Thanks for all the help.

Cheers,

Pradeep
 
Back
Top