|
tech
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
multiple users updating the same table and sharingQuestions:
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. 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. On Fri, 26 Jun 2009 07:52:02 -0700, sam <s**@discussions.microsoft.com> wrote:
>Questions: Yes.> >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 The form will refresh at an interval that you can choose, or you can put a>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 ? 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]
Other interesting topics
Access Database Setup
Copy Field Data Macro - one at a time, please! can it be done in access? Add a Footer to a Table add primairy key into txt field loading Access when I already have a 2007 student Office pkg loade Guide Me how to convert database written in Turkish MS Access to English MS Access select top |
|||||||||||||||||||||||