Web matrix - SQL / Access

[Papillon02]

Hi everyone,

Big problem. I'm in my final (university) and I use web matrix. The
problem is that I have to connect to access database and when I try
via the data / new connection button it asks me to connect to sql or
msde. I don't have the option to connect to an Access database. My
connection has to be local cause it's only for my university work not
for a company. Somebody know what to do ?

 

[Guest]

Is Access installed on that machine? Also You can download MSDE and use that
instead of Access. You should be using SQL or MSDE for a web project anyway,
even if it is for school.

 

[Stephanie Stephanie]

Hi,

Thanks for your quick response. Yes Access is installed on my computer.
I already installed msde on my computer and it didn't work properly. I
can't choose access database that I did in Access with WebMatrix.

 

[Jeff Dillon]

Try dropping a AccessDataSourceControl on your page.

But I too notice that in the Code window, it refers to a SqlConnection
object. But then on the Code window, open your Toolbox. You'll see the Code
Wizards, try using the SELECT Data Method. In this wizard, it lets you
choose your Access database.

jeff