Create Data Copy App/Service

[wildsharkuk]

Hi,

I'm fairly new to programming and would like to create an app/service using vb that will reside on a server and at scheduled times run a module that will copy certain tables from a networked oracle database to a local access database that will sit on a local users machine (these machines are regularly disconnected from the network during the week to allow users to work from home etc).

I'm quite happy at creating the routines to copy certain tables across, but uncertain of how to proceed to creating a scheduled service to sit on a server.

any help would be appreciated.

thanks

wildsharkuk

 

[JerryKlmns]

You could built a sub in a module of access and use HandyAccessLauncher found at

http://www22.brinkster.com/accessory/resources/001.shtml

to do the scheduled update

(I currently have problems with that site though! mp9)

 

[comaboy]

Depending on your version of Windows, you could write the app to run and unload itself, and then use the Task Scheduler to fire it at specific intervals.

 

[wildsharkuk]

thanks guys,

i'll investigate both these methods and let you know.

thanks again.

wildsharkuk