Unbound Form Question

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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.
 
Back
Top