Access an accdb file stored on a Webdav server

[Edoedoedo]

Hi everyone,

I know how to create a libname to read an accdb file on my pc, and I know how to read a file on a webdav server using the "filename webdav" statement.

Now, we have an accdb file stored on such a webdav server. I need to "mix" the two access mode to directly read the accdb file on the webdav server not just as a file, but as a database with the Access engine.

Is that possible?

I mean something like:

libname test webdav 'http:/server/path/database.accdb';

proc print data=test.table;
run;

Thanks a lot

Greetings

[Kurt_Bremser · Accepted solution]

Look here:

SAS(R) 9.3 Statements: Reference

You can combine a libname with a specific engine with webdav access and the appropriate webdav options.

So you could try if

LIBNAME test ACCESS 'url' WEBDAV USER='userid' PASSWORD='password' WEBDAV options;

works.

[Edoedoedo]

Thank you very much!