Problem accessing an MDB file

Classic Servoy
1

Hi,

I´m having and strange problem. I have purchased and installed the MS Access JDBC from HXTT. In my development machine it works perfectly, but when I create the database server in the production machine I get an error saying that the file does not exist or I do not have rigths to access to it.

The only difference is that the development machine is pointing to a local copy of the MDB file, while the production one is pointing to a UNC path, like jdbc:access://///192.168.1.10/DBPruebas/MyData.mdb

I can access to that path if I type \192.168.1.10\DBPruebas\MyData.mdb, I can map a drive to that path too, I can write on the MDB if I open it from MS Access, using the UNC path.

The Servoy Server is on a machine that has an Administrator user, the same is user has been created on the server that keeps the MDB file, with the same password, etc.

Where might the problem be?

Thanks in advance.

2

I´ve got the solution.

Seems to be a Windows security issue. Just changing the account that is running the Servoy Server from Local System to another one. I created an account to do that and that was just enough.

Maybe this can help others in the future.