This happens because someone has a lock on the access db Give the IUSR account full control over the dir where the mdb file and on the mdb itself. What is happening is that the LDB file (Lock file) is not allowing you access. When you open access it creates this file and allows 1 write operation and up to 10 read ops at the same time. Problem is when the IUSR account cannot clear this file.
Niall -----Original Message----- From: Wolf, Gene [mailto:[EMAIL PROTECTED] Sent: 21 August 2003 13:39 To: '[EMAIL PROTECTED]' Subject: Witango-Talk: Access and Witango I need the help of some of you Access guru's out there. I'm running in a Windows environment and I need to use Witango to read an existing Access file, massage the data and write the records to a SQL server database. Massaging the data and writing to SQL is not a problem, but getting the information from Access is. When I try to read the Access file I get the following message: Search [Error] [57] -1032 [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. S1000 [Error] [58] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed IM006 [Error] [58] -4 Unable to connect to the specified data source. Verify that data source is properly configured and that database server is online. Now the server is online and the funny thing is I can use the SQL Window of Witango to read this file. When I use a search action though I get the above error. Do I have to have a login ID and Password? If so, how do I assign one to this Access table? Any help would be greatly appreciated. Sincerely, Gene Wolf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf ******************************************************************** This message is intended only for the use of the person(s) ("the intended recipient(s)") to whom it is addressed. It may contain information which is privileged and confidential within the meaning of applicable law. If you are not the intended recipient, please contact the sender as soon as possible. The views expressed in this communication may not necessarily be the views held by LGCSB (Local Government Computer Services Board). Any attachments have been checked by a virus scanner and appear to be clean. Please ensure that you also scan all messages, as LGCSB does not accept any liability for contamination or damage to your systems. ******************************************************************** ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
