Need to create an MDE from VBA/VB code.

Microsoft recommends using sendkeys(!!),
but I need to create an mde from a database
the network while using a local database using
oode only i.e. no user involvement.

This is a very small databsae, with only one
table, but it needs to be created with a unique
name and placed in a different folder on the network
on a regular basis.

Answered in comp.databases.ms-access but here is a copy:

SysCmd 603, <source .MDB database>, <destination .MDE database>

SysCmd 603, "C:\TEMP\TEST.MDB", "C:\TEMP\TEST.MDE"

Note: might not work in A2002; can't verify but works in previous versions.

--
'-------------------------------
' John Mishefske
'-------------------------------