Updating database forms, queries and reports but keeping tables and data

[Sierras]

This must have been asked many times but I did a search and can't find
any info on it.

Basically, I'd like to send my updated database with different reports
and forms and queries by e-mail to the users while keeping the same
tables and data as they are. Is there an easy way to do this? Maybe
a simple command button that the user could press that will update the
database and keep the data intact?

Thanks

 

[tina]

if a database has more than one user, it should be split into frontend (FE)
and backend (BE) databases. even if you're building a single-user database,
for someone other than yourself, it's easiest to split the database - so you
can easily update the reports, forms, and queries without having to touch
the data repository. try doing a newsgroup search on splitting a database;
you should come up with tons of relevant threads.

hth