data entry: Table

[alex]

Hello experts,

using Access ’03…

I understand that Forms are the best way to enter data, but…

I have a Table that a few people (3 or so) utilize on a network
server. They add and append data without any issue. The Table is not
normalized and is used with an ODBC connection to ORACLE.

My question: When I add more users to this Table, will they step on
each other? I.e., can multiple users update a Table (sans Form)
without issue…can one user save his/her data while someone else is in
the Table?

Thanks,

alex

 

[Golfinray]

With 2 or 3 users it is not too complex. When you start to add users you will
begin to experience problems. It would probably be better to put a copy of
the Queries and forms on each users computer and link each to the tables on
the Oracle machine.

 

[Arvin Meyer [MVP]]

My question: When I add more users to this Table, will they step on
each other? I.e., can multiple users update a Table (sans Form)
without issue…can one user save his/her data while someone else is in
the Table?

They will eventually step on each other if you don't correctly set locks to
prevent it, or have certain records that each individual "owns". The second
method uses a query and a form to enter and edit records.

You ALWAYS should use a form to enter records unless there is never more
than 1 user who is the database's developer. Forms allow you to run code to
validate and display records properly. Forms can use a controlsource of a
query the same as a table.

 

[alex]

My question:  When I add more users to this Table, will they step on
each other?  I.e., can multiple users update a Table (sans Form)
without issue…can one user save his/her data while someone else is in
the Table?

They will eventually step on each other if you don't correctly set locks to
prevent it, or have certain records that each individual "owns". The second
method uses a query and a form to enter and edit records.

You ALWAYS should use a form to enter records unless there is never more
than 1 user who is the database's developer. Forms allow you to run code to
validate and display records properly. Forms can use a controlsource of a
query the same as a table.

That's what I wanted to know; thanks guys!
alex