What applications are trying to read and/or write to these .mdb files? It
could be an NTFS permissions issue regarding the files themselves as opposed
to a misconfiguration problem with ODBC.
I ran into a similar problem when I installed whatever version of MDAC was
available with SP4.
If you're running into problems with webpages not being able to do stuff
with the .mdb files, here's some info that might help (I wrote it for myself
as well as our other support people):
Requirements for websites to interact with databases
----------------------------------------------------
Access (.mdb files)
-------------------
For any given website, all .mdb files should be placed in a single
directory, such as "db" or "data", etc.
For this single directory:
NTFS permissions:
.asp file interaction: IUSR_webservername: Change (RWXD)
.cfm file interaction: IUSR_webservername: (remove user)
IIS4 permissions (prevent visitors from downloading the .mdb file):
Directory Access permissions: uncheck all
Directory Content Control: uncheck all
Permissions: None
Josh Hillman
hillman@talstar.com