Hi Rob, no my db is not corrupted and works fine. tried the code and it works great thanks! By your inference then if Setting the oApp as a new Access application was creating a second connection then changing the Set to Get in the VB code should work as well? Definitely gives me something to play with!

Thanks, Lol