data entry: Table


A

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
 
Ad

Advertisements

G

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.
 
A

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.
 
Ad

Advertisements

A

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Manage ODBC 2
Refresh Table 3
Memo Data Type 5
Default Data in table view 4
Union – too many fields! 28
Cancel form entry 3
Translate Checkboxes to a Table 6
Creating Criteria For Data Entry 3

Top