Multiple Users Accessing one database

[Gary]

I have been working on developing a tracking log that will be division wide.
Multiple users need to be able to enter information into this database at the
same time. Every search I have run comes up "can’t be done" well I also have
another one that was developed by someone else, which does have this
capability, so I know it can be done. I am fairly new to Access and I know
it won’t be an easy task. I just need some kind of direction as to where I
need to start.

 

[John W. Vinson]

I have been working on developing a tracking log that will be division wide.
Multiple users need to be able to enter information into this database at the
same time. Every search I have run comes up "can’t be done"

I certainly don't know where you're seeing this but it's just NOT TRUE. Access
is multiuser out of the box and it's perfectly easy and routine.

well I also have
another one that was developed by someone else, which does have this
capability, so I know it can be done. I am fairly new to Access and I know
it won’t be an easy task. I just need some kind of direction as to where I
need to start.

You will want to "split" the database into a shared backend and a "frontend"
containing the Forms, Queries, Reports etc., linked to the backend. Each user
gets their own copy of the frontend. For details see
http://www.granite.ab.ca/access/splitapp.htm

For some more guidance on setting up a database in the first place see:

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

A free tutorial written by Crystal (MS Access MVP):
http://allenbrowne.com/casu-22.html

MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials

 

[Albert D. Kallal]

I am fairly new to Access and I know
it won't be an easy task. I just need some kind of direction as to where
I
need to start.

Actually, it is very easy to accomplish. In fact, you don't have to modify
any of your code at all....

I explain how you do this here:

http://www.members.shaw.ca/AlbertKallal/Articles/split/index.htm