Linking a database to access on Network path level

[Paul200968]

Hi there,

I want to link an excel sheet to my database but I dont want to link the location with a drive letter but instead linking the network address. How can this be achieved?

In addition, I want to startup application with a command line in a access macro and used this line but it doesnt work.

\\Tgsshs11data.nl.post.com\occ&sqa$\OPS_Processes\Reports\Awkward\test.txt

In general how can you work in access with network path strings?

best regards,


Paul.

 

[Robert88]

Hi Paul200968,

Never really placed a network path string with any of my code.

But thinking out a loud, normally you would map a network drive to a shared folder.

I do not know your shared folders but with your example below maybe;

\\\\Tgsshs11data.nl.post.com\occ&sqa$ is a share which I would designate a drive letter, Say, T:\ (Here is the drawback everybody who uses this has to have the same mapped network drive.

and then your path becomes T:\OPS_Processes\ Reports\Awkward\test.txt

I suppose this is a work around as not sure if you can use network strings in your path.

All the best with it.

Robert88