Hi. I'm working on an app in Visual Basic 2005 Express Edition that connects to an Access 2007 database (accdb file). I found the right connection string and am able to connect to the accdb file no problem. However, now I would like to use the Data Source Configuration Wizard to generate a typed dataset for me based on some tables in my accdb file. Unfortunately, the wizard only supports .mdf and .mdb files. If I try to connect to the accdb file, it fails.

As a workaround, I tried connecting to another .mdf file, then changing the connection string in my settings for the project. Then I tried to run the wizard again selecting the modified connection string, but it wouldn't let me.

So why won't the wizard connect to the accdb file? Is this a limitation of Express Edition? Do I need to shell out another $500 to Microsoft, or is there a workaround for this?

Thanks.