I am trying to access the MS-access file from S3 location. But when i am trying to access i am getting the below error message. i suspect there is something wrong only on the JDBC URL from the Generic Database Account connection. Below is my URL.
JDBC URL : jdbc:access:///S3:///umg-ers-royalties-uat/RoyNEWSCA5.accdb
Note: i am able to access flat file through the same S3 location. Please advise
Failed to validate account: Failed to retrieve a database connection. Cause: S3:///umg-ers-royalties-uat/RoyNEWSCA5.accdb doesn’t exist or can’t be accessed. If you’re using mapped drives to access database files, you may need to check the security permissions. (Reason: S3:///umg-ers-royalties-uat/RoyNEWSCA5.accdb doesn’t exist or can’t be accessed. If you’re using mapped drives to access database files, you may need to check the security permissions.; Resolution: Address the reported issue.)
