mde

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

Nick 'The Database Guy' schrieb:
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/...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

--
regards, Bernd
---
Access goes Subversion - http://oasis.dev2dev.de

On May 21, 10:24*am, Bernd Gilles wrote:
Nick 'The Database Guy' schrieb:

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

--
regards, Bernd
---
Access goes Subversion -http://oasis.dev2dev.de

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

Nick 'The Database Guy' schrieb:
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.

--
regards, Bernd
---
Access goes Subversion - http://oasis.dev2dev.de

Nick,

Your original post had already been answered yesterday.

http://www.microsoft.com/office/comm...f-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.



"Nick 'The Database Guy'" wrote:

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 wrote:

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