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.

 

[Sergeant]

When you go File>GetExternalData>LinkTable...
You get the browse dialog. Just type or paste the complete UNC path in the file name line and click OK.