can microsoft access be used as a data source for asp.net?

by theweb · 2 Comments
in Questions and Answers

asp.net
Jamal J asked:


…or will i have to use sql??

I would rather use ms access as i have already created the database.

2 Responses to “can microsoft access be used as a data source for asp.net?”

Comments

  1. Tom B says:
    October 31, 2008 at 1:08 am

    Access can. The connection string will need to specify the Jet as the provider, such as the connection strings found here

  2. MrM says:
    November 3, 2008 at 9:16 am

    Sure.

    Try these OLEDB connections linked below in your web.config file.

    You can upsize to SQL Express pretty easy, if you want. Microsoft has a SQL Migration Assistant that makes dead easy. Link also below.

Share Your Thoughts

You must be logged in to post a comment.