Group: Forum Members
Last Login: 3/10/2006 1:46:57 PM
Posts: 1,
Visits: 12
We currently use a batch file to stop the ARAS service and run backup of the database nightly. We would like to roll a few more lines into this file to automate the re-indexing utility as well.
Can someone help us with the proper syntax for the commands needed to accomplish this?
Group: Administrators
Last Login: Yesterday @ 7:45:59 AM
Posts: 1,866,
Visits: 4,324
Hello L.P.
Indexing is an internal and highly advanced function of the AyaNova CE program and can not be run externally from the AyaNova program.
But you can utilize a batch file command to compact the AyaNova database if have Access 2000 SP1 or higher and no one is accessing the AyaNova database. Compacting is similar to defragging - it cleans up and shrinks the size of the database depending on how many records have been deleted or edited between compacting.
If you do not have MS Access version 2000 SP1 or higher, do not utilize as older versions of Access can harm the database due to a serious bug.
The command line syntax to use would be:
(path)msaccess.exe (path)scdata.sc /compact
For example, running MS Access 2003 on my local computer to compact the local AyaNova database on my station, the batch file would contain the command line:
Let us know this works for you and if you have additional questions.
The next version AyaNova will index on the fly - managers will not need to ensure all users out and than run an indexing feature. Refer to AyaNova v3 (the next generation AyaNova) on this forum site for more information on upcoming features.
You cannot post new topics.
You cannot post topic replies.
You cannot post new polls.
You cannot post replies to polls.
You cannot edit your own topics.
You cannot delete your own topics.
You cannot edit other topics.
You cannot delete other topics.
You cannot edit your own posts.
You cannot edit other posts.
You cannot delete your own posts.
You cannot delete other posts.
You cannot post events.
You cannot edit your own events.
You cannot edit other events.
You cannot delete your own events.
You cannot delete other events.
You cannot send private messages.
You cannot send emails.
You may read topics.
You cannot rate topics.
You cannot vote within polls.
You cannot upload attachments.
You cannot download attachments.
You cannot post HTML code.
You cannot edit HTML code.
You cannot post IFCode.
You cannot post JavaScript.
You cannot post EmotIcons.
You cannot post or upload images.
Posted 10/12/2005 2:40:19 PM
