Database back end hidden

[kabir_hussein]

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

 

[kabir_hussein]

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

 

[kabir_hussein]

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

 

[kabir_hussein]

hi

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

thank you
kabir

 

[DBFIN]

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 ?

 

[Ashfaque]

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

 

[Simon_MT]

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