I have adopted a number of undocumented databases - all of whom serve multiple purposes.
Strange behaviour has been noted in a data table which none of the queries seem capable of achieving. I have checked the code in the databases I know that use the data table and no luck.
I know in a Front end database the following returns the back end datasource:
currentdb.tabledefs(strTablename).connect
So here is the question:
Does the backend store which databases connect to it for each table? When it was last accessed?
The second bit is a would like, the first is a want.
Any ideas.
Thanks in advance - I normally can do most things but sometimes there are people out there who have done these strange things before
If at first you don't succeed, try for the answer.
Strange behaviour has been noted in a data table which none of the queries seem capable of achieving. I have checked the code in the databases I know that use the data table and no luck.
I know in a Front end database the following returns the back end datasource:
currentdb.tabledefs(strTablename).connect
So here is the question:
Does the backend store which databases connect to it for each table? When it was last accessed?
The second bit is a would like, the first is a want.
Any ideas.
Thanks in advance - I normally can do most things but sometimes there are people out there who have done these strange things before
If at first you don't succeed, try for the answer.