Access ODBC DSN Only Works Once

[mikelegg]

I have a number of users trying to use OBDC DSNs to read/write to Access databases. When they set the DSN up in Plesk and test it it connects successfully. But in real world situations the database can only be read once and then it reports an "Unspecified Error -2147467259". I've given IUSR_domainname full permissions on the folder which the database in in so that the the ldb file will be able to be deleted.
But sometimes I can even see the ldb file sitting in the folder.

Does anyone have any suggestions?

 

[Mr.Incredible]

Hi,

Make sure what database files permissions was inherited from directory.

 

[mikelegg]

Yes, I've done that.

Basically, I'm going to tell all new clients that we don't support Access DSNs and that they should use a direct connection to the file using the Jet driver.

It makes wonder what Plesk is actually testing when it reports that the DSN is working ??