How do you guys handle autoupdating MS local databases?

•

What is DaniWeb IT Discussion Community?

You're currently browsing the MS Access and FileMaker Pro section within the Web Development category of DaniWeb, a massive community of 374,158 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,445 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our MS Access and FileMaker Pro advertiser:

Thread Tools Display Modes

Views: 641 | Replies: 4

Previous Post in Thread

Next Post in Thread

•

Join Date: Nov 2006

Posts: 3

Reputation: cyborgmaniac is an unknown quantity at this point

Rep Power: 0

Solved Threads: 0

cyborgmaniac cyborgmaniac is offline

Offline

Newbie Poster

How do you guys handle autoupdating MS local databases?

Apr 15th, 2008

I work here at UPS in the HR department and they use a Microsoft Access mdb database that connects to oracle servers to retrieve tables. It then creates a local copy of the tables and the queries run off that. The tables are updated every morning at 6am by a person manually.

I'd like to know that for the people who have similar databases, do you guys have scripts written to autoupdate them through odbc? Also, a catch is that it resides in a zip file on the network because multiple users access it.

I was thinking a visual basic program that resembles a keystroke macro to open the file and run the update macro, then put it back in the zip file. Any ideas? If it has to be out of the zip file, I may be able to change the rules around here a bit but I am researching on alternatives.