make an mde file via vba

  • Thread starter Thread starter Ahmed
  • Start date Start date
A

Ahmed

hello,

is it possible to convert my mdb file into mde directly by wrinting a VBA
function ?

"RunCommand acCmdMakeMDEFile" does not work: i have a message saying that i
can not make an mde file while a VBA code is executing and it does not
allow me to specifie a target file name.

Thank you for your help.
 
You need to do it from outside your app. This is undocumented function, but
works for me:


Kill strOut
objAccess.SysCmd 603, strIn, strOut

Where objAccess is an Access application object. strIn is path and name for
your MDB. strOut is the path and name for your MDE (should not be the same
as strIn).
 
Thank you for your response,
it doesn't seem to work in my case, where did you get "603" from ?
 
Back
Top