Which database ?

[Steven]

Hi,

I have to create an application using a database.
There won't be client/server access (only one user...).
What is the best solution ? Access ? MSDE ? Something else ?

Thanks !

[Frans Bouma [C# MVP]]

Steven wrote:

Hi,

I have to create an application using a database.
There won't be client/server access (only one user...).
What is the best solution ? Access ? MSDE ? Something else ?

firebird. http://www.firebird.org. You can use Firebird embedded, so
you can simply drop the .fdb file in a folder with the embedded dll and
it works, without a server, but WITH fancy features ms access can't
offer you. It has a mature .net provider and is 100% free.

FB
--
------------------------------------------------------------------------
Get LLBLGen Pro, productive O/R mapping for .NET: http://www.llblgen.com
My .NET blog: http://weblogs.asp.net/fbouma
Microsoft MVP (C#)
------------------------------------------------------------------------

[Teo]

Thanks.
The site is under construction...
I guess it's www.firebirdsql.org ?

For a professionnal use, is it completly stable ?

Thanks.

[Michael Nemtsev]

Access, if it will be really one user, and DB size up to 2gb (access limit)

I have to create an application using a database.
There won't be client/server access (only one user...).
What is the best solution ? Access ? MSDE ? Something else ?

--
WBR,
Michael Nemtsev :: blog: http://spaces.msn.com/laflour

"At times one remains faithful to a cause only because its opponents do not
cease to be insipid." (c) Friedrich Nietzsche

[Teo]

Ok, so for a single user Access is efficient ?
In fact i heard about corrupt databases with Access, that is what i was
afraid of.

Thanks !

[William Stacey [MVP]]

Sql Server Express 2005. Free.

--
William Stacey [MVP]

"Steven" <no**@none.com> wrote in message
news:e9**************@TK2MSFTNGP12.phx.gbl...
| Hi,
|
| I have to create an application using a database.
| There won't be client/server access (only one user...).
| What is the best solution ? Access ? MSDE ? Something else ?
|
| Thanks !
|
|

[Nobody]

What type of records in the database? How often will it be accessed?
How big will it grow?

"Steven" <no**@none.com> wrote in message
news:e9**************@TK2MSFTNGP12.phx.gbl...

Hi,

I have to create an application using a database.
There won't be client/server access (only one user...).
What is the best solution ? Access ? MSDE ? Something else ?

Thanks !

[Ignacio Machin \( .NET/ C# MVP \)]

Hi,

"Teo" <no****@nospam.org> wrote in message
news:OO**************@TK2MSFTNGP15.phx.gbl...

Ok, so for a single user Access is efficient ?
In fact i heard about corrupt databases with Access, that is what i was
afraid of.

With a single user is very good.

Additionally, if your data is not too big or you need to do complex queries
you can store it in a XML file
--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation

[Frans Bouma [C# MVP]]

Teo wrote:

Thanks.
The site is under construction...
I guess it's www.firebirdsql.org ?

For a professionnal use, is it completly stable ?

Thanks.

My bad, indeed that's the URL.
It's very stable. :)

FB

--
------------------------------------------------------------------------
Get LLBLGen Pro, productive O/R mapping for .NET: http://www.llblgen.com
My .NET blog: http://weblogs.asp.net/fbouma
Microsoft MVP (C#)
------------------------------------------------------------------------