Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.lang.clipper.visual-objects > #2433

Re: Create MDB file

Message-ID <4EC0E265.5F8C21B3@telenet.be> (permalink)
From Frans Wauters <fwa@telenet.be>
Newsgroups comp.lang.clipper.visual-objects
Subject Re: Create MDB file
References <4EBBB4A0.D5898B11@telenet.be>
Organization telenet.be
Date 2011-11-14 10:41 +0100

Show all headers | View raw


[Multipart message — attachments visible in raw view] - view raw

FUNCTION MDB_CompactDatabase( cFilename, cPassword, lEncrypt ) AS LOGIC

 // http://msdn.microsoft.com/en-us/library/bb237197(v=office.12).aspx

 LOCAL oJetEngine AS OLEAUTOOBJECT
 LOCAL cSource  AS STRING
 LOCAL cTarget  AS STRING

 Default( @cFilename, "C:\ACCESS.MDB" )
 Default( @cPassword, "Password" )
 Default( @lEncrypt, TRUE )

 IF File( "C:\TARGET.MDB" )
  IF !FErase( "C:\TARGET.MDB" )
   RETURN FALSE
  ENDIF
 ENDIF

 cSource :=             "Provider=Microsoft.Jet.OLEDB.4.0;"
 cSource := cSource + "Data Source=" + cFilename + ";"
 cSource := cSource + "Jet OLEDB:Encrypt Database=" + IIF( lEncrypt, "True",
"False" ) + ";"
 cSource := cSource + "Jet OLEDB:Database Password=" + cPassword + ";"
* cSource := cSource + "Jet OLEDB:Engine Type=5" // 4 = Access 97, default:
5 = Access 2000

 cTarget :=             "Provider=Microsoft.Jet.OLEDB.4.0;"
 cTarget := cTarget + "Data Source=" + "C:\TARGET.MDB" + ";"
 cTarget := cTarget + "Jet OLEDB:Encrypt Database=" + IIF( lEncrypt, "True",
"False" ) + ";"
 cTarget := cTarget + "Jet OLEDB:Database Password=" + cPassword + ";"
* cTarget := cTarget + "Jet OLEDB:Engine Type=5" // 4 = Access 97, default:
5 = Access 2000

 oJetEngine := OLEAutoObject{ "JRO.JetEngine" }
 oJetEngine:CompactDatabase( cSource, cTarget ) // note: to compile, set
compiler warning to none
 oJetEngine := NULL_OBJECT

 Collect()

 IF File( "C:\TARGET.MDB" )
  DeleteFile( cFilename )
  FRename( "C:\TARGET.MDB", cFilename )
 ENDIF

 RETURN TRUE

Back to comp.lang.clipper.visual-objects | Previous | Next — Previous in thread | Find similar | Unroll thread


Thread

Create MDB file Frans Wauters <fwa@telenet.be> - 2011-11-10 12:25 +0100
  Re: Create MDB file "Willie Moore" <williem@wmconsulting.com> - 2011-11-10 12:29 -0600
    Re: Create MDB file Frans Wauters <fwa@telenet.be> - 2011-11-11 09:55 +0100
      Re: Create MDB file Johan Nel <johan.nel@xsinet.co.za> - 2011-11-11 01:39 -0800
  Re: Create MDB file E®!k \\/!$$E® <nospam@nospam.url> - 2011-11-11 10:36 +0100
  Re: Create MDB file Johan Nel <johan.nel@xsinet.co.za> - 2011-11-11 02:08 -0800
  Re: Create MDB file Frans Wauters <fwa@telenet.be> - 2011-11-14 10:41 +0100
  Re: Create MDB file Frans Wauters <fwa@telenet.be> - 2011-11-14 10:41 +0100

csiph-web