Linking tables after installation

[Paul]

I have created an installation package with the deployment wizard and have
come across a bit of a problem. I am deploying a BE/BF solution. The front
end is packaged with the links that were set up on the development machine.
When I install the package on a new computer, the lniks in the FE are no
longer valid since the application is loaded in a different location than the
development machine. When the new application opens there are many errors
generated since the BE can't be accessed. What can I do to resolve this? Any
assistance would be appreciated.

Thanks!!!

 

[Douglas J. Steele]

Add code to your application to allow the users to relink the tables. Check
http://www.mvps.org/access/tables/tbl0009.htm at "The Access Web" for one
approach.

 

[Paul]

Thank you for that response Doug.

I already have such code used for other purposes. I was just hoping that
this would be handled during installation and transparent to a novice
installing my application. I will proceed as you suggext. thanks!!!

 

[Paul]

I have implemented your recommended solution to have my users relink at
startup, however I have come up with an unexpected problem. Its seems, the
user has to be a member of Admins to relink tables. Is that true, I can't
seem to find what permissions are required? Thanks!

 

[Paul]

I have been struggling with this all day. I came accross this passage in Help
under Permissions Types.

"In general, if you want users to be able to access a linked table, grant
them Read Data and Read Design permissions on the table in the back-end
database, and Modify Design permission on the table link defined in the
front-end database so that they can conveniently re-link the table. If you
want to restrict all access to the back-end table but still allow users to
view the data and re-link the tables, remove all permissions on the back-end
table and use queries in the front-end database with their RunPermissions
property set to Owner's. "

This exactly the way I am setup and this doesn't work. One way I can make it
work is to give users Modify Design in the BE tables, but if do that then the
BE is vulnerable again. Can someone please help clear this up for me.
Thanks!!!