Convert MDE to MDB using Visual Basic or Script

  • Thread starter ddomanilatgmaildotcom
  • Start date
D

ddomanilatgmaildotcom

Hello All,

I'm trying to automate a process in which a step involves converting
and Access 2000 MDB into an MDE.

Is there a way to do this via a script or by creating a Visual Basic
app? All help would be greatly appreciated.

Thanks...
 
D

Douglas J. Steele

While I have to admit I've never understood why anyone would have a need to
do this programmatically, there is an undocumented feature you can use:

Dim a As Access.Application
Set a = New Access.Application
a.SysCmd 603, "db2.mdb", "db2.mde"
Set a = Nothing
 

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

Top