How to change source of linked tables after compiling Frond End

[saudkazia]

Suppose I have a front end and backend (tables) database which I want to deploye. Currently Access tries to find the backend in the same absolute location (rather than relative position). This causes a problem as drive letters change and sometimes I would want it in a specific location on my computer and another place on deployed computer. Is there anyway to change source of linked tables after compiling to ACCDE

[JamesDeckert]

http://www.jstreettech.com/downloads.aspx

or if doing it manually, use the linked table manager (right click a table)

[saudkazia]

manually is fine. but how will that work. Access will not allow table or query view once compiled

[JamesDeckert]

You can add the Linked Table Manager to your ribbon.