Question Importing reports or form query

Toolpusher

Registered User.
Local time
Today, 06:56
Joined
May 29, 2007
Messages
53
I have databases at different locations not on a network. The basic design is all the same. Quite often one location will want a form or report very slightly tweaked for their location. All users at the locations only input data so the DB is quite well locked down. At the moment any changes are done by myself the location zips their DB sends me it and I send it back with the changes done. Sometimes its something as simple as adding word wrap to a field in a report. Is their anyway I could send them a updated form or report on its own and set up a pass worded import button on their switchboard to simply import the new form or report to their DB without the hassle of Zipping the complete DB back and fore
 
Have a look at the DoCmd.TransferDatabase method. This should do what you need with some supporting logic. You may also need the DoCmd.Rename and/or DoCmd.DeleteObject methods in the target DBs to rename or remove the existing object before importing the new version.
 
Thanks for info, surely this method would only work if the user's PC had a path back to mine which it does not?
 
The 'suporting logic' I referred to is the mechanism to gather the pieces together in whatever way you need. You might use an intermediate DB at each location which could be used for exchanging changed forms and reports, so the DoCmd.TransferDatabase would import locally and the results shipped to the relevant location.
Is it the exchange of complete DBs you want to prevent, the administrative process of the exchange, or both? If the latter, then you should consider a file server as an intermediate repository, from which each user can exchange when needed, perhaps on a time basis (e.g. every Monday at 9am). It's difficult to theorise without more complete understanding of the context.
 

Users who are viewing this thread

Back
Top Bottom