jonathanchye
Registered User.
- Local time
- Today, 00:00
- Joined
- Mar 8, 2011
- Messages
- 448
I have a front end that is opened virtually 24/7. One of the forms in the front end links into a table of another backend (let's call this Backend B). I've made sure the underlining queries is "Snapshot" and also made sure the form does not allow data entry or any editing. I've also made sure the database does not have any record locking enabled and the client opens in "shared" mode.
I am having problems with Backend B always being "locked" - there is a .laccdb file present and I cannot delete it.
I presume this is because I have the form that links into Backend B is opened 24/7. I would've thought setting the recordset type as "snapshot" would prevent this? Is there anyway I can redesign this form so it doesn't locked up Backend B 24/7 too?
Thank you!
I am having problems with Backend B always being "locked" - there is a .laccdb file present and I cannot delete it.
I presume this is because I have the form that links into Backend B is opened 24/7. I would've thought setting the recordset type as "snapshot" would prevent this? Is there anyway I can redesign this form so it doesn't locked up Backend B 24/7 too?
Thank you!
