Creating an MDE database in code

[Blondie]

I have arequirement to send out a database to be used by other personnel,
this database creates other databases for clients, I want the Client
databases created to be mde's so that no one can go in and mess with the code
or forms. Any ideas?

 

[Tom van Stiphout]

On Thu, 11 Mar 2010 12:48:01 -0800, Blondie

How about:
RunCommand acCmdMakeMDEFile

-Tom.
Microsoft Access MVP

 

[De Jager]

I have arequirement to send out a database to be used by other personnel,
this database creates other databases for clients, I want the Client
databases created to be mde's so that no one can go in and mess with the
code
or forms. Any ideas?

 

[david]

Never used to work. Does it work now? What version of Access?

(Never used to work because it runs on the Current database,
but the first part of making an MDE is close the Current database)

Old way of doing it was:

SysCmd 603, mdbFile, mdeFile

Where mdbFile is NOT CurrentDB. That can be run from a
script or from inside another Access application.

(david)