Hi ng

I use the following code to create a MDE file from vba. I have office 2003,
but the database is build in Access 2000. It works fine on my computer. But
when I run the code on a machine with Access 2000 - it does not work - any
ideas?

TIA
jj

The code:
Function CreateMDEDatabase(strDB As Variant)
Dim a As New Access.Application
Dim strMDE As String

strMDE = Left(strDB, Len(strDB) - 3) & "mde"

a.SysCmd 603, strDB, strMDE
Set a = Nothing

End Function

MDE's require being built in their own format. Although the default format
of 2002/2003 is 2000, you must convert to the 2002/2003 format to build the
MDE, which then won't run on an Access 2000 machine.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

"jj" <(E-Mail Removed)> wrote in message
news:uJ%(E-Mail Removed)...
> Hi ng
>
> I use the following code to create a MDE file from vba. I have office
> 2003, but the database is build in Access 2000. It works fine on my
> computer. But when I run the code on a machine with Access 2000 - it does
> not work - any ideas?
>
> TIA
> jj
>
> The code:
> Function CreateMDEDatabase(strDB As Variant)
> Dim a As New Access.Application
> Dim strMDE As String
>
> strMDE = Left(strDB, Len(strDB) - 3) & "mde"
>
> a.SysCmd 603, strDB, strMDE
> Set a = Nothing
>
> End Function
>