Sorry john, should have been clearer. I'll explain fully.
I run a front end back end for about 10 users, what i'm trying to do is to
improve the way the users front end is updated. At the moment when the front
end realises its ood it opens the update mdb using the shell function then
closes itself. The update mdb then copies the new mdb from the server over
the users current front end. Problem is this was the update doesn't know
where the users front end is kept so i've had to make sure all the users
store thier frontend in the same place, my docs for example.
I can open the update mdb using automation (getobject) this then allows the
users front end to pass the location of itsselft to the update mdb, but i
cannot figure out a way to then sever the automation connection allow the
frontend to close without the update closing aswell. I thought that maybe i
could open the update using the shell then connect some how, pass accross the
frontend filename, then close the connection and the front end allowing the
update mdb to do its thing.
Is this possible?
TIA
Rico
John Vinson said:
Hi All,
How would i, open a one database from another, pass some info between them,
then close the first database.
These are separate *databases*, .mdb files? What kind of information
do you want to "pass"?
I can pass info between them when i open the second using automation but
then cant close the first from the second. I guess the questions is, how do i
create a link to a database which is already open?
File... Get External Data... Link will let you link dynamically to a
table in a second database; you can also use a query using the IN
operator in the FROM clause:
SELECT <whatever>
FROM [LocalTable] INNER JOIN [RemoteTable] IN "D:\SomePath\xyz.mdb"
ON...
John W. Vinson[MVP]