Distributing an update to a forms code

[David Brown]

I have a standalone Microsoft Access 2000 database that I have distributed
to 15 users in different locations. I have just come across a bug in the
code of one of my forms. What is the best (easiest) way to update their
database with the new form? These users are not skilled in Access.

Thanks for the help,
David Brown

 

[Wayne Morgan]

If the database is split into a front-end/back-end, then you can just
replace the front-end file with the new one. You may have to relink the
tables if you can't simulate the location prior to sending them the file.
You will find some code to do this here:

http://www.mvps.org/access/tables/tbl0009.htm
http://www.mvps.org/access/tables/tbl0010.htm
http://www.mvps.org/access/tables/tbl0012.htm

The different articles vary depending on what the back-end is. For this to
work, all they will need to do is close Access on their computer and copy
the new front-end file over the old one.

Tony Towes has an automated front-end updater that you can find here:

http://www.granite.ab.ca/access/ufad.htm

 

[Albert D.Kallal]

Several people mentioned to split your database.

If you did NOT do this..then you can still do this...

Simply send your users a new update without the tables..but use LINKED
tables. The existing mdb (actually, it should been a mde) can continue to be
used as the back end now.

You can read about why you split here, but in simple terms, you really need
a strategy for updating your users..as I can't imagine your application will
be perfect from day one....

http://www.members.shaw.ca/AlbertKallal/Articles/split/index.htm

So, just send them a new front end.and have that front end link to the
existing back end.....