Results 1 to 8 of 8
  1. #1
    3 Star Lounger
    Join Date
    Jul 2001
    Posts
    283
    Thanks
    0
    Thanked 0 Times in 0 Posts

    bound vs. unbound forms (Access2000)

    I am wondering if there is any strong point against using a bound form in Access. When using a bound form, you can easily move around the records and you don't need much coding.

    Thanks

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: bound vs. unbound forms (Access2000)

    Bound forms are one of the nicest features of Access. However, in A2k, you can't bind a form to an ADO recordset and have it be updateable, so if you're using ADO you'll have to use unbound forms.

    On the other hand, bound forms limit you to the shape of the underlying recordset. If you want to enter a new record into a table for each control on a form, you'll need an unbound form and lots of code to do it.
    Charlotte

  3. #3
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: bound vs. unbound forms (Access2000)

    I personally prefer to use bound forms, as it just makes things easier. Unbound forms do give you more control, however, over saving/canceling records. And sometimes the complications of the data entry situation just can't be handled by a bound form.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  4. #4
    3 Star Lounger
    Join Date
    Jul 2001
    Posts
    283
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: bound vs. unbound forms (Access2000)

    I am wondering if the bound form has any disadvantage as compared to unbound form when dealing with multi-users.

  5. #5
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: bound vs. unbound forms (Access2000)

    The crunch comes when you save the record. In a multiuser environment where the users are hitting the same table at the same time, you're going to have problems either way. I've found that the optimal design is to build my tables as normalized as possible and to use subforms for the data in each table (i.e., and address subform, a phone number subform, etc.). Then I go around and apply strong eletrical shocks to anyone who walks away from their machine with a form left open with a record up, (OK, I lie. I just yell at them until they wish for the eletrical shock. <img src=/S/evilgrin.gif border=0 alt=evilgrin width=15 height=15>) since they can lock other users out of that page. If you're using recordlocking in A2k, it isn't quite so bad, but you have to make sure that's what you use rather than page locking.
    Charlotte

  6. #6
    3 Star Lounger
    Join Date
    Jul 2001
    Posts
    283
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: bound vs. unbound forms (Access2000)

    That is what I am looking for (the answer). However, let's say we use an ADO recordset to get the record, paste all the fields onto the unbound control on the unbound form. Close the recordset. Will that still lock up others? Should I want to save my changes, I then open the recordset again, copy all the controls' content back to the fields. If that is the case, do I still need the eletrical shocks? I understand that if I use adLockOptimistic, the record is locked up only when rst.update is issued and that will be only a split of a second, hopefully.

    Cheers.

  7. #7
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: bound vs. unbound forms (Access2000)

    You don't have to close the recordset. You can update the recordset from code, but you can't update it through bound controls. I believe that has been fixed in AXP, but in A2K that's the situation.
    Charlotte

  8. #8
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: bound vs. unbound forms (Access2000)

    >>I am wondering if the bound form has any disadvantage as compared to unbound form when dealing with multi-users.<<

    I don't think so.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •