make an mde file via vba

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

 

[Paul Overway]

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

 

[Ahmed]

Thank you for your response,
it doesn't seem to work in my case, where did you get "603" from ?

 

[Ahmed]

i forgot, i found this on the web
http://www.trigeminal.com/lang/1036/utility.asp?ItemID=6#6

a small add-on supposed to enabled a ConvertDatabase Method to make an mde
file

let's try !