In Microsoft SQL 2005
I'm trying to import from a table of a password protected Microsoft Access database file, by using OPENROWSET command, but it's not working.
here is my code:
INSERT INTO Table01 (Col1,col2,col3) SELECT col1,col2,col3 FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0','c:\dbfile.md b';'Admin';'myPassword',Table03)
and this is a error message after I execute this query: "OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)" returned message "Cannot start your application. The workgroup information file is missing or opened exclusively by another user.".
Consider that, if I remove the Access database password, this query will work properly (with a (null) password of-course!).
