Make MDE in VB

[Guest]

In 2000 I have code that runs to build an mde file. It isn't working in
2002. Can anyone help? I got this from this usergroup. Thanks,

Set NAcc = CreateObject("Access.Application")
NAcc.SysCmd 603, sF & ".mdb", sF & ".MDE"

 

[Douglas J. Steele]

I can't say for certain, but given that Syscmd 603 is undocumented, it's
entirely possible that it's not available in all versions. That's a risk you
always run using undocumented features.

On the other hand, I'm extremely hard pressed to imagine a need to create an
MDE using code.

 

[david epsom dot com dot au]

Can you create the mde in the design environment?
Are you using workgroup security?

(david)

 

[david epsom dot com dot au]

On the other hand, I'm extremely hard pressed to imagine a

need to create an MDE using code.

14 referenced MDE's: 3 level structure (down from 4 levels),
plus startup configuration. It's the need to keep the mid
level libraries synchronised with the upper level library
that really calls for an automated build process.

 

[Guest]

I have one client that has about 50 different businesses that all use the
same front end and need to be relinked. I accomplish this through a db that
goes into the frontend, relinks to the appropriate business backend and makes
an mde and copies the mde to the appropriate business name and directory. I
was using some send keys to accomplish this but it was a little clunky. I
wish I had saved the original post because I believe the responder told me
the sysmd number for 2002. Thanks anyway.

 

[Guest]

I can create the mde in design environment, but it would be helpful in access
had a command to build the mde in vb. I am not using workgroup security.

 

[david epsom dot com dot au]

The syscmd value for make MDE has not changed. (Sorry,
I don't have 2002/2003 installed on this PC to check,
but the information has been published here previously
and has not been challenged).

So the next thing I would be looking at would be validity
of the application object you are using for the make.
What do get for
.syscmd 7
and for
.IsCompiled

(david)

 

[Guest]

I've got a reason for you...

I've got a client in Orlando FL. ( I live 2 hours north in Jacksonville) -
They run a split configured database I wrote. They have a copy of the source
code resident on a server. I created an updating application that when
opened, backs up their source / data / mde DBs. After that, it pushes new
objects to their source DB, modifies any tables in the backend. Last, it runs
any action queries that are necessary. The last thing that it is supposed to
do is create an MDE file. I've been looking for a way to do this
programmatically. I will try this undocumented method. THANKYOU LADYCES...

 

[Guest]

I can't seem to get that syscmd 603 to work correctly. I am using Access 2k.
What do you dimension as? Also, what references are set in the DB you use
that in? Thanks in advance.