Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

compacting database

Status
Not open for further replies.
tjm77

tjm77

Programmer
Oct 2, 2000
15
US
Is there anyway to run the database utility Compact through the use of VBA??
I want to set up a button that will compact the database just by clicking and not going to tools, etc...
 
Sort by date Sort by votes
Start here thread181-118496
Or seach on "Compact" in this and other forums.
 
Upvote 0 Downvote
or since you are going to have the menus available, just create a macro with one action

SendKeys

and for the keystrokes, enter
%(tdc)

and for Wait, enter
No

PaulF
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

ameedoo3000
  • Locked
  • Question
switch between two open database
Replies
12
Views
1K
Andrzejek
Andrzejek
grnzbra
  • Locked
  • Question
Using Access Database Without Having MS Access
Replies
9
Views
6K
grnzbra
grnzbra
PizMac
  • Locked
  • Question
error 3027 database or object is read-only
Replies
5
Views
796
PizMac
PizMac
TheresAlwaysAWay
  • Locked
  • Question
Long-established database suddenly giving error Cannot open macro [Name] because it is not valid
Replies
6
Views
882
dhookom
dhookom
LondonJohn
  • Locked
  • Question
Problem using Access 2003 and 2007 for the same database
Replies
4
Views
563
LondonJohn
LondonJohn

Part and Inventory Search

Sponsor

Back
Top