access thinks data is on C but it is actually on D

[buachille]

Hi,

after some effort i now have 2 databases set up that i use all the time to mail merge data into word documents. it is a much better system than i used previously and works great.

only annoyance i have is this. either because i have recently re-installed windows, or because i copy the documents and databases back and forward between my laptop and desktop computer, which use different drive letters for the main drives (i'm not sure which of these actions caused the problem), i now find that when i open any of my mail merge documents in word they open a dialogue box and are looking for the database on

C:\user\Documents\Files\database

when they should be looking on

D:\user\Documents\Files\database

how can i tell access to search on a different hard drive. i've searched and searched through the options but i cant find it. i had a similar problem once with word looking for all my docs on the wrong drive letter and i fixed that, but i can't fix it in access.

any help much appreciated.

thanks

 

[Malcy]

Hi
Have you tried <Tools> <Options> <General> and looking at the default database folder. You need to have the database open to get to it.
This might do the trick
Good luck

 

[buachille]

that could have been it. it was looking in the folder above the one it should have been looking in.

thanks