relinking backend

[togo]

So I was thinking of using code like this:

If Dir("Drive:\foldername\") = "" Then
 'connection not available

to tell whether or not the original is still connected over network drive. However, how do you switch the path to a local backend on C drive using VBA (simplest way possible please!)?

thanks

[orange]

see https://www.accessforums.net/program...les-20115.html