ensure proper permissions are on the directory that contains the Access database for the IUSR_<MACHINENAME> account (assuming IIS) to read and write.... might solve the problem
-----Original Message----- From: Ruggiero, Kevin D [mailto:[EMAIL PROTECTED] Sent: 24 March 2003 22:55 To: CF-Talk Subject: Problem with Access database connection I'm trying to connect to an Access 2000 database on our network. The file is on a file server in the same domain as our Intranet. I have the ColdFusion MX app server logging in as my own domain account, which has full access to the database. Connecting to local databases works fine. The database has no security on it- it can open for anybody. I'm using the Microsoft Access driver provided with ColdFusion MX. I'm running CFMX Updater 3. However, ColdFusion is giving me the following error when verifying the database, and it is happening for all network Access databases: Connection verification failed for data source: trymp []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. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
