Database back end hidden

kabir_hussein

Registered User.
Local time
Today, 23:20
Joined
Oct 17, 2003
Messages
191
Hi i have done a database and was wondering if there is a way you can hide the forms and also dont allow people to click on design form.

I want the users only to see the forms and prevent them from touching the back end of the database i.e. the tables etc

many thanks
 
many thanks for the advice, but how do i change the extentions form mdb to mde.
 
Hi

many thanks for the reply i tried to change it the way you said and all i get is a dialog box saying MS access can not create mde

any idea what could be doing wrong

kabir
 
hi

thanks for replying, i have tried the compact and repair, and that worked fine what is a compile error.

thank you
kabir
 
Convert Database from MDE to MDB format

Just changing a file's extension doesn't do anything. You need to create the .mde. Go to Tools/Database Utilities/make .mde. If the option is greyed out, compile your db and fix any compile errors.

I tried this, works great. If I need to change the convert the database back from mde to mdb, is there a way to do this ?
 
I believe there is no way to do so. But there are some companies providing third part tools that will change property of the db like shiftbypasskey so that you could see its objects. But you can not design any forms, reports or module. Rest object you can.

Ashfaque
 
By creating a mde file you should have create a different file. The mdb should be unaffected. The mdb you treat as a development environment the mde as the Client version. The data should be in a separate (mdb) file.

There is also a switch of msaccess.exe /decompile which decompiles VB code and then you open a Module and Compile and Save All Modules. This can be performed periodically and is uselful after major changes.

Simon
 

Users who are viewing this thread

Back
Top Bottom