Split database loses directory path.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I split my database into a FE and BE all within the same folder. Now when I
move the folder the BE loses its directory path. Is there any way I can tell
the FE to always look for the BE within the same folder that the FE is in.
 
Take a look at the code in http://www.mvps.org/access/tables/tbl0009.htm at
"The Access Web"

Replace the section of code

strMsg = "Do you wish to specify a different path for the Access
Tables?"

If MsgBox(strMsg, vbQuestion + vbYesNo, "Alternate data source...") =
vbYes Then
strNewPath = fGetMDBName("Please select a new datasource")
Else
strNewPath = vbNullString
End If

with code that determines where the front-end is and generates the back-end
name from that, setting strNewPath to that value.
 
You can double check if your FE link table point to your BE. Go to Tools -
Add-ins - Link Table Manager and redo your link. Might work.

Yanick
 
Back
Top