G
Guest
We have a small office with several employees who need to enter data into the
same Access DB simultaneously. Is this possible?
same Access DB simultaneously. Is this possible?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Guest
yes. access is designed to be multi-user.
However, in order to get the best use out of it, you should have the users
access the data via forms and reports rather than directly in the tables.
Also, in order to reduce corruption risks, once you're ready to deploy the
database, split the database into a front-end / back-end system (basically
only the data and relationships sit in the back end - everything else is in
the front).
In access 2000 you can do this through tools/database utilities/database
splitter
However, in order to get the best use out of it, you should have the users
access the data via forms and reports rather than directly in the tables.
Also, in order to reduce corruption risks, once you're ready to deploy the
database, split the database into a front-end / back-end system (basically
only the data and relationships sit in the back end - everything else is in
the front).
In access 2000 you can do this through tools/database utilities/database
splitter