Using MS Access as a .NET Application Backend

Question

I am a lonely .NET developer in a non-IT organization. I was asked to develop a .NET application using Microsoft Access as an internal (existing database).

I don’t know where to start.

As I myself am developing, what should I consider in order to avoid development? In what situations does only one developer work?

Please include a specific Microsoft Access tip in your response, as this is related to the question.

Answer 1

Where to begin?

• ( Visual Studio 2008 Express Professional, Professional)
• : !!!! (Subversion , )
• .NET Framework (3.5 , Win2K, Win2K .NET 2.0)
• (# VB.NET, )
• GUI- ( WinForms, - )
• (ADO.NET , , ADO/OleDB DAO)
• EDIT: Google, . , #, OLE DB MS Access DB. .
• EDIT2: "Microsoft Access" ( Office). , , , , , . VBA SQL , # VB.NET

• EDIT3: . , , / ,

  • ASCII CSV ( )
  • HTML XML
  • Excel
  • PDF, Report.NET
  • , Crystal Reports

  , " .net" Google, .

, , SO , , .

, , . , F#, WPF Linq Entities.

Answer 2

, , . .Net, .

:

, MS Access :

• - MS Access * EDIT: , - Microsoft , 100 - *
• - MS Access , (SQL Server, Oracle, MySQL)
• SQL - , MS
• . MS Access , SQL- (command.Type = CommandType.Text)
  5. , Microsoft Access, 2 - .

:

• MS Access ? , - MS Access Visual Basic (VBA) , /, , , VBA VB.Net

• , ?

• - /DLL,

  • EDIT: , ADO.Net , , - /DLL, //. SQL- . *

• , , .

• - - , , , . ( //)

• - USB-

Answer 3

, , , . :

• Access.mdb
• OleDbConnection
  • , , using - .
• () OleDbCommands ( , db ), ..

Answer 4

.NET MS Access, MS Access .NET, ///. peice, GUI/ (dll) .. .

.NET Linq to SQL (ORM) MS Access, - ( !).

MS Application #.

Answer 5

Access NHibernate? , Microsoft Access, , , , .

Answer 6

, , , . , , MS Access .