Show a "loading" message while database is opening
- Thread starter janeyg
- Start date
- Local time
- Today, 06:19
- Joined
- Feb 28, 2001
- Messages
- 30,126
Another thing that might help has to do with that FE/BE split and what is open.
First, I NEVER EVER directly open a table in the backend. I open a query in the frontend and the query refers to the table. This allows me to set the query for optimisic locking, so the tables NEVER lock until I'm about to do something with them.
Second, I have one query that never dies from beginning to end of a session. This query is ALSO optimistic-locked, but it stays open. When the other queries open up their corresponding backend tables, the fact that an internal link is open with the same file specification somehow helps Access find the other tables faster. I.e. it "rides" the open connection rather than opening/closing connections all over the place.
First, I NEVER EVER directly open a table in the backend. I open a query in the frontend and the query refers to the table. This allows me to set the query for optimisic locking, so the tables NEVER lock until I'm about to do something with them.
Second, I have one query that never dies from beginning to end of a session. This query is ALSO optimistic-locked, but it stays open. When the other queries open up their corresponding backend tables, the fact that an internal link is open with the same file specification somehow helps Access find the other tables faster. I.e. it "rides" the open connection rather than opening/closing connections all over the place.
Hi Doc Man
I understand your first point, as I have all my forms opening from queries. I dont understand your second point though. How do you do this? I think my queries are optomistic locked but I would have to double check. It sounds like it might help. Could you explain more on 'one query that never dies from beginning to end of a session' please? I have my database set to locked on edited records due to previous issues with more than one person editing the same record. Does having a locked set to edited records mean - it locks the query? I am not sure how that bit works as I just check one query and it is locked to edited records.
thank you.
I understand your first point, as I have all my forms opening from queries. I dont understand your second point though. How do you do this? I think my queries are optomistic locked but I would have to double check. It sounds like it might help. Could you explain more on 'one query that never dies from beginning to end of a session' please? I have my database set to locked on edited records due to previous issues with more than one person editing the same record. Does having a locked set to edited records mean - it locks the query? I am not sure how that bit works as I just check one query and it is locked to edited records.
thank you.
Last edited:
- Local time
- Today, 12:19
- Joined
- Sep 12, 2006
- Messages
- 15,987
i haven't read the whole thread, but it sounds like a "persistent connection" may be the issue, and establishing one should improve opening times.
RainLover
VIP From a land downunder
- Local time
- Today, 21:19
- Joined
- Jan 5, 2009
- Messages
- 5,041
There are two of them. Each are located in thr same Folder as the Back end and the Front end.
Open them by clicking on them They should open in Note pad.
There are other people who claim to have written programs to do this but I have never seen one that is 100% accutate. Not to say that one does not exist, I just have not found one.
Open them by clicking on them They should open in Note pad.
There are other people who claim to have written programs to do this but I have never seen one that is 100% accutate. Not to say that one does not exist, I just have not found one.
Is this the padlocked laccdb file? When I double clicked it (front end) - it does not open, did not recognise the format? So I set to open i Notepad but it just displayed nonsence text. Should i be setting it to open something else? I now don't see the padlock icon, can't seem to change it back either. Don't quite know what I have done. Or I should have double clicked the back end one. Can you help, I am worried now that I have done something terminal ?
boblarson
Smeghead
- Local time
- Today, 04:19
- Joined
- Jan 12, 2001
- Messages
- 32,059
I didn't see this page referred to (I might have missed it, I'm currently experiencing a very slow Internet connection so it is hard to scroll through and read everything):
http://www.granite.ab.ca/access/performancefaq.htm
And one of the things that can slow things down quite heavily is if you have subforms which are on the form and combo's or list boxes which have a row source. So, like for subforms which don't need to be opened right away (might be on other tabs on a tab control) you should not have the record source assigned until you click on the tab to go there. And the same for combo's and list boxes. You can speed things up, or at least the perception of that, if you assign their row source at the time you need it and not right when the form opens, which is what happens if you have it set in the properties.
http://www.granite.ab.ca/access/performancefaq.htm
And one of the things that can slow things down quite heavily is if you have subforms which are on the form and combo's or list boxes which have a row source. So, like for subforms which don't need to be opened right away (might be on other tabs on a tab control) you should not have the record source assigned until you click on the tab to go there. And the same for combo's and list boxes. You can speed things up, or at least the perception of that, if you assign their row source at the time you need it and not right when the form opens, which is what happens if you have it set in the properties.
Dear Bob, thank you for your reply. I do have a subform (which is visible. not on a tab) and a combo box on my form. I also have a button which when clicked, opens a search form and is run by a query. My combo box runs from a query too as well as the subform. Can you advise how I do what you suggest? I am not sure what to check or how to go about this. I am not sure how to check or modify this.
Last edited:
