Special access to the ole db Provider 'Microsoft. Jet. oledb.4.0 'has been denied. The provider must be accessed through the linked server.

Select * into tablea from OpenDataSource ('Microsoft. Jet. oledb.4.0 ', 'Data source = E: \ 2006. mdb')... wait

Executing this statement in the query analyzer always reports that "special access to the ole db Provider 'Microsoft. Jet. oledb.4.0 'has been denied. The provider must be accessed through the linked server. "

I checked the information and got permission questions. modify OpenDataSource ('Microsoft. jet. oledb.4.0 ', 'Data source = e :\\ 2006. MDB '; user id = ''; Password =''; invalid

I suddenly remembered that SA was not used for login. At that time, I used a common account.

Log in with SA and execute the preceding SQL statement.