Home All Groups Group Topic Archive Search About

multiple users updating the same table and sharing

Author
26 Jun 2009 2:52 PM
sam
Questions:

1) Can multiple people enter data in the same access data sheet through
access form at the same time?

2) How can I connect access installed on multiple computers so everyone can
have access to the same database? I have Access 2007
For eg; IF two people are entering data in an access table through a form,
how can both of them view each others work ?

Thanks in advance.

Author
26 Jun 2009 3:56 PM
Jeff Boyce
Already responded to in another newsgroup.  Rarely is it necessary to post
to more than one newsgroup.

Doing so makes you work harder, since you have to look in multiple places to
see if you got an answer.

And it makes the folks who respond in the newsgroups waste their efforts
responding to a question that was already answered.

Regards

Jeff Boyce
Microsoft Office/Access MVP

Show quoteHide quote
"sam" <s**@discussions.microsoft.com> wrote in message
news:5A3DA879-1410-40AD-85BF-23E0774DF53C@microsoft.com...
> Questions:
>
> 1) Can multiple people enter data in the same access data sheet through
> access form at the same time?
>
> 2) How can I connect access installed on multiple computers so everyone
> can
> have access to the same database? I have Access 2007
> For eg; IF two people are entering data in an access table through a form,
> how can both of them view each others work ?
>
> Thanks in advance.
Are all your drivers up to date? click for free checkup

Author
26 Jun 2009 5:55 PM
John W. Vinson
On Fri, 26 Jun 2009 07:52:02 -0700, sam <s**@discussions.microsoft.com> wrote:

>Questions:
>
>1) Can multiple people enter data in the same access data sheet through
>access form at the same time?

Yes.

>2) How can I connect access installed on multiple computers so everyone can
>have access to the same database? I have Access 2007
>For eg; IF two people are entering data in an access table through a form,
>how can both of them view each others work ?

The form will refresh at an interval that you can choose, or you can put a
command button on the form to refresh it, viewing all newly added data.

See http://www.granite.ab.ca/access/splitapp.htm for suggestions about how to
properly split the database into a shared "Backend" containing just the
tables, and a "Frontend" containing forms, reports, and code; each user should
have their own copy of the frontend, linked to the shared backend.

And DON'T use table datasheets for interacting with the data! They are very
limited in capability; Forms are much more appropriate and flexible.
--

             John W. Vinson [MVP]

Bookmark and Share