microsoft.public.access.gettingstarted

On Oct 23, 3:11 am, SAURABH wrote:
> I m very sorry i couldnot understand as m very new to access.....Please help
> me how to do it..........
>
> "mcnews" wrote:
> > On Oct 22, 11:09 am, SAURABH
> > wrote:
> > > My main motive of sharing is to allow multiple users to open their own copy of
> > > the application and they update the data by filling the form and it gets
> > > updated in the Table in the central location.
>
> > > "Dennis" wrote:
> > > > What do you mean by "share?" As in, provide a copy to users who DO NOT have
> > > > MS Access on their PC's? Or to allow multiple users to open their own copy of
> > > > the application (and they DO have MS Access on their PC's), or to just allow
> > > > all users to run a single copy of the application in a central location?
>
> > > > "SAURABH" wrote:
>
> > > > > HI Experts,
>
> > > > > I am very new to MS Access 2007. actually i have developed a Database which
> > > > > has details of tasks that are being handled in our project.So each task is
> > > > > assigned to some users.
>
> > > > > I want that the DB which i have developed should enable everyone to to
> > > > > access the FORM and in that they should be able to see there Tasks and update
> > > > > the status on that.
>
> > > > > I also want that they should not be able to access other queries and
> > > > > tables,etc.
>
> > > > > I have no knowledge of VB code so i have used SQL programming for queries.
>
> > > > > Please help how can i share my DB with all users. Also kindly let me know
> > > > > how can i use the Windows Sharepoint Services.As we are also using Sharepoint.
>
> > > > > please help.
>
> > place an MDB that contains only the data tables on a PC that you will
> > use as a file server. link each copy of your MDB that contains the
> > form and queries to the servre PC that contains the data.
> > remember to relink any time you make a data structure change.

your clients are on a network?
can you set up or have access to a share drive on a designated file
server or some othe compouter on the network that all of the users can
see?

if so, use the linked table manager.
first time you must use File | Get External Data | Linked Tables.
point to the network shre drive and find your MDB that contains the
tables.

a google search will turn up more specific instructions if you need
them.

hopefully you won't ever have 70 concurrent users else your Access app
will bog down.