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

[Guest]

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,

 

[Rick Brandt]

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,

Why are you renaming from MDB to MDE? That accomplishes nothing. The creation
of an MDE involves a lot more than just changing the name.

 

[Guest]

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.

 

[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.

 

[Rick Brandt]

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.

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.

 

[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

 

[Guest]

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