Back End Problems (if ya know what I mean!!!)

[AndWy]

Calling all 'clever dicks' out there...

I have a front end which is linked to the back end via the path set in 'linked table manager'.

Anyone know of a procedure to allow the end user (who will be using an MDE version of the front end) change the path of the database as and when required??.

The problem I've got is that although I can allow users to choose any path in the installation program, the installation cannot communicate with Access so the path set up in the front end before it is packaged up will always remain the same and the front end will not find the back end.

 

[gwinn7]

Yes, but its quite a bit of code to include in this forum. Is it that you want code snippet examples, strategy tips, or coding advice?

Gary
gwinn7

 

[AndWy]

Cheers for responding Gary, if you have the code it would be great if you could e-mail a copy to me (awykes@ntlworld.com) otherwise any help you can give me.