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.
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.
