Can anyone help me change a link to attached tables relative rather than absolute?

I recommend staying with the absolute link. If your databse is distributed, a relative link will cause you trouble when all PCs are not mirror images of one another.

If your application is distributed within your organization and all instances will link to the same shared tables, use the UNC notation for linking rather than drive\directory.

If the problem is that installation is out of your control, you will need to add a relinking option that pops up when the database opens if it can't find the back end. You could write code that automatically changes the location of the be based on the location of the fe but I would prefer to let the user do the navigation. That gives them the option of placing the be wherever they want.