Updating a database

[Othello911]

Greetings All,
I have a database that I have given to a customer that I would like to make some changes to. The problem is that the user is not computer savvy and I have turned off the database window, so he can not "accidently" destory something, but I need to make updates to the database. I can't do this in person cause the user is so far away. I do not trust telling them over the phone, how to import the new changes and change the name of a form to something else and all that. Is there some way that I can make updates to Access, perferrably in a manner that is user friendly, that the user can just like click an "Update button?"

 

[richary]

If it's a one-off thing could you use Remote Desktop Assistant, or VNC ?

 

[Othello911]

Sorry, but I don't know what either of those things are. Could you go into some detail?

Thanks!

 

[ssteinke]

Is the database split? If not, consider splitting the database so you can make regular changes to the front-end and redistribute to your user. This makes the process of correcting small problems much easier.

 

[ghudson]

Here is an alternative way for a user to update the db objects...

Export All Database Objects Into Text Files

You can email the users the files. The user would then import the files to update their db objects. Of course you would have to build the routine to import the objects for the user so that you control how and what they do to update [import] the files to update the db objects.

But, a split db is a must no matter how you update the db.

 

[richary]

I'm afraid I'm a bit pushed for time today, so can't go into as much detail as I would like. Basically they allow you to 'take over' another user's machine from a remote PC and operate it as if you were sitting right at their desk.

It can be done over the Internet.

I've used VNC from WiFi hotspots etc and works very well. The only problem being that if the 'destination' machine is on a network/router setup, you will probably have to fiddle with teh router settings, which I guess you wouldn'twant to do. If both machines are connect directly conncted via dial-up or fixed (eg DSL) line, then there should be no problem.

I haven;'t have direct experience of remote desktop assistance, but it comes with XP, so it would be relativly easy to find out about it and, I assume, relativly easy to use.

Having said all of that, I would look first at ghudsons method, which looks as if it would be the best solution for you.