Sharing access 2007 with around 70 Users

[Guest]

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.

 

[Guest]

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?

 

[Guest]

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.

 

[mcnews]

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.

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.

 

[Guest]

I m very sorry i couldnot understand as m very new to access.....Please help
me how to do it..........

 

[mcnews]

I m very sorry i couldnot understand as m very new to access.....Please help
me how to do it..........

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.

 

[Tony Toews [MVP]]

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

If it's efficiently written and the network is of good quality then 70
concurrent users won't be a problem.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/