Can multiple users input information into one table possibly simultaneously ?

[Cedric]

Hello all,

I have a question concerning ACCESS. Here is my situation.

I would like to have differents persons inputing information, via
imput forms probably, into one unique table.

My question is : is this possible with ACCESS at least in the last
version ?

Can you have differents persons possibly at the same time inputing
information and have all that information saved into one table ? Are
there no issues in terms of exhaustivity, no information collision
problems in terms of file locking ?

If it's feasible, how hard is it ? Is it simple to set up or is it
going to be hard and kludgy ?

FIY, this would concern only three to four users.

Thanks in advance for your answers,

[Rick Brandt]

Cedric wrote:

Hello all,

I have a question concerning ACCESS. Here is my situation.

I would like to have differents persons inputing information, via
imput forms probably, into one unique table.

My question is : is this possible with ACCESS at least in the last
version ?

Can you have differents persons possibly at the same time inputing
information and have all that information saved into one table ? Are
there no issues in terms of exhaustivity, no information collision
problems in terms of file locking ?

If it's feasible, how hard is it ? Is it simple to set up or is it
going to be hard and kludgy ?

FIY, this would concern only three to four users.

Thanks in advance for your answers,

It's been possible in every version of Access and it's very easy to do.

If you just put the file in a shared location and have both users open it over
the LAN you could have some problems. The recommended approach is to give each
user a *local* file that has a link to the common data file on the LAN. With
that approach two users should be a snap. Particularly if they are doing
insertions. Record locking collisions are more common when editing existing
records than when adding new ones.

You do definitely want them using a form though.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com