Sunday, February 24, 2008

How To Open MS Access database in CGI?

I have encountered a problem to open MS Access database from Delphi executable CGI. I always end up with the error "Unspecified error". I figured it out that it must be security issue. MS Access will create a temporary file whenever it is opened. The question is where? After surfing the internet, I found that the temporary file would be created in %temp% folder. But under which profile? After some trial and error, my executable CGI worked after I have granted folder "C:\Windows\ServiceProfiles\NetworkService\AppData\Local\Temp" with full control right to "IUSR".

No comments: