Re: C# ACCESS database help

Jason,

Whatever you do, I implore you to not use Access. Yes, it's a personal
opinion, but I really don't find it useful for anything really.

Instead, use SQL Server Express. It is free, and you can deploy it to
all your users. The great thing about that is that if you decide to upgrade
the server to SQL Server, the code doesn't have to change.

However, if you have multiple users, are you sure you want to have
individual databases on each machine? Why not use SQL Server with the data
in one central place?


--
- Nicholas Paldino [.NET/C# MVP]
- mvp@xxxxxxxxxxxxxxxxxxxxxxxxxxx

"Jason" <someone@xxxxxx> wrote in message
news:eTRP1HKeHHA.1220@xxxxxxxxxxxxxxxxxxxxxxx
I've got a simple database that I need to create, and then I'll probably
use something like a data grid to display to users. It won't be anything
major, a few tables, maybe one relation, then just display, add, and
delete. Since I've never delt with anything that involves a DB, I have
been looking at alot of different C# books that have chapters on C# and
database's. My question is that I notice everything assumes I've got a
SQL serve which is fine, since it comes with VS 2005 so I could easily
follow along with those example, but when I go to deploy this to my users,
in which the Database and user interface will be installed onto the users
PC, will it work, since I wrote this with SQL?

I could easily get away with ACCESS and Jet database connections but
knowing nothing about databases, deleting cells, adding cells I find it
hard to find any good examples.

Anyone know of any good examples, books, tutorials that would talk about
such a thing?

Thanks ahead of time.





.

Relevant Pages

  • Re: why>?
    ... On your desktop-- you'll be running SQL Server behind the scenes. ... it isn't risky to allow end users to create databases. ... it is no more risky than giving you the ability to create spreadsheets. ... I'm not saying that Oracle and IBM are going away. ...
    (microsoft.public.excel)
  • Re: Please answer my queries for fresh Installation
    ... Moving SQL Server Databases ... Using WITH MOVE in a Restore to a New Location with Detach/Attach ... Disaster Recovery Articles for SQL Server ...
    (microsoft.public.sqlserver.server)
  • Re: Please answer my queries for fresh Installation
    ... You can restore MSDB as well as master. ... > SQL Server, It will create Master, MSDB databases. ...
    (microsoft.public.sqlserver.server)
  • Re: Moving SQL Server 2000 from NT4.0 to Windows 2003
    ... Detach your existing user databases, ... user databases (or RESTORE) to the new server. ... > Hey Steve, ... Windows 2003 will not allow SQL Server SP less than 3. ...
    (microsoft.public.sqlserver.server)
  • Re: The best elegant solution to override 65k rows limit in a sheet
    ... MDB is friggin dead.. ... SQL Server has taken over the world. ... than read-only access to central company databases. ... I learned to write queries in Access after an hours' ...
    (microsoft.public.excel)