Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.clipper.visual-objects > #2433
| 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 |
[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
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