I want to save a db as a MDE file from a module in another db using VBA/DAO
(acc2000). How?

Thanks

Murray

--
=====================================
Murray Ware
Reel Media Pty Ltd
61 3 9885 3870 ph
61 3 9885 0239 fx

I think Michka has documented this at www.trigeminal.com.  Or try
www.mvps.org/access.

Tony
----
Tony Toews, Microsoft Access MVP
   Please respond only in the newsgroups so that others can
read the entire thread of messages.
   Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
   VolStar http://www.volstar.com Manage hundreds or
thousands of volunteers for special events.

I believe it's SysCmd(603, "SourceDB", "TargetMDE"). (Undocumented and
Unsupported => If it formats your drive, then don't call MSFT, or me.
:-) )

But, I have to ask.  Given that the MDB -> MDE conversion is a
non-reversible process, and that I haven't seen folks converting
hundreds of databases to MDEs at once, isn't it safer to always
convert manually?

  -- Dev

IIRC if you call it like that in A2000 it fails silently. Instead you have
to call it as Application.Syscmd, or maybe even open a new instance of
Access via automation and use that to call Syscmd.

Michka is said to have posted about this a while ago but I can't find it.

--
(remove a 9 to reply by email)