I am trying to create a SQL Server 2005 package to query an MS Access network database that uses a user defined workgroup and a userid and password to enter the database. I can enter Access as the SQL Server package owner and view the table I am trying to query via the package in an Access session. The package database owner has permission to the network folder and I define the Access userid and password when I create the database connection in the package. I can successfully test that connection and when I invoke the OLE DB Source Editor specifying the connection for table or view, the correct list of the MS Access tables is loaded. But when I try to preview the table that I want to query I get an error code 0x80040E09 with the message, 'Opening a rowset for 'tablename' failed'. Alternatively, when I try to import the Access table data into my SQL Server database via the Import Export Wizard I define the data source as Access, enter the filename, User Name & password but get an error message which says 'the workgroup information file is missing'. I think that's the problem. I believe the Windows' system workgroup default file for any Windowsâ€™ user is c:documents & settingsWindowsidapplication dataMicrosoftAccesssystem.mdw. I think I need to point either the package or the import task to the .mdw file that this Access database references, not to the default. But I don't see where to do that in either the Visual Studio package creation or the Import Wizard. Is the workgroup confusion the likely cause of the problem? Is there a way to point to a specific workgroup?