Propagate Object Changes

[Kevin]

Hi all,

I am working on a database that I expect will change a lot over the
coming year. Actually, there are 16 separate databases at our
different offices around the country. As I make changes to objects or
add new objects, I would like to be able to allow users to easily
update their version. I understand splitting the database would make
this easy, but I work for a non-profit and our network is painfully
slow - even after keeping a connection open to the backend, storing the
database in the root directory, etc.

My idea is to create a database shell with any objects that I want to
be updated. Then the user could open the Update database, click a
button, and all objects would be copied, overwriting the previous
version if there had been one. Whatever the solution, it would need to
be very easy, as the users aren't very tech savvy.

I tried the CopyObject action in a macro, but it doesn't allow for the
user to select the database into which the objects are copied. Please
let me know if you have any ideas.

Best,
Kevin Jenkins
City Year Program Manager

 

[Guest]

Kevin

Try looking at :-

http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='BE Update Utility.mdb'

it may be what you want.

 

[Guest]

Sorry

Try BE Update Utility at :-

http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hibbs,Peter S