We have an Access database that needs to be edited by several users.
Currently, only one person can access at a time to input information. Can
several users access the database and input information simultaneously? I
have an Excel spreadsheet that will do this, but cannot find out how to do it
in Access.

CarlaInJax wrote:
> We have an Access database that needs to be edited by several users.
> Currently, only one person can access at a time to input information.
> Can several users access the database and input information
> simultaneously? I have an Excel spreadsheet that will do this, but
> cannot find out how to do it in Access.

Access by default allows shared use. You don't need to do anything.

However there are a few things to consider. First Access performs
multi-user tasks best when it is split, with all the data in one MDB on the
server and separate MDBs for each user on their own machine. Their MDBs
will have their own forms, queries reports etc.

Second if you have more than one person editing at the same time,
something needs to keep them from stepping on one another's toes. That is I
may make a change and you may be editing the same record at the same time
may not see that change and make another inappropriate change to the same
record. Access employs record locking as the traffic cop. Do some research
on record locking as it is a complex subject. Note, that in some versions
of Access not just the one record someone is editing is locked, but
sometimes more than one record may be locked.

--
Joseph Meehan

Dia duit

Check this link about "Splitting a Microsoft Access Database", essential to
make the database a accesable by more then one user

http://www.databasedev.co.uk/split_a_database.html

--
Good Luck
BS"D


"CarlaInJax" wrote:

> We have an Access database that needs to be edited by several users.
> Currently, only one person can access at a time to input information. Can
> several users access the database and input information simultaneously? I
> have an Excel spreadsheet that will do this, but cannot find out how to do it
> in Access.
>

a) throw away MDB
b) use Access Data Projects
c) keep your data in a format with a future.
MDB has been obsolete for 10 years now.




Ofer Cohen wrote:
> Check this link about "Splitting a Microsoft Access Database", essential to
> make the database a accesable by more then one user
>
> http://www.databasedev.co.uk/split_a_database.html
>
> --
> Good Luck
> BS"D
>
>
> "CarlaInJax" wrote:
>
> > We have an Access database that needs to be edited by several users.
> > Currently, only one person can access at a time to input information. Can
> > several users access the database and input information simultaneously? I
> > have an Excel spreadsheet that will do this, but cannot find out how to do it
> > in Access.
> >

(E-Mail Removed) wrote:
> a) throw away MDB
> b) use Access Data Projects
> c) keep your data in a format with a future.
> MDB has been obsolete for 10 years now.
>

Sure that will work if used properly, or you can keep the MDB and use it
properly and that works. Funny a lot of people are using MDBs


--
Joseph Meehan

Dia duit

more people use SQL Server than MDB.

any day of the week.

a lot of people also waste a lot of time doing crap like compact and
repair.

does it mean that it's the right choice?

SQL Server is 100 times easier to deal with than MDB.

Sprocs and VIews are just flat-out more powerful in SQL Server than in
your silly trivial MDB apps





Joseph Meehan wrote:
> (E-Mail Removed) wrote:
> > a) throw away MDB
> > b) use Access Data Projects
> > c) keep your data in a format with a future.
> > MDB has been obsolete for 10 years now.
> >
>
> Sure that will work if used properly, or you can keep the MDB and use it
> properly and that works. Funny a lot of people are using MDBs
>
>
> --
> Joseph Meehan
>
> Dia duit