How to Synchronize

[Guest]

I built a database that is intended to be shared amongst multiple users. I
have the master and I was considering giving each user an unmodifiable copy
of the file in form of an MBE or a replica. I'm not sure which one works
best. - Please offer advice here.

The database by design will create a new table for each "Purchase Order." (I
had to design it this way.)

How do I keep records (specifically tables) synchronized so that all users
can access tables created by other users? I was considering splitting the
database, but that only splits the data currently in the database and I'm not
sure if it will propagate any additions made after the split.

OR

Can I keep the fixed tables that serves as the record source for my forms in
a back end database and have Access create the newly generated tables in
another database?

Please help with a solution...

 

[Joseph Meehan]

I built a database that is intended to be shared amongst multiple
users. I have the master and I was considering giving each user an
unmodifiable copy of the file in form of an MBE or a replica. I'm not
sure which one works best. - Please offer advice here.

The database by design will create a new table for each "Purchase
Order." (I had to design it this way.)

How do I keep records (specifically tables) synchronized so that all
users can access tables created by other users? I was considering
splitting the database, but that only splits the data currently in
the database and I'm not sure if it will propagate any additions made
after the split.

OR

Can I keep the fixed tables that serves as the record source for my
forms in a back end database and have Access create the newly
generated tables in another database?

Please help with a solution...

You are close to the idea.

When you split the database, and that is what you want to do, you make a
back end and front end(s). The back end has all the dynamic data (anything
that may change) and that is all. The Front end(s) have all the forms
queries reports etc. and link to the back end for the data. The front end
should also have copies of any static data like division numbers (assuming
you don't change the divisions or their numbers.

I would suggest allowing the individual users to be able to make changes
to their front ends so they can have their own custom reports, etc as they
see fit.