I made an accde data database that is linked to an accdb.
When I put a password on the accde dlookup is very slow.

I did a test of 10 dlookups.
With password it takes 8.46 seconds.
Without password only 0.39 seconds

Is there a solution to get the dlookup fast in combination with a database password?