Is there a VB code that I can use to automatically compress and repair the database?
A accesser2003 Registered User. Local time Today, 19:13 Joined Jun 2, 2007 Messages 124 Aug 8, 2008 #1 Is there a VB code that I can use to automatically compress and repair the database?
ajetrumpet Banned Local time Today, 11:13 Joined Jun 22, 2007 Messages 5,638 Aug 9, 2008 #2 i believe the code is: Code:Copy to clipboard application.compactrepair
Alansidman AWF VIP Local time Today, 11:13 Joined Jul 31, 2008 Messages 1,493 Aug 9, 2008 #3 Take a look at this video. It may solve your issue. http://www.datapigtechnologies.com/flashfiles/schedulecompact.html Alan
Take a look at this video. It may solve your issue. http://www.datapigtechnologies.com/flashfiles/schedulecompact.html Alan
boblarson Smeghead Local time Today, 09:13 Joined Jan 12, 2001 Messages 32,059 Aug 9, 2008 #4 or some code here: http://www.btabdevelopment.com/main/CodeSnippets/tabid/104/Default.aspx