CODEWITHSUNDEEP
winformsms-accessado.netsql-server-express
JPJedi
JPJedi

Reputation: 1508

Need a better option then ms access

I have a Access database that I am using for a back-end to my windows form application.

Any good examples for using SQL Express for accessing the datafile so that Office or MS Office Runtime does not need to be installed on a users computer to use the program?

I am currently using ADO.Net but the program still requires

Upvotes: 0

Views: 136

Answers (3)

Ryan
Ryan

Reputation: 4668

If you are looking at scaling up to SQL Express I'd recommend looking at either the Entity Framework or Linq-to-SQL for your data access layer. (Though both should work fine against your Access database as well.) Here are some good quick start tutorials for each framework:

Entity Framework Quickstart: http://msdn.microsoft.com/en-us/library/bb399182.aspx

ScottGu's Linq-to-SQL tutorial: http://weblogs.asp.net/scottgu/archive/2007/05/19/using-linq-to-sql-part-1.aspx

Also if you don't want to worry about client installs, you'll need to place your install of SQL Express on a server and use it as a shared database. If you need a per-client database SQL Express is going to require additional installs on the client.

Upvotes: 0

Albert D. Kallal
Albert D. Kallal

Reputation: 49089

To my knowledge, all recent versions of windows starting from win 2000 onwards ships with all components needed to open and read an access database.

The only reason for installing Access would be if you using reports and forms and parts of the UI.

So, on any recent version of windows you can open and read a Access mdb file without the need to install anything – in fact you can using windows scripting and not have installed even any development tools or even any software beyond the default software on the windows box.

Upvotes: 3

Mike Vella
Mike Vella

Reputation: 10575

Have you thought of using SQLite?

Upvotes: 1

Related Questions