I am developing an Access DB that will reside on a networked PC that I want
to access from any PC connected to the network. I will have an access front
end connect to the backend db. I am developing this for a friends business
and he will have probably 8 or 10 PCs to connect all networked. I do not want
to connect using ODBC because I will not be there to be sure it is done
correcty. I just want the link to be Access file to Access File. I need a
routine to locate the db on the networked PC through the File System. The
network drive will be mapped. How can I do this. I think I would want to
check to see if the tables are linked properly and if not, the routine would
find the file and refresh the link automatically without user interaction.
Any help would be greatly appreciated!