Collaboration

[Guest]

I am trying to set up a collaborative database using SharePoint similar to
how you do it with a Word Document. When I do it with a Word doc though
there is a place in the doc where you can check in the document and save
changes but I don't see how you can do this with an Access Database. When I
check it out nothing happens. Then I go to check it in and it asks me if I
want to save changes but I have no changes to save because the only way to
edit the database is to save it to your computer and it doesn't see those
changes. You'd just have to upload it again to get those changes. So does
anyone know if I can do a collabortive workspace with and Access Database
like you can do with Word or Excel docs.

 

[Joseph Meehan]

I am trying to set up a collaborative database using SharePoint
similar to how you do it with a Word Document. When I do it with a
Word doc though there is a place in the doc where you can check in
the document and save changes but I don't see how you can do this
with an Access Database. When I check it out nothing happens. Then
I go to check it in and it asks me if I want to save changes but I
have no changes to save because the only way to edit the database is
to save it to your computer and it doesn't see those changes. You'd
just have to upload it again to get those changes. So does anyone
know if I can do a collabortive workspace with and Access Database
like you can do with Word or Excel docs.

Not like Word, but you can share the same database and you can all share
and edit the data.

Normally this is done using a shared network drive. A "back end"
database file is saved there and it contains only the shared data that
changes. Then each user has a "front end" database that contains the static
data, forms reports etc. User level security allows you to control what
they can see and do with the shared data. It is also possible to keep a
record of changes and who made the changes.

Some shared databases can be rather complex of if your needs as simple,
they can be quite simple.