Updates to Access applications

[BajanPOET]

Currently if I make a change to a form in my Access application I ask the user to replace the entire *.mdb file. Is there a way that I could create an update procedure that makes the small changes within one form in the *.mdb file without me having to ask the user to download the entire *.mdb file all over again?

I'm thinking of somethng that the user can run and it just changes the Add form without any other user input (coz all users have the same configuration in terms of where the *.mdb file is located on their systems)

What? Who? ME????

 

[Remou]

I sometimes use a small update mdb, which opens the main database and makes the relevant changes: rename form, copy new form and so on. It would also be possible to use script.

 

[BajanPOET]

I like the script idea... where could I learn about it?

What? Who? ME????

 

[Remou]

There is quite a bit to it. Here is one site:

http://www.devguru.com/Technologies/vbscript/QuickRef/vbscript_intro.html

You will also find a VBScript forum in Tek-Tips.

 

[BajanPOET]

Thanks... I'll check them out.

What? Who? ME????