network drive paths as strings - access 2000 import files

[mudster01]

Hi All
i'm importing various excel files using transferspreadsheet from a network dir, & the dir filepath is defined in a form bound to general details table e.g strpath =

"F:\temp\import.xls"

...however now other people are using this database the required dir may be mapped to another letter drive on their system & want to avoid changing the path each time.

I have tried replacing the F:\ with "\\" & obv putting in complete server path but this doesn't seem to work - err msge "not a valid path".....

Is there anything additional i need to do? Or doing wrong?

Thanks in advance.
M

 

[Robert88]

Hi mudster01,

The F:\ Drive you mention will be a network share, that share will have a computername and network sharename.

You could substitute it for \\computername\sharename\.........

Good Luck

Robert88