Hi pat Phelan, Thanks for your response. I am using VB 6.0. There is an ado Object on my Form. I used the ConnectionString to link the VB to Access. The issue is that by using the connection string, the computer sets the path automatically which I cannot change.