Help needed for changing of database extension from .mdb to .mde

S

Shay

I have an access application that will create new database during runtime. As
i need to transfers querys, tables and forms over to the newly created
database, i can only rename the database extension form .mdb to .mde only
after i had completed the transferring of those querys, tables and forms. Can
someone pls kindly show me how shud i start abt doing the change.

Thanks alot in advance,
 
S

Shay

As my newly created database have codes that i do not wish to allow people to
use special keys like the shift key to look at my code and tempt with it,
that is y i am onli trying to rename the database extension rather then to
manually make the .mde file.
 
P

Paul Overway

You're wasting your time. Anyone with Access can view the contents of an
MDB, whether or not the file extension is MDE....or anything else for that
matter. If you want to secure the source code, you must create a proper MDE
file.

If you want to prevent others from viewing your source code, you need to
make an MDE. Since you indicate that part of what your application does is
create forms in another database, you'll have to create them
programattically vs by importing. Tables and queries can be imported from
your MDE.
 
R

Rick Brandt

Shay said:
As my newly created database have codes that i do not wish to allow
people to use special keys like the shift key to look at my code and
tempt with it, that is y i am onli trying to rename the database
extension rather then to manually make the .mde file.
Click to expand...

Well you can give the file any extension you like and that won't change the
fact that it is an MDB. There is a Sys command (undocumented I believe)
that allows you to programatically produce an MDE, but I don't recall what
it is off-hand. If you Google these groups it should be easy enough to
find.
 
R

Rick Gittins

If you implemented security in the Access MDB you may be able to keep people
out of the design view of forms and modules.

Rick
 
S

Shay

okie...Thanks alot for your advice, i guess the only way is to program it
rather den renaming the extension den.Thanks alot
 
Top