msaccess publish accde vba command

I need a command to save and publish a db as an accde via vba.
Who is Participating?
Jeffrey CoachmanMIS LiasonCommented:
I don't think there is a way to do this via VBA...

The closest thing I could find was:
DoCmd.RunCommand acCmdMakeMDEFile

But the error was that this cannot be run on the open database, through VBA ...

So this sounds similar to Compact/Repair utility, ...where you cannot run code to compact the DB you are currently in...
akivashapiroAuthor Commented:
Apparently this cannot be done in Access above 2003.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.