K
kevcar40
Hi
i have two databases one (source) exports to another table
the second (search) is linked to the second table.
the Export from the source happens when the dabase is closed.
No problems so far
i have linked the search dbase and the table(could be several)
problem is if they are both source and seach are open
the source database crashes because it is trying to export to the
table.
what i am thinking of doing is checking if the search is open
if it is stop the export
if closed export
i have been told that i could check using the DIr function
Could anyone tell me how to do this using VB or a macro function
thanks
kevin
i have two databases one (source) exports to another table
the second (search) is linked to the second table.
the Export from the source happens when the dabase is closed.
No problems so far
i have linked the search dbase and the table(could be several)
problem is if they are both source and seach are open
the source database crashes because it is trying to export to the
table.
what i am thinking of doing is checking if the search is open
if it is stop the export
if closed export
i have been told that i could check using the DIr function
Could anyone tell me how to do this using VB or a macro function
thanks
kevin