B
Bob
Is it damaging to enter data direct into Tables as apposed to getting though
Form?
Thanks in advance.........Bob Vance
Form?
Thanks in advance.........Bob Vance
R
Rick B
It's not "damaging" but it is not recommended. The tables are simply
buckets to hold the records. You can't fully control the format of entries
or do any error checking. You can't run code, you can't control cursor
movement, you can't make the interface look nice. You can't secure what the
users can do very well, etc.
In a perfect world, your users would not have any access to the tables at
all. You would create forms based on queries set to run with owner
permission and you'd have full control over what the users could do in the
forms.
Why do you ask? Why would you NOT want to use a form?
buckets to hold the records. You can't fully control the format of entries
or do any error checking. You can't run code, you can't control cursor
movement, you can't make the interface look nice. You can't secure what the
users can do very well, etc.
In a perfect world, your users would not have any access to the tables at
all. You would create forms based on queries set to run with owner
permission and you'd have full control over what the users could do in the
forms.
Why do you ask? Why would you NOT want to use a form?
G
Guest
That's an easy one. Because to use a form, you have to CREATE one. If youRick B said:
already have a table, you don't need to do any more work. Creating a form
requires a different skill set than creating a table.
Yes, forms have some advantages, but those advantages are not free - they
require extra work. The main advantage is event control. If you don't need
events, then there are few advantages to forms.
Yes you can, if you know how to properly establish field and table
constraints. If you rely on form-level data security, good luck to you! You
should not secure data integrity at the form level, but at the table level,
to protect data from being damaged by users/admins who *do* have table
access. SOMEBODY has to have table access, and those tables are not to be
left to the mercy of what those users remember!
R
Rick B
Yikes. I'm glad you're not building the database files used by my company.
B
Bob
well if I have a 100 entries and want to change the pricing instead of
having to flick through the forms I can just scroll down and change the
price , plus they are in alpha order
Thanks Bob
having to flick through the forms I can just scroll down and change the
price , plus they are in alpha order
Thanks Bob
D
Douglas J Steele
Creating a form that would allow you scroll through the 100 entries should
take no more than 2 or 3 minutes.
Since Tables don't have a reliable order (data will be inserted wherever it
fits), using a form that's based on a query that has the appropriate ORDER
BY clause in it is better.
I agree whole-heartedly with Rick (and, obviously, disagree with TedMi)
take no more than 2 or 3 minutes.
Since Tables don't have a reliable order (data will be inserted wherever it
fits), using a form that's based on a query that has the appropriate ORDER
BY clause in it is better.
I agree whole-heartedly with Rick (and, obviously, disagree with TedMi)