Do you want different options for the DataStore?
Or for accessing the Access database?
For a different DataStore:
MSDE (a Sql server 2000 "lite" version)
SqlExpress (2005 "lite" version)
As far as talking/accessing an Access database:
And since you already have the data in an Access format, then ABANDON
Jet/DAO. I repeat, ABANDON Jet and Dao.
Check this site:
http://www.gotdotnet.com/Community/U...1-3781DF71DCDD
Which allows you to add OleDB ability to the June 2005 1.1
EnterpriseLibrary.Data library
http://www.microsoft.com/downloads/d...displaylang=en
You do NOT need to have Access (the program) installed to talk to an Access
database.
.............
You should also google "strongly typed datasets", and learn about the
DataSet.ReadXml and DataSet.WriteXml methods.
http://www.awprofessional.com/articl...&seqNum=4&rl=1
"gordon" <go**********@optusnet.com.auwrote in message
news:45***********************@news.optusnet.com.a u...
Hi
I have an application that currently uses ado.net to read some files and
populate a datagrid. The app allows users to search and return values
based
on a 'like' parameter in a select statement.
The data files have always been provided to me in MSAccess format and
users
have Access on their desktop (ie therefore it has been efficient to use
the
JET engine). I don't think that many users have local admin rights or SQL
server.
Now many users have lost MSAccess. I would like to find some alternatives
for my application.
My data has about 3000 rows and 6 columns - 2 of the columns contain text.
I am not expereinced with xml - but I can learn- but I was wondering if
there are alternatives out there that I could use?
Thanks
Doug