access to Access

[Mike Kelliher]

We use MS access 2000 at work and few people know how to work it including
me.
We are using it on a network and more than one person is trying to access it
at once. Needless to say this isn't working as one has to log out first
before another can enter data. Is there an easy way around this? Or a
complicated way, actually I'll take anyway.
Thanks Mike
We have just started this database so any changes would be better done
sooner.

[Br]

Mike Kelliher wrote:

We use MS access 2000 at work and few people know how to work it
including me.
We are using it on a network and more than one person is trying to
access it at once. Needless to say this isn't working as one has to
log out first before another can enter data. Is there an easy way
around this? Or a complicated way, actually I'll take anyway.
Thanks Mike
We have just started this database so any changes would be better done
sooner.

It's highly recommended to have the database split with the data on the
shared network drive and a copy of the frontend (forms/reports/etc) on each
PC.

You'll still get issues if people try to edit the same record for example.

Also, you must make sure each user has permission to create new files on the
network dive/folder where the MDB is located as Access dynamically creates
an LDB file for record locking. If they can't create this file then Access
reverts to single-user only.
--
regards,

Br@dley

[Bob Alston]

Br@dley wrote:

Mike Kelliher wrote:

We use MS access 2000 at work and few people know how to work it
including me.
We are using it on a network and more than one person is trying to
access it at once. Needless to say this isn't working as one has to
log out first before another can enter data. Is there an easy way
around this? Or a complicated way, actually I'll take anyway.
Thanks Mike
We have just started this database so any changes would be better done
sooner.

It's highly recommended to have the database split with the data on the
shared network drive and a copy of the frontend (forms/reports/etc) on each
PC.

You'll still get issues if people try to edit the same record for example.

Also, you must make sure each user has permission to create new files on the
network dive/folder where the MDB is located as Access dynamically creates
an LDB file for record locking. If they can't create this file then Access
reverts to single-user only.

Just to be clear multiple people SHOULD be able to access a single
Access database simultaneously. If on your network more than one person
can access the database but only one at a time, then the problem is
likely that people are opening the database in EXCLUSIVE rather than
shared mode.

Bob