Connecting to BackEnd Database

[iojbr]

Is there any way using ADO to connect to a backend database from a front end (also developed using Access) without specifying a specific string. My current backend resides on a network drive "L:\IMS Backend\IMS BE.mdb." I am asking because I want the front end database to be able to still connect to the backend if it gets moved to a different location in the L:\ Drive. Thanks in advance.

 

[Remou]

Perhaps you could map a drive or store the location in a table?

 

[joebb3]

Yes... Its VERY possible... In fact I do it with all of my databases... As long as the user doesn't mess with the filenames and directories, the database relinks itself if needed.

Have a look at the thread below to start.

thread705-1197525

Joe