Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  Import/Export (DTS) and Replication (2000)  Error during importing MS Access database

Author  Topic  raghava Starting Member 3 Posts Posted - 2006-01-27 : 03:56:40 hi I need to import MS Access database into SQL Server database. I am successfully importing it using DTS->all tasks->import data. but the problem is one of my Access databases is having some special security features. that's why I am unable to import it. the error is......................... =============================================================== Error Source: Microsoft OLEDB provider for ODBC drivers. Error Description: [microsot][odbc microsoft access driver] u do not have the necessary permissions to use the (unknown) object. have ur system administrator or the person who created this object establish the appropriate permissions for u. context: error during initialization of the provider. ============================================== I don't know the security settings of that Access database. anybody pls help me in this regard. best regards raghava.