P
Pitt
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...
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...