Rocky Smolin at Beach Access Software
rockysmolin at bchacc.com
Sun Dec 16 19:21:54 CST 2007
Since the drive letter can change as you move the USB drive from machine to machine, I think you have to refresh the links every time the app starts using the drive and path of the front end as the location of the back end. You can get the drive and path of the front end from, IIRC, set db=CurrentDb then strPath=db.Name. Then strip the right hand characters until you come to a \. HTH Rocky -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Darren D Sent: Sunday, December 16, 2007 4:32 PM To: 'Access Developers discussion and problem solving' Subject: [AccessD] A2003: Putting both Front and Back ends on a removabledrive Hi Team I have a client who has one of those portable laptop drives in a USB case - Cool He wants both the front and back ends of his APP to reside on this drive but wants the Front end and Back end to still remain separate - for ease of use of data backup - Cool also This means getting the front end to 'talk' to the back end without using drive letters etc In the old DOS days you could use a syntax (I have forgotten it) to simply refer to 'things' on the current drive and even current folder Does anyone know how I would go about linking the FE and BE on the same drives (In this case a removable one) thus without using drive letters etc? Many thanks in advance DD -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.503 / Virus Database: 269.17.2/1185 - Release Date: 12/15/2007 12:00 PM