I'm struggling with a connection string.

[Coxroach1]

Hi All,


I am trying to use WinAudit to take hardware inventories of some domain-joined computers and add the result to an access 2016 Db

The bat file I have written which contains the connection string does appear to execute but no entry is made to the Db, nor any error given in the command window.

Any help with getting this working would be much appreciated.

copy \\lf-por-0079\Temp\Audit\Winaudit.exe c:\temppath\
cd c:\temppath
WinAudit.exe /r=g /f=DBQ=\\LF-POR-0079\Temp\Audit\Audit.mdb;Driver={MicrosoftAccessDriver(*.mdb)};UID=admin;

Thanks.

[Minty]

I'm not familiar with WinAudit, but do any of the examples here help?
https://www.connectionstrings.com/access/

[Coxroach1]

Hi, I have tried some of those examples and I think one of them may well be right but perhaps I am hitting a permission issue on writing to the Db. Any advice on confirming the level of permissions currently set or how to open write permission to all would be great.
Thanks.

[Minty]

Are you sure it's a db permission issue?
Try putting winaudit in your local documents directory , Win 10 doesn't play well with root folders and permissions.
If not it may be a network permissions problem.

I can't see why you would have a problem writing to a local DB?