Unbound Form Question

[Guest]

I have just migrated my access database to a SQL server and this is my first
time dealing with a SQL server. I decided to make my form unbound because I
didnt feel that is was necessary to pull the entire recordset into this form.
However, the users still need to be able to retrieve and edit a record and
also be able to add records just as they have always done with a bound form
and I'm not sure how to accomplish this. How might the server react if I did
make the form a bound form to this large and always growing table with a
large number of users? Any thoughts and suggestions on this would be
appreciated. Thanks.

 

[Guest]

To use an unbound form, you will have to establish a recordset and populate
your form and do table updates using VBA. You would be better off to use a
bound form.