mde

  • Thread starter Nick 'The Database Guy'
  • Start date
N

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
 
B

Bernd Gilles

Nick said:
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
 
N

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
 
B

Bernd Gilles

Nick said:
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.
 
T

Tony Toews [MVP]

Bernd Gilles said:
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/
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Create a dynamic master file 1
mdb looks and acts like mde 3
Reverse Engineering MDE to MDB: how? 7
Recovery of .mdb file 8
Access 2007 and MDE file Question 9
MDE 2
utility.mda 0
Cannot create MDE files 6

Top