By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,475 Members | 954 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,475 IT Pros & Developers. It's quick & easy.

Create .mde from .mdb with code or command line

P: n/a
How do I create a .MDE from a .MDB, in an automated way?

I.e. I want to compile a series of files, created on A97 onto A2000.

Converting to the A2000 version, that's a command line option,
but there is no such option to create a .MDE out of the .MDB and
I can't find vb-code that can do it; although the option is on the menu,
it is not in docmd.runcommand...

Any hints?
--
Regards,
Huibert.
Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
"Huibert" <pa******@hotmail.com> wrote in message news:<40*********************@news.inter.NL.net>.. .
How do I create a .MDE from a .MDB, in an automated way?

I.e. I want to compile a series of files, created on A97 onto A2000.

Converting to the A2000 version, that's a command line option,
but there is no such option to create a .MDE out of the .MDB and
I can't find vb-code that can do it; although the option is on the menu,
it is not in docmd.runcommand...

Any hints?


Search on .Syscmd 603 here.

This will not convert to a different version of Access afaik...

- John Mishefske
Nov 12 '05 #2

P: n/a
"Huibert" <pa******@hotmail.com> wrote:
I.e. I want to compile a series of files, created on A97 onto A2000.

Converting to the A2000 version, that's a command line option,
but there is no such option to create a .MDE out of the .MDB and
I can't find vb-code that can do it; although the option is on the menu,
it is not in docmd.runcommand...


Michael Kaplan at www.trigeminal.com has an MDE you can use to automatically convert
your MDB from A97 to A2000.

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
Nov 12 '05 #3

P: n/a
> > How do I create a .MDE from a .MDB, in an automated way?

I.e. I want to compile a series of files, created on A97 onto A2000.

Converting to the A2000 version, that's a command line option,
but there is no such option to create a .MDE out of the .MDB and
I can't find vb-code that can do it; although the option is on the menu,
it is not in docmd.runcommand...

Any hints?
Search on .Syscmd 603 here.

This will not convert to a different version of Access afaik...

- John Mishefske


Sorry, wasnt working on A2000...
But did find the right way to use .DoCmd.RunCommand acCmdMakeMDEFile:

Dim NAcc As Access.Application

Set NAcc = CreateObject("Access.Application")
'The following lines simulate accepting the default
'name, clicking Make MDE, and clicking Save
SendKeys MyPath & "{Enter}{Enter}"
SendKeys "{Enter}"
NAcc.DoCmd.RunCommand acCmdMakeMDEFile
Set NAcc = Nothing

Works great in A2k.
Thanks!

--
Groeten,
Huibert.
"almish" <mi****@execpc.com> schreef in bericht
news:95**************************@posting.google.c om... "Huibert" <pa******@hotmail.com> wrote in message

news:<40*********************@news.inter.NL.net>.. .
Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.