How do I connect a data access page to a database that is stored on the third hard drive of a server (E
?? It is for use over a small office intranet. I use the browse directory button on Access 2002 to find the database I need, it then connects to the directory "E:\\mainserver\server_e(E)\program files\microsoft office\db1.mdb" However, when the page is accessed from a different computer it doesn't work because the computer tries to look inside of its own "E:" drive. I had this problem before when I was running a database off a computer with one hard drive. I removed the drive prompt and it worked perfectly fine. However when I try the same fix on this server with 3 hard drives, it isn't even a valid connection because it only searches the first hard drive. Is there a way to fix this without storing the database on the first hard drive. Any help would be most aprreciated. Thanks in advance,
Luke Hoektra
?? It is for use over a small office intranet. I use the browse directory button on Access 2002 to find the database I need, it then connects to the directory "E:\\mainserver\server_e(E)\program files\microsoft office\db1.mdb" However, when the page is accessed from a different computer it doesn't work because the computer tries to look inside of its own "E:" drive. I had this problem before when I was running a database off a computer with one hard drive. I removed the drive prompt and it worked perfectly fine. However when I try the same fix on this server with 3 hard drives, it isn't even a valid connection because it only searches the first hard drive. Is there a way to fix this without storing the database on the first hard drive. Any help would be most aprreciated. Thanks in advance,Luke Hoektra