organize a project

[David]

I have a project where 60 users in many different
locations will log their tasks or work. The project is
very form driven. The mdb file is on my server. How can
I minimze lag time and have multiple users in the project
simultaneously? Approx 60 tasks per day will be
entered. I briefly looked at setting up a data access
page, but it's only options were TABLES and QUERIES. Is
this my only option?

 

[Scott McDaniel]

Are your users local (i.e. on the same LAN) or remote? You can always use
Terminal Server for remote users, and use a traditional networked connection
for the local people. However, there are MANY issues regarding multiuser
Access databases and performance. Check out Tony Toews site at
http://www.granite.ab.ca/index.htm for great info regarding many of these
issues, and take some time to review the messages posted in this newsgroup
and other associated newgroups.

 

[PC Datasheet]

If the many different locations do not need to be interactive with the mdb file
on your server, each location could create a textfile of their tasks or wirk and
email or FTP the file to you. You could then import the file and append the
information to an appropriate table(s) in the mdb file on your server. This
could be designed to be highly automated.