Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Linked Tables - Who is linked to Me???

Status
Not open for further replies.

GummowN

Programmer
Jul 26, 2002
157
GB
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.
 
Can you not look at the .ldb to find out who has opened your back end

Hope this helps
Hymn
 
I am sure I can find some code to read the ldb - but does that give the database that is being used when the backend is being used?

I was hoping someone had done something similar. I dont know whether Access stores in teh backend those databases that link to it??

If at first you don't succeed, try for the answer.
 
Thanks for the help but it doesnt really help. I have no idea when databases attach to this databases so unless I run a timer event every minute to read the ldb extracting the name of the database attached - which I didnt think was in the LDB just the computer name and username.

I have however devised a cunning plan - break the database - I have setup a validation rule on the table - it will prevent this data change. Should work unless someone is deleting the table and putting a new copy in - I will know in an hour or so

If at first you don't succeed, try for the answer.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top