access database issue

[dwd1]

after upgrading to CF7 from cfmx one of my datasources (to an access database)
will no longer verify. the error that is thrown is as follows:

"The Microsoft Jet database engine cannot open the file '(unknown)'. It is
already opened exclusively by another user, or you need permission to view its
data."

the permissions on the file have not changed and the file is definitely not
opened exclusively by anyone - so is there something different about
permissions with cf7? the iusr_servername has full control of the file. is
ther another user that needs access?

[jdeline]

Make sure no users are on the database and then delete it's .ldb file.

[dwd1]

yes I already did that - i actually rebooted the server that houses the access
database so there isdefinitely no ldb file an i am positive that nobody else
had it open. so it leads me to believe it may be more so a permissions problem
but i just don't knwo what that problem is.

[paross1]

Could it be possible that when you upgraded to CF MX 7, you installed it under
a user account (like admin) that does not have permissions on the server that
"hosts" the Access database? Usually, if you use Access databases on servers
other than the ColdFusion server, you need to install ColdFusion under an
account that has read/write privileges on the server where the database file
lives. Just a thought.

Phil

[dwd1]

i dont think thats it because i installed it logged in as myself. my username
is a member of the domain admins group which definitely has full access to the
file - i also went as far as to explicitly add my usernamewith full control and
it had no effect.

[paross1]

To be sure, you can check your CF processes in Services on the ColdFusion server to see if the Log On As is your ID, insead of LocalSystem, which would be the admin account.

Phil