Create a MDE file using VBA

[jj]

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

 

[Arvin Meyer [MVP]]

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