An MS Access MDB file can only be accessed by ONE person/process. Once a CF DSN gets a hold of an MDB, no other person or process can touch it. You should explore using a "real" RDBMS that could handle concurrency across physical systems.
As for the scenario where you trivially modify a perfectly working Access DSN's name, and getting an error, it may be because the file was not properly released. I am not sure. :P ------------------------------- James Ang Sr. Developer/Product Engineer MedSeek, Inc. [EMAIL PROTECTED] -----Original Message----- From: Ruggiero, Kevin D [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 26, 2003 1:41 PM To: CF-Talk Subject: Very odd behavior with data sources. please help if you can I am getting the following error: BEGIN ERROR: Connection verification failed for data source: stdparts []java.sql.SQLException: SQLException while attempting to connect: java.sql.SQLException: [MERANT][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: SQLException while attempting to connect: java.sql.SQLException: [MERANT][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. END ERROR. This is happening within ColdFusion Administrator (CF MX). What is so strange is that this problem occurs sometimes, and not other times. In other words, I can setup a datasource to a network Access database, and it will work fine. I can then try to setup the exact same data source on the production machine, and it will get the error above. EVEN STRANGER is that I can then go back to my original data source that worked fine, modify it trivially (change the data source name), and I will begin getting the message above. Setting up these datasources works sporadically, with a tendency towards not working at all. The account ColdFusion is running as has full control to the file and share. Can anybody please shed light on why this is happening? I'm finding it to be a problem on my test machine AND my production machine. Is there any other way to setup data sources other than through the CF Administrator? Thanks. Kevin Ruggiero Northrop Grumman Amherst Systems ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
