Windows Forum

Ask something
Discussion Locked

Access97 update file, stops w/o warning

0 helpful
3 replies

by dennis

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have inherited this problem without any help. I have an Access97 database that is updated daily. It resides on a common Novell netware drive and my ex-boss was trying to schedule it from an NT4 server. He used Scheduler, AT commands, Services and a couple of downloaded programs but it will stop several times a month and I do not know it until someones complains. The engineer that wrote the App has a little file that when run kicks up the Access97 DB and requeries the SQL database to download the next days data.
All suggestions will be appreciated and tried.
Thanks - Dennis

3 replies

by thetechguy

Dear Dennis:

Since you have a SQL server, I hope you have version 7 or later. Because the SQLAgent combined with DTS (Data Transformation Services) packages would prove to be most suitable. You can schedule the task has SQL export the result ofwhatever query directly into access files and and upon completion has SQL server notify you. Instead of expecting the ACCESS97 to do all the work. If you're working with 6.5 then that might be a little more work since BulkCopy doesn't not know access file format. You can still have the SQL notify you except that the transformation (export) will have to be done by some fancy scripting. I think Scheduler doen't work on NT. And also it might be best for the engineer to built into the application so that the first time it's run for the day, it will update all relevant data, instead of depending on a scheduler. :-)

Hope this helps,

This discussion is closed to new replies.