UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Compact/Repair from Start-up Command Line    
 
   
larissat
post Nov 14 2003, 04:28 PM
Post#1



Posts: 68
Joined: 23-October 03
From: PA


I have a database that has a form designated as the Start-Up form.
would like to schedule a compact/repair on a nightly basis.
From what I am seeing, I should be able to use: "databasename.mdb /compact" to compact and then close the database.
When I do this from a command line, it launches the database, and displays the Start-Up form instead of compacting.
So, I also tried adding "/nostartup", hoping that this would put not display the Start-Up form.
I think I must be missing something! Please advise!
Go to the top of the page
 
BenPurser
post Nov 14 2003, 05:36 PM
Post#2


UtterAccess VIP
Posts: 5,244
Joined: 29-October 01
From: Northern Virginia


Couldn't you just set your db up to compact on close? It's in Tools, Options....
therwise, see if r_cubed's post sheds any light....
HTH
Ben
Go to the top of the page
 
r_cubed
post Nov 14 2003, 06:08 PM
Post#3


UtterAccess VIP
Posts: 3,754
Joined: 8-November 02
From: Australia (NSW)


You m ight want to follow through on this thread as well, (it actually links to the one that Ben has already pointed you too), so uses the same script, but there was a bit more history about how THAT questioner ultimately got it all to work for him/her.
Go to the top of the page
 
larissat
post Nov 17 2003, 08:41 AM
Post#4



Posts: 68
Joined: 23-October 03
From: PA


Hi Ben and Rob,
initially had it set to "Compact on Close", but it is a multi-user environment, and it resulted in compacts being started but not finished because another user had the database open. I have the database set-up to warn all users to exit at 9:00pm, and then log them off if they're still in the database. Then, I wanted to schedule a compact/repair.
Go to the top of the page
 
roxz72
post Nov 17 2003, 10:52 AM
Post#5


UtterAccess VIP
Posts: 1,324
Joined: 19-October 01
From: Relocated to


Here are a couple other options from the code archive:
Schedule Compact1
Compact2
Backup & Compact
HTH
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    15th October 2019 - 04:12 PM