1) Create a FUNCTION with a STRING data type to hold the address of the back end database.
Public Function BackEndLoc() As String 'BackEndLoc = "\\zeus\family\My Documents\Richard's Work\license_keys_beCS.adp" '...............that is the client's location for the file as _ installed. It is commented out as I am working on it locally BackEndLoc = "\\zeus\family\My Documents\Richard's Work\license_keys_beCS.adp" '...............that is the location of my development backend dummy _ data. This is currently active. I will switch the comment-outs when I _ send an update to the client. End Function ================== 2) Declare a STRING variable inside the Form_OPEN procedure to hold the result of that function. Then assign the function to the string: Private Sub Form_Open(Cancel As Integer) Dim BE_Path As String ... BE_Path = BackEndLoc() End Sub ================================= I got this code from another Access Yahoo group I belong to, AccessDevelopers. You might check there for more detials. http://tech.groups.yahoo.com/group/accessdevelopers/ --- In [email protected], oc_for_me <[EMAIL PROTECTED]> wrote: > > Given the pathname, MDB filename , and table name , how would I > programmically (using VBA) link the above table from within Access > application. > > I have an MS-Access application (MASTER.MDB) which creates a NEW mdb > file & table say (C:\TEST\DATA-2007.MDB, tablename: DATA-2007). From > within MASTER.MDB, how would I link the new table to MASTER.MDB? > > Thank you! > > Dennick >
