Compacting access database using VB

H

Hashish

Hi,

This is actually an MS Access problem, but i thought i'd put it here as
well. If anyone can help....

I am working on a database and on a specific form i have a button for
'Compact Database'. Now the code i use to compact onClick of the button is:

CommandBars("Menu Bar").Controls("Tools").Controls("Database
utilities").Controls("Compact and repair database...").accDoDefaultAction

This works fine except if a guy in say, japan, uses it and has a japanese
language pack, then access cant find "Menu Bar", "Tools", etc. cause they are
in english in the code and in japanese in access and a problem occurs.

so i wanted to know if there is a different way to compact where i could
probably use some internal properties etc. and where language wont be a
problem. I need to compact an active database....
 

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

Similar Threads

Compacting Database through VB 8
Dynamic Naming of Form Button 3
compact database in VBA access 2007 5
Compact Database 2
Help creating a search form in Access XP 0
"Compile error in table level validation expression " after format 0
Access 2007 does not like this code 1
Comapct and Repair in Access 2007 2

Top