Whats Better? Query or Table

  • Thread starter Thread starter Tim
  • Start date Start date
T

Tim

Hi,

I'm setting up an Data Base and am starting from the ground
up. I have created a all the tables and was starting to
put together a form so people can enter the data.

What I want to know is; is it better to have the form
directly write to the tables or am I better to use a query.

the Data base will eventually be on a server share with
about 10 users accessing it... and I'll probably split
the data base and have a front/backend as I see its a
better option.

Also if you could recommend some good Access books or sites.

Thanks
 
You can't create a query unless you have a table or multiple tables. Use a table unless you need to combine the data between two or more tables, then you should use a query.
 
I have 1 Main Table that has 5 look-up tables, 7 sub tables
and each of those sub tables has 1-3 look-up tables.

The main table and sub tables are tied together with a
OrderNumber relationship

I think I'm putting it together right...


-----Original Message-----
You can't create a query unless you have a table or
Click to expand...
multiple tables. Use a table unless you need to combine
the data between two or more tables, then you should use a
query.
 
If the query returns all fields and all records, then it really won't make
much difference at this point whether you bind the form to the table or to
the query. It will, however, make life easier if you decide in the future to
limit the records returned. It will also help if you decide in the future to
implement user-and-group-level security, when you will want to access data
via RWOP (Run With Owner Permission) queries.

In short, I would recommend always binding forms and reports to queries
rather than directly to tables. Even if there is no *immediate* benefit, you
may be very glad you did so in the future.

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.
 
Back
Top