please help me... how to compress an access database by vb6.0 coding

[idalreadyuse]

help me please... can somebody tell me how to compress an access database by vb6.0 coding?

[Killer42]

If you have a look in the Access section of the HowTo's area, I'm pretty sure this is covered.

[Killer42]

Also, here are links to some other discussions at TheScripts which covered this. (Note, the highlighting just reflects the search terms I entered to find them)...

http://www.thescripts.com/forum/thread656785-access+compact+code.html

http://www.thescripts.com/forum/thread627422-access+compact+code.html

http://www.thescripts.com/forum/thread729449-access+compact+code.html

[idalreadyuse]

thanks... i just got it.. but from different sources...
appreciate it

[idalreadyuse]

i have another question to ask:
i want to compress my database when close my form but why when i closed, it shows a message box says that the database were used exclusively by admin

can somebody give me the solutions please....

[QVeen72]

Hi,

Before writing the Code for Compact, you have to Close the Connection to database. You may also get that error, if the database is "Password" protected.. you will have to pass the Pwd in Compact statement.
Check this :

DBEngine.Compac tDatabase "C:\MyDB.md b" _
,"C:\NewDB.mdb" , , , ";pwd=mypwd "

Regards
Veena