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]]

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


--

 

[Teo]

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

For a professionnal use, is it completly stable ?

Thanks.

 

[Guest]

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

 

[William Stacey [MVP]]

Sql Server Express 2005. Free.

--
William Stacey [MVP]

| 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 !
|
|

 

[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 !

 

[Nobody]

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

 

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

Hi,

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

 

[Frans Bouma [C# MVP]]

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

--