ACCESS on and off line from Sharepoint

[Niebotel]

I migrated my application's tables to a sharepoint. The reason is that the data then is available for different users; I am quit satidfied how that works!
One user is changing a lot of data per day (he is the harbour master)and for performance reasons he has to take the data off line so he can work during the day with a good performance. In the evening the data should be synhronised again. Normal ACCESS gives this possibility but my application is runnign as accde and I want to automate this syncronization (Users will forget; I'm sure!) So I have to call thet action somehow from VBA. I could not find how to do so. Can somebody tell me? Help is appreciated very much!
Gr. Willem

 

[kjv1611]

Is it possible to just have a separate database for this purpose, and then Windows task scheduler to start that application?

Here's what I mean:[OL]
[LI]Windows Task Scheduler opens the Synch Database[/LI]
[LI]The Sync Database has a user form that opens upon opening/running the database.[/LI]
[LI]That user form nas "on open" code in it that runs the synchronization between the 2 data sources, of course with logging and error handling included.[/LI][/OL]

I used a method like this (not for synching data, really), but for a process on my job in the past. Before I had the responsibility, the poor soul who had the responsibility would work normal business hours, then come back in to the office EVERY evening around midnight to kick-off a daily process that basically ran ALL NIGHT LONG... of course he would only come in to kick it off.

So when I was given the responsibility, I basically said no way am I coming in to do something that should be automated. I set it up with Windows Task Scheduler and a small script for the other database - it was a PIC BASIC database, but we used HOST ACCESS for running it most of the time, thankfully, which allowed for recording macros, and allowed for kicking them off upon opening.

I've done a few smaller pieces with Access databases, which is why I know it'll work.

--

"If to err is human, then I must be some kind of human!" -Me

 

[Niebotel]

Hi, thanks for responding.
I was actually looking for the coding. I think it is the coding you included in the first form. Can you show it?

It shoul be something like Docmd.Synchronize ??? If the command exists?

 

[kjv1611]

As I mentioned, I was not syncing files, so I'd have no specific code readily available for that. However, if you're looking specifically for how to write the VBA code for something in Access, you'd be best served posting the question in the following forum:
forum705

Otherwise, you surely can find it already posted somewhere online here at tek-tips or else on many other sites. You could try this search for instance.

--

"If to err is human, then I must be some kind of human!" -Me