ODBC Exports

I have used a product called HAL (Handy Access Launcher) in the past. I
think it was free.


Thank You,

Dale E. Schuerman
Senior Consultant
RAM Software Systems, Inc.
972-669-0763 x233 (voice)
972-669-9603 (fax)
mailto:dale.schuerman@... (email)
http://www.ramsys.com (website)



-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Brian Stenglein
Sent: Wednesday, May 25, 2005 2:18 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: ODBC Exports

We use a product called Total Visual Agent for scheduling processes in
Access. We have only used it to schedule macros to run overnight, but
you can certainly schedule it hourly. You'd probably want to have it
running on a PC that is set aside or a server that isn't doing a whole
lot so the updating can be done without interrupting a user's
workstation.

TVA costs $299 and is available at www.fmsinc.com.

HTH,

Brian Stenglein
Clow Stamping Co.

--- In vantage@yahoogroups.com, "kbheec" <kbh@e...> wrote:
> My production scheduler would like to run exports out of Vantage using

> ODBC to access. He would like to run them automatically every hour.
> Does anyone do this and if so what tool do you use to automate the
> process?
>
> Thanks,
> Kathy Hambleton
> Electron Energy Corporation
> 717-898-2294
> Fax: 717-898-0660




Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links






########################################################################
Attention:
This email message is privileged and confidential. If you are not the
intended recipient please delete the message and notify the sender.
Any views or opinions presented are solely those of the author.

This email message has been scanned for Viruses and Content and cleared
by MailMarshal SMTP

For more information go to http://www.ramsys.com
########################################################################
My production scheduler would like to run exports out of Vantage
using
ODBC to access. He would like to run them automatically every hour.
Does anyone do this and if so what tool do you use to automate the
process?

Thanks,
Kathy Hambleton
Electron Energy Corporation
717-898-2294
Fax: 717-898-0660
We use a product called Total Visual Agent for scheduling processes in
Access. We have only used it to schedule macros to run overnight, but
you can certainly schedule it hourly. You'd probably want to have it
running on a PC that is set aside or a server that isn't doing a whole
lot so the updating can be done without interrupting a user's
workstation.

TVA costs $299 and is available at www.fmsinc.com.

HTH,

Brian Stenglein
Clow Stamping Co.

--- In vantage@yahoogroups.com, "kbheec" <kbh@e...> wrote:
> My production scheduler would like to run exports out of Vantage
> using
> ODBC to access. He would like to run them automatically every hour.
> Does anyone do this and if so what tool do you use to automate the
> process?
>
> Thanks,
> Kathy Hambleton
> Electron Energy Corporation
> 717-898-2294
> Fax: 717-898-0660
You can set this up by creating a macro in access to do whatever it is you
need done and creating a batch file to execute that macro. Then use windows
scheduler to execute the batch file.
We use MS SQL Server.
Some tables we dump via odbc others we use 4GL code. We use DTS within SQL
Server to handle the data imports.

Jeremy


[Non-text portions of this message have been removed]
The problem you will have using Access is Record Locking. If the user has a
form/query open during the update process, it will fail.


[Non-text portions of this message have been removed]