VB Forum / Database Access / June 2007

I have a application developed in access using link tables to Sybase,
this application has many queries running locally on access for the
linked tables(cannot run it on the Sybase, because the queries
contains combination of linked and local tables in it), due to which

I figured it out.  Setting the ValueMember to the ID, and using
selected value.

Here is my SQL:
SELECT tblIssue.IssueNumber, tblFacility.FacilityName,
tblIssue.IssueBrief, tblIssue.IssueStatus FROM (tblIssue INNER JOIN
tblFacility ON tblIssue.FacilityID = tblFacility.FacilityID)

What syntax would I use to initialize a Data environment's database
name/path via code?
I'm using a function named GetDataPath  to do a GetSetting, to retrieve a
stored db path.