Connecting to MS Access Datasource

[Scooby Doobie Doo]

not working for me, I have the same exact issue.

[HKVan1]

I have a mapped drive ,Z: which points to \\Hartlanddc1\Access\, and have
entered the unc path in the "database file" area in the CF Administrator.
\\Hartlanddc1\Access\MIS\MIS.mdb

I get the following error...
Connection verification failed for data source: IntranetMIS
[]java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][ODBC
Socket][Microsoft][ODBC Microsoft Access Driver] 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 root cause was that: java.sql.SQLException: [Macromedia][SequeLink JDBC
Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] 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.

I've been looking around through the forums and see a couple other items
related to this that talk about setting permissions on the ODBC Services, and
on the Access Database. I'm not exactly sure where to find the permissions on
the ODBC Service, and I have tried setting my admin account to have full
permission on the database.

This is a brand new server running CF MX 6.1, on a Win2003 Server SP1.

On my old CF 4.5 server (also Win2003) I have a mapped drive, and the mapped
letter in the "database file" area of the CF Administrator, and the connection
to that datasource works.

If you have any suggestions, please let me know.

Thanks,
Heather

[cgsj_usa@yahoo.com]

You can modify the permissions on the ODBC services by going to control panel,
then the administrative tools and then services. Look for ColdFusion ODBC
Server or something like that. I don't remember the exact name right now.
Hope that this helps. Thanks.

Chris

[HKVan1]

That did it! Thanks!

[cgsj_usa@yahoo.com]

Glad I could help.

[cltuxbu]

I'm having a similar problem with CFMX 7 running on a windows XP Pro server. We
have server instances setup and running, and everything is working fine with
all of the SQL Server datasources. But, when I try to add an Access datasource
I get this error:

Unable to update the ColdFusion MX 7 ODBC Server.
An exception occurred when invoking an external process.
The cause of this exception was that: java.io.IOException: CreateProcess:
D:\JRun4\servers\MOST.org\cfusion.ear\cfusion.war\ WEB-INF\cfusion\db\slserver54\
admin\swcla.exe -i
D:\JRun4\servers\MOST.org\cfusion.ear\cfusion.war\ WEB-INF\cfusion\db\slserver54\
admin\MOST.inp error=2.

If I try and delete the unsuccessful datasource, I get the CF gray screen of
death error message in the CF Admin. It says:
An exception occurred when invoking an external process.
The cause of this exception was that: java.io.IOException: CreateProcess:
D:\JRun4\servers\MOST.org\cfusion.ear\cfusion.war\ WEB-INF\cfusion\db\slserver54\
admin\swcla.exe -l dsd 'Macromedia ColdFusion MX 7 ODBC Server' 'MOST' error=2.

The error occurred in _sl54del.cfm: line 12
Called from msaccess.cfm: line 56
Called from msaccess.cfm: line 39
Called from msaccess.cfm: line 1
Called from _sl54del.cfm: line 12
Called from msaccess.cfm: line 56
Called from msaccess.cfm: line 39
Called from msaccess.cfm: line 1

-1 : Unable to display error's location in a CFML template.

I've tried the solutions listed below, but it's still not working. Does
anyone have any other suggestions? It looks like it's some sort of permission
problem writing into the jrun folder, but I'm not sure.

Thanks,
Cathy

[Unregistered]

That did it! Thanks!

Recently I encountered the same error on my app (Coldfusion & MS Access 97).

[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Cannot open database '|'.

What does permission have to do with this issue? Sorry, I'm a newbie just trying to learn :) My app was working fine until 2 weeks ago. And a handful of accounts' ID field (primary key) is being replaced with a checkbox and a + sign; although the real value is still there (hidden) and could be retrieve via query. When I tried to correct the IDs to its true value, Access errored out and closed the db. Your help is greatly appreciated.

-tk-