Recent content by fireball

ok well this doesnt work, i want to automaticly like a access and excel file, and the link i ws given dont allow u to do that. does any one els know how i can do this??? the code would be helpfull seeing as i dont know how to do it. thanks

ok, cheers for that info will check it out 2moro

ok cool, dont supose some one could give me the vba code for it as i wouldnt know where to even start.

I have 2 files one is a excel document and the other is an access document, i have a linked table between the two. the problem i have is that when i move the files to a different location i have to update the link to the file manualy, is there a way for access to automaticly update the link...