multi-user

[Guest]

I have created a very simple database that has a form linked to a table.
There are two people that use this database. how do i make it so that both
people can have the database open and still save their changes

 

[Joseph Meehan]

I have created a very simple database that has a form linked to a
table. There are two people that use this database. how do i make it
so that both people can have the database open and still save their
changes

If they are editing data that is on the same "page" Access will always
ask about saving since they both could have changed the same information and
saving it could overwrite the other's changes. What may be confusing you is
the idea of "page" A "page" may be one record or several records. As far
as I know there is no way of telling what record(s) Access insiders a
"page."

 

[Douglas J. Steele]

What kind of changes?

Changes to the data, you shouldn't have to do anything, although you should
split your application into two: a front-end, containing the queries, forms,
reports, macros and modules linked to a back-end, containing the tables.
Only the back-end should be on the server: each user should have his/her own
copy of the front-end, preferably on their hard drive.

If you've got them in a single database, the risk of corruption is
significantly higher.