H
hai
using Access 97 in multi-user environment. I have a split
Fe/Be database. Some of the data in the Be is common to
data in other Be's (different databases). Will I take a
hit on performance if I split out the common data into a
3rd Be and have the Fe link to multiple Be's? Outside of
not being able to enforce referential integrity, are there
any other issues I need to be concerned about (such as
corruption)? I expect about 50 simultaneous users for the
Be with the common data. If I don't merge the common data
into a seperate Be, there will be about 25 simultaneous
users.
Thanks!
-hai
Fe/Be database. Some of the data in the Be is common to
data in other Be's (different databases). Will I take a
hit on performance if I split out the common data into a
3rd Be and have the Fe link to multiple Be's? Outside of
not being able to enforce referential integrity, are there
any other issues I need to be concerned about (such as
corruption)? I expect about 50 simultaneous users for the
Be with the common data. If I don't merge the common data
into a seperate Be, there will be about 25 simultaneous
users.
Thanks!
-hai