Locked records ?

[Guest]

Hello !

I'm going to start using the small access-system in a network.
Is there anything I should think about regarding locking of records ?

If I start use it with default values, can 2 users work with the same table
without problem ?

Tanks in advance !

 

[Guest]

Yes, you can have multiple users in a database. I would suggest splitting
your database into a FE(front end)/BE(Backend) using the database split
utility built in. Also, You ask if they can be in the same table. Are you
actually allowing the use of the table for record maintainance or do you have
a form linked to the table. IT is better to have the table linked to a form.

 

[Guest]

Why split ?
It's a small database......

Users will only access table through forms ! (except some admin)

 

[Guest]

The reason for splitting allows the continuous developement of the database.
Basically, if you need to make a change to the database while it is not
split, you need to get everyone out make your changes then allow them back
in. If you split it, you can send a copy of the front end to each user and
keep a copy to use for developement. Also, this takes the tables and puyts
them into a back end, where your user can't make changes to their design
becase there is only a linked copy in the front end. It more or less boiuls
down to security.

 

[Guest]

Ok I understand !

Thank you very match for your help !

 

[Joseph Meehan]

Hello !

I'm going to start using the small access-system in a network.
Is there anything I should think about regarding locking of records ?

If I start use it with default values, can 2 users work with the same
table without problem ?

Tanks in advance !

Access will take care of locking records for you. While there asettings,
I suggest you leave the defaults as they are unless you have a problem.

Access is by nature a shared system, but it works best when split with a
front end and back end. The tables with all the changeable data stays on a
server (the back end) and forms queries etc are with the front ends on each
user's machine. With only two users you should not have problems.

The likelihood of locking issues is more a matter of the kind and
quality of editing.

Good Luck