We have created a databse in Access2000 for use over a LAN.
This has been split so the back end is on one of our serves and the front end on the workstation.
The reference to the back end used a UNC to prevent reliance on a specific mapped drive letter, but performance is poor.
We suspect we may be better off mapping a drive letter in the login script and referring to our back end through that.
Question - how do we unsplit/rejoin the database so we can split it again. (do we have to map each query to its new location - hopefully not - or can we point to it in a single place in the database)
Constructive comments please, even if there may be an obvious answer we have missed.