Should forms be binded to the table/query?

techcrium

New member
Local time
Today, 11:58
Joined
Mar 19, 2012
Messages
6
I heard it's bad design to have forms directly binded to a query because you have no data control.

Is it better to make forms unbounded and then have users fill it out, and use VBA to programatically validate the data and insert into the database?
 
personally, i would use bound forms as much as possible, unless and until you get a situation that is user to accoumplish with an unbound form.

it's far easier to use bound forms.

i am not sure about the last bit of advice in paul's link. I don't necessarily think that a non-Jet/Ace database makes unbound forms more advisable. If that were so, then upsizing a dbs would always require a complete rewrite.
.
 
I don't necessarily think that a non-Jet/Ace database makes unbound forms more advisable. If that were so, then upsizing a dbs would always require a complete rewrite.

I use bound forms against SQL Server back ends most of the time. I think Jason's point was that a non-Jet back end adds weight to the case for unbound, not that it requires it. It's still a matter of considering the factors for and against in a specific situation.
 
You bind forms to queries that have criteria. If the query doesn't include criteria, you might as well bind the form to a table. The objective is to minimize the number of rows returned by the server at any one time. Since users simply are not going to scroll through thousands of records to find the one they want, you give them the ability to search for what they want. The old Jet technique was to bind the form to a simple query without criteria or directly to the table and then use filters to find the data. This method requires that the entire dataset be brought down to the PC so if you are working with large tables on the server, this puts a huge burden on the network. So the better technique for client/server environments is to have the table bound to a query and the query has selection criteria. So your form allows the user to enter the criteria, the user presses run and you requery the form to force the query to run again using the current criteria. It is far more efficient to bring down a few records at a time than to let a form bound to a table just suck down all the data from the server like a vampire. It is this one technique that gives Access the biggest black-eye with database administrators.
 

Users who are viewing this thread

Back
Top Bottom