Link to Access database

[DarkMan]

I need to link to an Access database I created in Access 97 and uploaded to an ftp server. I created a new ftp location and was able to see the directory in the link screen, but when I hit the link button I got the following message:<br>
<br>
'C:\My Documents\ftp:\\site.com\database.mdb' isn't a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides.<br>
<br>
The "located in" area only said ftp:\\site.com\database.mdb, does anyone know what is going on here and how to fix it?<br>
<br>
Thanks,<br>
Doug

 

[1manedp]

I don't know how to fix it but I can almost guarantee that there is a general property for your Access session that is actually inserting C:\MY Documents\ in front of all file locations. You might want to check the Tools, options area or right-click, Properties for just about anything that you might see as a superset to the link. Good Luck!

 

[DarkMan]

Thanks! I'll give it a shot and see what I can come up with....<br>
<br>
Doug