Re: Any input about what causes slowdown?
Brad, that is making strong sense to me. I think my server technician has talked about doing something similar but, as I said, seems to not have much time to focus on it.
Edhy, I have written solid update code in a 'master' Access db that goes and updates all the backends as needed with a click of a button. It adds tables, fields, updates queries, etc., etc. to back ends by looping through and linking to them. One procedure also runs through and does the Access compacting maintenance, etc. of the files every night, also. After 15 years of dealing with my multiple back ends, the management of multiple back ends doesn't concern me. And Alpha was great a few years ago in getting their Multi Tenant Dynamic Connection to work very well for me. I appreciate your concern about that, though, for someone who might be considering it. It took some work to get the maintenance tools designed for the multiple files.
I even have code that runs through all the back end data files and counts their table relationships every night so we know right away if database is in trouble... Which is hardly ever.. Losing a relationship usually happens when a record becomes corrupted for some reason, so counting relationships is is a good test...
Brad, that is making strong sense to me. I think my server technician has talked about doing something similar but, as I said, seems to not have much time to focus on it.
Edhy, I have written solid update code in a 'master' Access db that goes and updates all the backends as needed with a click of a button. It adds tables, fields, updates queries, etc., etc. to back ends by looping through and linking to them. One procedure also runs through and does the Access compacting maintenance, etc. of the files every night, also. After 15 years of dealing with my multiple back ends, the management of multiple back ends doesn't concern me. And Alpha was great a few years ago in getting their Multi Tenant Dynamic Connection to work very well for me. I appreciate your concern about that, though, for someone who might be considering it. It took some work to get the maintenance tools designed for the multiple files.
I even have code that runs through all the back end data files and counts their table relationships every night so we know right away if database is in trouble... Which is hardly ever.. Losing a relationship usually happens when a record becomes corrupted for some reason, so counting relationships is is a good test...
Comment