Value from outside Database

[Katrina]

I have a database that will be stored on various people's
hard drives. I have the master version of this database
stored on the network. What I would like to do is to have
the harddrive database look onto the network to get a
value.

Is this possible?

Katrina

 

[Rick]

Yes, add a table that is linked to a back-end on the LAN. For example, my
users have a front end on their PC that gets all it's data from a back-end
on the LAN. I also have one table in the front-end that is not linked. It
is called 'local version' and has only one field 'versiondate'. There is a
similar table in my back end called 'master version'. When a user opens the
database, my startup form compares the 'local version' and the 'master
version'. If they do not match, the database is closed and a batch file
runs to copy the master copy from the LAN onto their PC.

HTH

Rick

I have a database that will be stored on various people's
hard drives. I have the master version of this database
stored on the network. What I would like to do is to have
the harddrive database look onto the network to get a
value.

Is this possible?

Katrina