Is it possible to have another workstation download this, and then at the end of the day UPDATE ONLY the changes made to that database?
I would think that this would depend upon your connections back to the central server. If you have persistent connections (T1, etc.) then I would just have them run everything off the central server. You could use the terminal services in win2k to provide a common gui to the users. OR it might be easier to go web based, especially if you want to give "anywhere access" with little overhead from your end; it may be harder to develop but you could also use open source (read: free) tools to accomplish this. I just finished customizing a generic web based timesheet app that I got from
www.devshed.com and you could probably do something similar using php, mysql and apache to build your db.
Hope this helps some
/JD