Recordsets bound to forms

[tanny81]

Hi, I have an access db which i am trying to update which uses a split front/backend. communication with the backend is via SQL and several instances the recordset that is obtained from the backend is bound to a form in the front end. When this happens it forces the connection with the backend to remain open (backend remains locked after i close the connection, and stays locked until i close the form). This gives me a few questions;

1) What is the benefit of binding a recordset in this way
2) how is the forms recordset property accessed
3) is there a way to close the backend connection without closing the form

thanks in advance

 

[bobsan42]

1. binding a form to the data makes it easier to display data and apply changes you make to records - no code needed
Drawback is - edited records (or ALL) are locked until form is opened (depending on form settings). If they are not locked - who knows what can happen .
2. Form Design mode - F4 displays the properties - select Form from the dropdown list ->Data tab
3. I don't think so if it is bound to the data. But in Data settings there is No Locks option and some other useful ones.
You could make it unbound, but then will have to write some code to populate the controls, etc. and then save any changes made to the data.

 

[xenou]

backend remains locked after i close the connection, and stays locked until i close the form

Something's wrong - this behavior doesn't make sense.

 

[bobsan42]

Something's wrong - this behavior doesn't make sense.

Maybe there are variables which keep the recordset opened and possibly locked. Or the form setting "Record locks" is set to "All records"?

 

[xenou]

I guess the first question is what does "the backend is locked" mean ... ? Is it the entire database? A table? A single record? If the whole database is locked it might be as simple as the database is being opened exclusively, which has nothing to do with forms or recordsets. The next question is everything about this form ... ! How in the world can a closed connection be locking anything?