DDT.CSVDriver is not Working
Hi Following Statements throwing Error Set Driver = DDT.CSVDriver ( FilePath) colCount = Driver.ColumnCount
Forum Discussion
1. | This commonly occurs when your database file is opened exclusively by another application (usually MS Access MS Excel). Close all applications that use this database, all instance of Excel and try again. |
2. | This error may occur if the account being used by Internet Information Server (IIS), (usually IUSR), does not have the correct Windows NT permissions for a file-based database or for the folder containing the file. |
3. | Check the permissions on the file and the folder. Make sure that you have the ability to create and/or destroy any temporary files. Temporary files are usually created in the same folder as the database, but the file may also be created in other folders such as /Winnt. |
4. | If you use a network path to the database (UNC or mapped drive), check the permissions on the share, the file, and the folder. |
5. | Check to make sure that the file and the data source name (DSN) are not marked as Exclusive. |
6. | Simplify. Use a System DSN that uses a local drive letter. Move the database to the local drive if necessary to test. |
7. | The "other user" might be Visual InterDev. Close any Visual InterDev projects that contain a data connection to the database. |
8. | This error may also occur when accessing a local Microsoft Access database linked to a table where the table is in an Access database on a network server. In this situation, please refer to the following article in the Microsoft Knowledge Base for a workaround: |