I need to create a macro to open a network. I have a button on my form that sends all of the data to one place, 'OCA6', the problem is that sometimes the network dosen't appear to be open, therefore when I click the button it throws up a debug error. To overcome this I have to go to My Computer, Network Places and double click 'OCA6', this then creates the link. I can then close the window and continue with exporting the data by clicking on the button with no debug errors. Any help appreciated, thanks!

maybe you problem is not in access...

have you tried mapping a 'network drive' to this 'OCA6' location ?

you could then just call the drive letter from your macro