Edit code from another database

[botuco via AccessMonster.com]

Hi everyone

I created a database that I distributed to 5 friends about 6 months ago.
They have started using it to enter data at each of their job sites (4
different states). They have come up with a few changes and upgrades they
would like to see in the database.

Problem is, they have little knowledge of how to edit it themselves, plus, we
would all like to have the same database, even if in different locations.

What I would like to do is send them a database just with the new forms and
edited code that will automatically copy and paste new forms and code into
the older version of the database. That way, the data they have entered will
not be affected. We all use the database in a single machine, so it is not
split into front/back ends.

Thanks for your thoughts

Manny

 

[Marshall Barton]

I created a database that I distributed to 5 friends about 6 months ago.
They have started using it to enter data at each of their job sites (4
different states). They have come up with a few changes and upgrades they
would like to see in the database.

Problem is, they have little knowledge of how to edit it themselves, plus, we
would all like to have the same database, even if in different locations.

What I would like to do is send them a database just with the new forms and
edited code that will automatically copy and paste new forms and code into
the older version of the database. That way, the data they have entered will
not be affected. We all use the database in a single machine, so it is not
split into front/back ends.

You really should have split your database so you could
distribute the code/forms/reports/queries without affecting
the data, but better late than never.
http://www.granite.ab.ca/access/splitapp/overview.htm