By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,962 Members | 1,997 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,962 IT Pros & Developers. It's quick & easy.

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

P: 4
help me please... can somebody tell me how to compress an access database by vb6.0 coding?
Jan 9 '08 #1
Share this Question
Share on Google+
5 Replies


Expert 5K+
P: 8,434
If you have a look in the Access section of the HowTo's area, I'm pretty sure this is covered.
Jan 9 '08 #2

Expert 5K+
P: 8,434
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/thre...pact+code.html
http://www.thescripts.com/forum/thre...pact+code.html
http://www.thescripts.com/forum/thre...pact+code.html
Jan 9 '08 #3

P: 4
thanks... i just got it.. but from different sources...
appreciate it
Jan 9 '08 #4

P: 4
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....
Jan 9 '08 #5

QVeen72
Expert 100+
P: 1,445
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.CompactDatabase "C:\MyDB.mdb" _
,"C:\NewDB.mdb", , , ";pwd=mypwd"

Regards
Veena
Jan 9 '08 #6

Post your reply

Sign in to post your reply or Sign up for a free account.