View Single Post
  #1 (permalink)  
Old August 5th, 2004, 10:38 PM
Tasha Tasha is offline
Authorized User
 
Join Date: Jul 2004
Location: seremban, negeri sembilan, Malaysia.
Posts: 24
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to Tasha Send a message via Yahoo to Tasha
Default compacting access


hi there,
a manufacturing machine connected to front-end and everytime the machine reset the data will be transfer to front-end(access).the data from front-end later will be transfer to the main server(SQL).Problems occurs when data transfer to the SQL from front-end because of network connections.this will overload the access and evrytime i have to compact and repair it.is there anyway i can automated the compacting of the database through code? any help will be really appreciated.

thanks.

tasha
__________________
tasha
Reply With Quote