mde

[Nick 'The Database Guy']

Hi Everybody,

Does anyone know if there is a way of saving an access mdb as a .mde
file using code, if there is I would be very grateful of some pointers
in the right direction on how it is done.

Kind regards,

Nick

 

[Bernd Gilles]

Does anyone know if there is a way of saving an access mdb as a .mde
file using code, if there is I would be very grateful of some pointers
in the right direction on how it is done.

http://www.trigeminal.com/lang/1031/utility.asp?ItemID=8#8

or

SysCmd 603 , "YourMdb", "YourMde"

maybe you have to use a new access-instance for this

Dim AccApp As Access.Application
Set AccApp = CreateObject("Access.Application")

AccApp.SysCmd 603 , "YourMdb", "YourMde"

Set AccApp = Nothing

 

[Nick 'The Database Guy']

http://www.trigeminal.com/lang/1031/utility.asp?ItemID=8#8

or

SysCmd 603 , "YourMdb", "YourMde"

maybe you have to use a new access-instance for this

Dim AccApp As Access.Application
Set AccApp = CreateObject("Access.Application")

AccApp.SysCmd 603 , "YourMdb", "YourMde"

Set AccApp = Nothing

Thankyou Bernd,

I took your code, inserted appropriate in place of "YourMdb" and
"YourMde" and was pleased when it compiled and even more pleased when
it ran without falling over, but I was a little disappointed when it
failed to create anything! And ideas where I might be going wrong?

Nick

 

[Bernd Gilles]

I took your code, inserted appropriate in place of "YourMdb" and
"YourMde" and was pleased when it compiled and even more pleased when
it ran without falling over, but I was a little disappointed when it
failed to create anything! And ideas where I might be going wrong?

you can only use this to make an mde from another mdb.
have you tried to make a mde from your currently running mdb?

then you should use the tool from trigeminal - you can't make an mde from your active mdb via code.

 

[Daniel Pineault]

Nick,

Your original post had already been answered yesterday.

http://www.microsoft.com/office/com...&p=1&tid=3ad55da5-4938-42e4-8b8f-398efbfc3be7
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.

 

[Tony Toews [MVP]]

http://www.trigeminal.com/lang/1031/utility.asp?ItemID=8#8

or

SysCmd 603 , "YourMdb", "YourMde"

maybe you have to use a new access-instance for this

No, you don't need a new access instance. However you can't be
running the code from the database you wish to make the MDE. You have
to run it from an external "utility" mdb.

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/
Granite Fleet Manager http://www.granitefleet.com/