I am trying to import data from MSAccess. when I choose the data source and
enter the userID and Password I get the following error:
************************************************** *
Error Source:Microsoft Jet Database Engine
Error Description:Cannot start your application. the workgroup information
file is missing or opened exclusively by another user.

Context:Error during initialization of the provider
************************************************** ***

I have tried the same thing before and it worked. I do not know what is
going on. I am new to SQL and I really need help. Thank you

Have a look at this link and there i a whole raft of information about
this problem

http://groups.google.com/groups?q=%2...r=&sa=N&tab=wg




Al wrote:
--


Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - SQL Server 2005 Integration Services.
www.Konesans.com

If the Access database database is password protected you have to specify
the path to the system database file in the Advanced properties of the
connection to teh Access database.

Rand
This posting is provided "as is" with no warranties and confers no rights.