mde
in [General]
|
From: Nick 'The Database Guy' on 21 May 2010 05:00 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
From: Bernd Gilles on 21 May 2010 05:24 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/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 -- regards, Bernd --- Access goes Subversion - http://oasis.dev2dev.de
From: Nick 'The Database Guy' on 21 May 2010 06:29 On May 21, 10:24 am, Bernd Gilles <newsgro...(a)gilles-family.de> 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/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 > > -- > 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
From: Bernd Gilles on 21 May 2010 08:12 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
From: Daniel Pineault on 21 May 2010 08:30 Nick, Your original post had already been answered yesterday. http://www.microsoft.com/office/community/en-us/default.mspx?&lang=en&cr=US&guid=&sloc=en-us&dg=microsoft.public.access&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. "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 > . >
|
Next
|
Last
Pages: 1 2 Prev: Access 2007 - "if-then" rules for selecting lists in a form? Next: Access 2007 |