Hello,
I am in a phase that i have frontend that i distribute to some network users through a copy procedure and some backend databases with linked tables. Well my question is, how can access database frontend understand if there are no ldbs, no users have opened the backend tables so to compact them.
*I know how to write code to test if there are users inside the database, and through a macro via a scheduled job on the server to run the code and do the compact, but i would like to tell me if i could do that by itself,
without a scheduled job eg every 30 mins. Can access understand by itself that no user is logged in so to do a compact on the backend?
Thanks in advance.
I am in a phase that i have frontend that i distribute to some network users through a copy procedure and some backend databases with linked tables. Well my question is, how can access database frontend understand if there are no ldbs, no users have opened the backend tables so to compact them.
*I know how to write code to test if there are users inside the database, and through a macro via a scheduled job on the server to run the code and do the compact, but i would like to tell me if i could do that by itself,
without a scheduled job eg every 30 mins. Can access understand by itself that no user is logged in so to do a compact on the backend?
Thanks in advance.
