Access2 Attached Tables Pathing on Network
Posted on 1997-11-05
We are running an MS ACCESS 2 application where the data is stored in a separate database from the "front end". The "front End" (Run Time version) is installed on each work station while the data mdb is to be installed on a LAN. The tables from the data.mdb are attached to the front end mdb and are shared among multiple users. Rather than installing the data.mdb by pathing it to a specific drive (ie H:\directory\data.mdb) we have been told to use the universal naming convention (UNC) to identify a specific location on the LAn (ie \\Server_name\location\directory\application) without identifying a specific drive letter. Can this be done in Access 2. If so, HOW do we do it?!! Any assistance would be greatly appreciated!